Excel Intermediate

The course covers the following –

• Excel 2003 v 2007 v 2010 (and later);
• Quick Access Toolbar;
• Named Ranges;
• Data Validation (using Named Ranges);
• Absolute Values (‘Locking’ the cell reference);
• Data Transfer between worksheets and spreadsheets;
• Conditional Formatting;
• Formula Auditing;
• IF Statements and Formulas;
• VLOOKUPS;
• Inserting Charts;
• Sub-totals;
• Pivot Tables;
• Paste Options;
• 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;
• Macros