High-level Excel - training contents
Our advanced Excel masterclass 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/Get & Transform)
- 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
- Analyse data using advanced functions (IF, IFS, VLOOKUP, XLOOKUP, MATCH, XMATCH, INDEX, OFFSET, SUMIF, SUMIFS, SWITCH, MAXIFS, MINIFS, etc.)
- Manipulate dates and text with functions (TODAY, YEAR, MONTH, WORKDAYS, ISOWEEKNUM, LEFT, RIGHT, MID, CONCATENATE, TEXTJOIN, 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 optimisation problems by using the tools Goal seek and Solver
- Excel 365: Dynamic arrays (UNIQUE, FILTER, SORT, SORTBY, SEQUENCE, RANDARRAY, #SPILL! error, the spilled range operator #, implicit intersection, implicit operator @)
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.