Course Content

Advanced Editing

• Create, edit, delete a named range, apply automatic formatting
• Create a custom number formats, use conditional formatting options
• Use paste special, import a text file and delimit by comma, space or tab
• Freeze rows/columns, hide/unhide columns, rows or worksheets
• Use sub totals, apply/remove password protection to workbook or worksheet

Data Handling

• Multiple sorting on data, use advanced filtering options
• Link data within a worksheet and between workbooks
• Link data/chart into a word document. Use data consolidation using 3D sum function
• Create and edit a template

Charts

• Change angle of a pie chart, format chart axes or text, explode segments in a pie chart
• Delete/modify data changes in a chart
• Widen the gap between bars in a chart
• Insert an image in a 2D chart

Advanced Functions

• Date and time functions
• Mathematical functions
• Statistical functions
• Text functions, financial functions
• Use LOOKUP functions
• Logical and database functions
• Nested functions

Analyse and Audit Data

• Analyse data in different ways
• Create pivot tables, pivot charts and pivot table/pivot charts reports
• Create named scenarios from defined cell ranges. Create a scenario summary
• Auditing, audit a worksheet, display all formulae in a worksheet

For information on future Advanced Excel courses check our schedule or call your local office now!