4. Excel Inter (Level 2)
Excel Intermediate (Level 2)
Duration 1 Day (9:00 am - 1:00 pm)
Location: Welwyn Garden City or Borehamwood
Includes: Refreshments and Documentation
Price: £150 per delegate
Not sure if this course is right for you? Why not take our Quick Quiz or FREE - Training Needs Analysis
Intermediate (Level 2): On this course you will learn how to use Mixed Referencing and Worksheet Specific Named Ranges to speed up formula creation. You will use Data Validation to restrict the values users can enter into a cell. You will enhance your knowledge of Conditional Formatting so that you can change the appearance of cells by adding your own formulae. You will learn advanced sorting techniques including Sorting by Colour and Sorting Using a Custom List. You will explore the various filtering options using AutoFilter. You will be able to create standard spreadsheets by creating your own Styles and Templates.
- Mixed Referencing
- Worksheet Specific Named Ranges
- Data Validation
- Data Validation with Indirect
- Custom Conditional Formatting - Watch Video
- Sorting by Colour
- Sorting Using a Custom List
- AutoFilter - Watch Video
- Styles and Templates