Microsoft (MS) Excel – Advanced

This 1-day course is a Microsoft Excel Advanced course aimed at experienced Excel users who need to create and manipulate more complex models using the advanced features of Excel. Participants should be existing users of MS Excel. They should be able to create, edit and manipulate spreadsheets containing formulae and functions. They should be able to create a basic chart and pivot table. Ideally they will have completed the Excel Introduction and / or Excel Intermediate course(s).

Course Content

The content of the Course is outlined:

Module 1: - Using Excel Functionality
  • Create complex formulae
  • Use a wide range of Excel functions – Mathematical / Statistical / Financial / Text / Lookup / Date & Time
  • Link worksheets and workbooks via formulae
  • Import CSV / TXT files and Parse the Data
Module 3: - Managing Multiple Workbooks
  • Protecting the Sheet & the Workbook
  • Sharing Workbooks
  • Apply Conditional Formatting
  • Use advanced sorting and filtering features
Module 5: - Using Excel Macros
  • Create and use a keystroke macro
  • Create Charts and customise layouts
  • Create Sparkline charts for quick visual analysis
Module 2: - Excel Data Features
  • Use the Data Features – Sort, Filter, Advanced Filter, Subtotal, Grouping, Slicers
  • Use Data Validation and Audit a workbook
  • Analyse data using Scenarios / What Ifs / Goalseek / Forecast Feature
Module 4: - Using Pivot Tables
  • Create advanced Pivot Tables to analyse data and Dashboards
  • Formulas in a Pivot Table
  • Add extra calculation fields to the Pivot Table

Upcoming Courses

No Events

If this course is not scheduled here then just complete this form, and we can arrange a custom date for you

  • Contact Permission

  • Agreement for us to contact you in the future

    We'd love to send you information and offers from Turlon by email, SMS, phone and other electronic means. We'll always treat your personal details with the utmost care and will never sell them to other companies for marketing purposes.

X