Excel Advanced

CLICK ON THE BUTTONS BELOW TO VIEW COURSE DATES AT YOUR CHOSEN LOCATION

excel advance
excel advance2

Who Should Attend
This course is designed for any delegates who have attended the Excel Intermediate course or have relevant business experience, and would like to learn how to improve their skills and use Excel to a very high standard.

Course content

  • Convert text case to upper, lower & proper
  • Merge text from seperate cells into one cell
  • Remove unwanted spaces
  • Count the number of entries in a range
  • Using the SUMIF & COUNTIF functions
  • Linking cells-paste links
  • Consolidating data
  • Simple IF statements
  • Nested and IF statements
  • Naming cell ranges
  • What are look up tables
  • Create a lookup table using V lookup
  • Formulae using absolute cell referencing
  • What is goal seeking
  • Using goal seeking to find results
  • Advanced formatting options
  • Conditional formatting -multiple conditions
  • Calculating with dates
  • Inserting a dynamic date
  • Using formulae to find day, month and year
  • Custom formatting times

  • Setting up data tables - best practice
  • Advanced sorting and filtering techniques
  • Creating and customising a pivot table
  • Subtotalling lists - subtotalling options
  • Amending, refreshing and grouping pivot tables
  • Controlling data entry in a specified range
  • Creating input messages and error alerts
  • Scenarios - changing circumstances
  • Viewing and amending a scenario
  • Creating a scenario summary
  • Hiding rows, colums and worksheets
  • Password protecting a workbook/worksheet
  • Password protecting cells and ranges
  • What is a Macro - Creating a macro
  • Running, deleting and editing an existing macro
  • Viewing all formulae on a spreadsheet
  • Tracing precedents - tracing dependants