Suitable for anyone with a working knowledge of Microsoft Office Excel. Learn how to use more advanced tools, shortcuts and applications to develop your performance and support your business.
The course will also be held on Thursday 6th January 2022
Attendance on both dates is required to complete the course.
Key content:
- 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 ‘screenshots’
- SmartArt Graphics
- What-If Analysis
- Macros
Joining instructions:
Joining instructions and invoice for payment will be sent directly from Doncaster College. The online training session will be delivered via Microsoft Teams.