Course Content - Excel Plus for Garages

Advanced Editing

• Create, edit or 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 chart reports
• Create named scenarios from defined call ranges. Create a scenario summary
• Auditing, audit a worksheet; display all formulae in a worksheet

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