The aim of the course is to provide delegates with the skills to use functionality that will make formulae easier to work with, to create formulae using data from multiple worksheets, and to apply more complex formatting.
Delegates must have previously attended the “Excel for Beginners” course or gained similar knowledge in the workplace.
The course covers:
- Saving and File Management
- Converting and Encrypting Files
- File Properties and Digital Signatures
- File Accessibility and Compatibility
- Formulas with Absolute References
- Autosum Functions (SUM & AVERAGE)
- IF and Nested Functions
- Working with Named Ranges
- Array Functions (SUMIF & AVERAGEIF)
- Formula Auditing
- Text Functions
- Creating Excel Tables
- Working with Records and Filters
- Advanced Filters
- Flash Fill
- Remove Duplicates
- Data Validation
- Consolidate
- Trendlines
- Error Bars
- Working with Axis Options
- Advanced Chart Formatting
- Creating Sparklines
- Editing Sparklines
- Working with Themes
- Creating Custom Styles
- Applying Cell Styles
- Text to Columns
Delegates must have a laptop (or equivalent) running Excel for Microsoft 365(not online version).
£120 +VAT members / £199 +VAT non members