1 | An overview of the screen, navigation and basic spreadsheet concepts Understand Excel terminology workbooks, worksheets, rows, columns, cells |
2 | Various selection techniques Understanding the various mouse cursors Working with Ribbon Tabs, Groups and Dialog Boxes Standard and Contextual ribbons Use the task pane, Understand and use the File Tab Saving, File types, File compatibility (earlier versions), Useful keyboard commands |
3 | Various ways to Enter, Edit and Delete information (Text, Numbers, Dates) Use Auto List feature Date and Time are storage in Excel Enter Dates and Times Date/time formatting Methods to Move and Copy data Use the Fill Handle to copy data and create simple lists Create series of information |
4 | Insert, Delete and Hiding Rows & Columns Insert, Delete and Move Cells Insert, Delete, Move and Copy Sheets |
5 | Formatting of Cells with Number formats, Font formats, Alignment, Borders, Fill colours and Patterns Quick formats and themes Sheet tab formatting and Renaming Copy and Clear Formats |
6 | Formatting and Proofing Merging cells Spell Check, Find & Replace and AutoCorrect |
7 | Formatting and Proofing Page Orientation Add Headers and Footers Print a selection Set a print area Clear a print area |
8 | Adjust page breaks within Page Break Preview Repeat columns and rows Print Gridlines Save print settings |
9 | Processing Data in Excel Data Tables in Exce A Second Data Table Excel Scenarios Excel Pivot Tables Pivot Tables, Part Two |
10 | Entering Simple Addition Formula The SUM Function in Excel The SUM Function Continued Copy and Paste 7 How to use Paste Special |
11 | How to Multiply in Excel Entering Simple Addition Formula Finishing your spreadsheet for this section How to Add a Comment to a Cell Review Number Two |
12 | The Average Function The Date Function Time Functions in Excel A TimeTable Project |
13 | Ready Functions (min,max,if...) |
14 | Review |