Home > Microsoft Excel

Excel Inter (Level 2)

Date

Our Price: £150.00
Excel Inter (Level 2)
Description

Excel Intermediate (Level 2)
Duration 1 Day (10:00 am - 2:30 pm)
Location: Welwyn Garden City
Includes: Lunch and Documentation
Price: £150 per delegate

 

Our public scheduled courses are currently suspended due to the COVID-19 outbreak, we are still able to offer closed courses in very small groups and 1:1 tuition.  Please contact us for details.

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