Prerequisites
Delegates must have previously attended the “Introduction to Excel” course or gained similar knowledge in the workplace.
Course Outline
- 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 will be asked to carry out exercises as we progress. Handouts will be provided for reference during the course.
Delegates must have a laptop (or equivalent) running Excel for Microsoft 365(not online version)
Book here