Microsoft Excel LogoExcel Advanced – 2 days

This Advanced Excel course will further enhance on your existing Excel skills.  Increasing your knowledge by understanding advanced functions and productivity tools. Following this course, you will work use a large range of functions.  Analyse data effectively and quickly using Pivot Tables and Charts.  You will gain a practical ability to use Excels productivity tools and Advanced Functions.  This is a hands-on course and includes plenty of chances to try out what you are being taught and ask questions.

Content:

  • Revision
  • Defined Names
  • Protecting Data, Worksheets and Workbooks
  • Logical Functions
  • Validating Data
  • Creating Drop Down boxes
  • Lookup Functions
  • Vlookup, Hlookup, Match

 
  • Summarising Data using Subtotals
  • Grouping and Outlining
  • Data Linking
  • Data Consolidation
  • Pivot Tables
  • Pivot Table Techniques
  • Macros
  • Attach Macros to buttons, Access Tootlbar and Worksheets

 

Learning Outcomes:

At the completion of the program Excel Advanced participants should be able to:

  • Create If Functions to analyse data
  • use logical functions to test whether a statement is true or false
  • use a variety of data validation techniques
  • use a range of lookup and reference functions
  • create summaries in your spreadsheets using subtotals
  • understand and create simple PivotTables
  • construct and operate PivotTables using some of the more advanced techniques
  • create recorded macros in Excel

Duration:  Two days

Previous course: Microsoft Excel Intermediate – 2 days

Back to Microsoft Excel Courses