Loading Events

Advanced Microsoft Excel


  • This event has passed.

Course Details

This course is for anybody wanting to learn additional advanced Microsoft Excel skills and looks at Microsoft 365 but also looks at previous versions, of 2016, 2013, 2010 or 2007, as it covers all the aspects and differences between the versions. It helps delegates improve their knowledge and skills to ensure that they can maximise the full use of MS Excel.

 

To ensure success, delegates should have completed our Basic and intermediate Microsoft Excel courses or are familiar with the topics in these courses

Benefits to you

By the end of the course, participants will be able to:

  • Understand advanced functions of Microsoft Excel

Course Contents

  • Relative & Absolute Addressing
  • Text functions
  • Statistical Functions
  • Logical Functions
  • Auditing & Comments
  • Input Tables
  • Sorting & Filtering
  • Named Ranged & What-if Scenarios
  • Pivot Tables
  • Conditional Formatting
  • Macros
  • Web Query
  • Linking
  • Consolidation
  • Standard & Combined Charts
  • Sharing & Tracking
  • Subtotals
  • Further Functions
  • Controls
  • Evaluate Errors
  • Deleting Blank Cells
  • Vlookup & Hlookup
  • Date Functions
  • Rank Function

Who should attend?

Anybody wanting to learn advanced Microsoft Excel functions

What's Included

Tuition

Course notes

Refreshments

Certificate of attendance