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

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