Excel Advanced

This course is part of the library from IMPROVE. No need to worry about which course is right for you….purchase the whole library for a subscription fee AND we will set it up for you, get you started and will be on hand as part of a managed service…all starting from £45 + VAT per month for 20 employees! Prices are based on the size of your organisation with access for all of them to over 50 courses on a range of IT and non-IT topics.

Description

Modules:

  • Introduction to Formula Editing
  • Validation – Drop Down Lists
  • Validation – Numbers
  • Adding Subtotals Automatically
  • Introduction to Named Ranges
  • Using Names Managed and taking them further
  • Asking Questions and Using the Answer
  • Working with More than one Question
  • Countif, Sumif, Averageif
  • Dsum, Dmin, Dmax, Daverage, Dcount
  • Joining Separate Cell Content
  • Upper, Lower, Proper (Changing Text Case)
  • Trim-Remove Unwanted Spaces in Text
  • Vlookup-Relating information in Lists Together
  • Match with Vlookup – Bring columns from another list
  • Iferror – Hiding Formula Errors
  • Goal Seek
  • What is a Pivot Table?
  • Creating a Basic Pivot Table
  • Working with Filters in a Pivot Table
  • Working with more Advanced Maths in a Pivot Table
  • Slicers in Pivot Tables
  • Recording Macros