Microsoft Excel
| Course Level | Introduction | Intermediate | Advanced |
| Duration | 1 Day | 1 Day | 1 Day |
| Course Reference | XL E1 | XL E2 | XL E3 |
| Subjects Covered |
Understand Workbooks and Worksheets Enter Information Edit & Delete Information Use the Undo Feature Select Cells Use AutoFit Create Simple Calculations & Formulas Create Simple Formulas using the Function Wizard Adding Non-Adjacent Cells Use AutoFill Enter Data in Series Work with Worksheets Rename, Insert, Delete & Move Save, Open & Close Workbooks Use the Spelling Checker Move around a Worksheet Move & Copy information in a Worksheet Format the Worksheet Insert & Delete Rows & Columns Use the Zoom Control Creating Charts Use Print Preview & Set up the Page Print your Work |
Create Worksheet Headings Lock Row & Column Titles Print Worksheet Titles Use Auto Navigation Use Format Painter Use the AutoFormat Feature Use Absolute Cell References Create & Use Named Ranges Recap on Functions Additional Functions Create a One Step Chart & Customising Charts Use Page Breaks & Page Break Preview Print Areas of the Worksheet Use Input Areas Create & Use Comments Link Workbooks & Worksheets Use Find & Replace Create & Use Custom Lists Password & Protect a Worksheet Using Excel as a Database |
Create, Use & Change Styles Use Conditional Formatting More Excel Functions Spitting & Merging Cells Goal Seek Solver Scenario Manager Create & Use Templates Create Pivot Tables Update & Customise Worksheet Validation Create Basic Macros Share Workbooks Custom Views Customising Excel |
