↓
 

The Place For Free Online Training Courses

Improve Your Career Prospects

  • Home
  • Office Software
    • Understanding Spreadsheets
    • Advanced Spreadsheets
    • Understanding Word Processing
    • Advanced Word Processing
    • Understanding Presentations
    • Advanced Presentations
    • Understanding Databases
    • Advanced Database
    • Math
  • FaQ
1 2 3 4 5 >>

Category Archives: Advanced Spreadsheets

Post navigation

← Previous Post

Advanced Spreadsheets Quiz

The Place For Free Online Training Courses
Take lesson

Advanced Spreadsheets – Security

The Place For Free Online Training Courses

Add, remove password protection for a spreadsheet: to open, to modify. To add password protection for a spreadsheet, click on ‘File’ from the main menu bar and from the resulting drop-down, click on ‘Save As’. This will open the ‘Save … Take lesson

Advanced Spreadsheets – Accept, reject changes in a worksheet.

The Place For Free Online Training Courses

When the spreadsheet in which the changes have been made is sent to someone else, then they can accept or reject the changes and keep only the ones which are required. To accept or reject changes, simply click on ‘Edit’ … Take lesson

Advanced Spreadsheets – Collaborative Editing

The Place For Free Online Training Courses

Tracking and Reviewing Turn on, off track changes. Track changes in a worksheet using a specified display view. Whenever we make changes to any document and send that document to someone else, then it might be possible that some of … Take lesson

Advanced Spreadsheets – Run a macro

The Place For Free Online Training Courses

To run a macro, click on ‘Tools’ from the main menu bar. From the resulting drop-down menu, click on ‘Macros’, and from the sub-menu which gets displayed, click on ‘Run Macro’. This will open the ‘Macro Selector’ dialog box. In … Take lesson

Advanced Spreadsheets – Automation

The Place For Free Online Training Courses

Record a simple macro like: change page setup, apply a custom number format, apply auto formats to a cell range, and insert fields in worksheet header, footer. A macro is a saved sequence of commands or keystrokes that are stored … Take lesson

Advanced Spreadsheets – Import delimited data from a text file.

The Place For Free Online Training Courses

There are some file types which are which are actually spreadsheet files, but in text format where cell contents are separated by a character. This character can be anything, say a comma or a colon. The extensions for such files … Take lesson

Advanced Spreadsheets – Link data within a spreadsheet, between spreadsheets.

The Place For Free Online Training Courses

To link data between different sheets within a spreadsheet, select the cell on which you want to create the link. After this go to the input line and input ‘=’. After this, go to the sheet whose data you want … Take lesson

Advanced Spreadsheets – Hyperlinks

The Place For Free Online Training Courses

Insert, edit, and remove a hyperlink. Hyperlinks are used to jump to a different location from within a spread sheet and this location can be in the same file, in different files and also some websites. To insert a hyperlink, … Take lesson

Advanced Spreadsheets – Templates

The Place For Free Online Training Courses

Create a spreadsheet based on an existing template. To create a spreadsheet based on an already existing template, click on ‘File’ from main menu bar. From the resulting drop-down, click on ‘New’, and from the sub-menu, click on ‘Templates’. This … Take lesson

Post navigation

← Previous Post


  • Terms and Conditions
  • Privacy Policy
  • Site Map
©2021 - The Place For Free Online Training Courses Privacy Policy
↑