Advanced Excel Course

Advanced Excel course - high-level training - course contents

Our advanced Excel training extends your knowledge and ability to work with the most powerful of the tools, features and functions available in Excel.

We practise the following advanced features and functions:

  • Import data from external sources (files, the web and databases, through Power Query)
  • Quickly illustrate data with charts and use diagrams in Powerpoint, Word and PDF
  • Structure spreadsheets and handle growing data tables
  • Find the proper functions and understand Excel's built-in help system
  • Analyze data using advanced functions (IF, VLOOKUP, MATCH, INDEX, OFFSET, SUMIF, SUMIFS, etc.)
  • View figures and values from different angles using pivot tables and pivot charts
  • Perform business intelligence on multiple, related data sources with Power Pivot
  • Lock cells and create custom input forms to facilitate input and avoid errors
  • Find errors in sheets and review complex formulas
  • Collaborate by using shared and merged workbooks
  • Automate everyday work tasks by recording and replaying Excel macros
  • Solve optimization problems by using the tools Goal seek and Solver

We can also aid you in finding answers to specific questions, explore areas of particular interest and delve into Excel-related problems.

We give full support and concise explanations of advanced features and functions, as well as the necessary repetition of fundamental functions in Excel.