Excel Intermediate

The course covers the following –

• Introduction
• Work Related Spreadsheets
• Working Example
• Quick Access Toolbar
• Formula Auditing
• Named Ranges
• Data Validation (using Named Ranges
• Absolute Values (‘Locking’ the cell reference)
• Data Transfer between Worksheets and Spreadsheets
• Conditional Formatting
• IF Statements and Formulas
• VLOOKUPs
• Inserting Charts
• Pivot Tables
• Paste Options / Clipboard
• Date and Time Functions
• Placing Existing Data into a ‘Table’
• Themes
• Adapting the view of the Spreadsheet
• Inserting ‘Screen-Shots’
• SmartArt Graphics
• What-If Analysis
• Version History
• Show Changes
• Work Related Spreadsheets

There is also an opportunity during the last section of the workshop to work on Excel with specific work related issues.