Contents:
| Documenting Worksheets |
Charting |
| · Defining Range Names |
· Elements of a Chart |
| · Using the Range Navigator and F5 |
· Editing Chart objects |
| · Calculating with Range Names |
· Overlay Effects |
| · Working with Task Panes |
· Using Custom Chart types |
|
· Adding Trend Lines |
| Excel Functions |
· Adding Error Bars |
| · Formulas and Functions |
· Applying Multiple Axes |
| · Cut and Paste Functions |
|
| · Using the Insert Function Reference |
Databases |
| · Use Logical and Lookup Functions |
· What is a Database List |
| · AutoFill Formulas & Functions |
· Using AutoFilter |
| · Relative v Absolute Addressing |
· Sort Data |
|
· SubTotal Functions |
| Creating & Using Templates |
· Extracting Data with Criteria |
| · About Templates |
· AND and OR Logic |
| · Creating Templates |
· Apply Subtotal feature |
| · Create from Existing Workbook |
· Using Database Functions |
| · Apply Cell & Worksheet Protection |
|
|
Macros |
| Multiple Worksheets |
· What are Macros? |
| · Performing Special Pastes |
· The Personal Macro Workbook |
| · Name and Colour Sheet Tabs |
· Recording a Macro |
| · Move, Copy and Delete Sheets |
· Record and Run a Macro |
| · Creating Grouped Sheets |
· Use Relative References |
| · Linking to other Spreadsheets |
· Assign Macro to a Form Button |
| · Multi-sheet Formulas and Functions |
· View the VBA Code |
Target Audience: Users confident in the basic features of Microsoft Excel that wish to further their knowledge and understanding of the software.
Assumed Knowledge: A basic working experience of Excel or prior attendance of our Excel Essentials course.
Duration:
1 Day - Click here to see our course calendar.
Suggested follow-up course: MS Excel Specialist