Microsoft Excel Intermediate (Level 2) 2003 2007 2010 2013 2016 & 365

Intermediate Microsoft Excel

1Revision

•Review of Introduction day

•Revision Exercise

2More about Calculations

•Absolute References

•Using Functions

•Simple Statistical Functions

•The IF Function

3More Features

•Using Comments

•Using Zoom

•Splitting and Freezing

4Printing Worksheets

•Fitting a Spreadsheet on a Page

•Altering Page Margins

•Adding Headers & Footers

•Setting the Print Area

•Using Print Titles

•Controlling Page Breaks

5Charting Features

•Creating Charts

•Revising a Chart

•Formatting Chart Elements

•Adding Data to an Existing Chart

6Working with Multiple Worksheets

•Selecting Multiple Worksheets

•The Worksheets Context Menu

•Navigating Multiple Worksheets

•Calculations between Worksheets

7Data Commands

•Working with Lists

•Sorting a List

•Sub-Totalling a List

•Filtering a List