Describe where the work begins
If a worksheet already contains the data you need but the calculation is difficult to express, review Advanced Functions or Expert Functions. Their outlines cover different formula skill levels: multi-argument logic and summaries in the advanced course; modern spill functions and other function families in the expert course.
If each reporting cycle begins with exports, inconsistent formats or several sources, review Expert Data Management. Its published topics include Power Query imports, cleaning, connections and data updates, followed by Power Pivot modelling.
| Your next task | Course path to inspect |
|---|---|
| Build a conditional calculation | Advanced Functions |
| Use modern formulas that expand with changing data | Expert Functions |
| Prepare recurring data imports | Expert Data Management |
| Build a first PivotTable summary | Advanced Data Management before the expert reporting course |
Ask about the whole handoff
A useful training discussion follows the data from its source to the final decision: where it comes from, what gets changed, which calculation is needed and who uses the result. This helps prevent buying a formula course for a data-preparation problem.
Microsoft’s Power Query overview explains the import, transformation and refresh workflow. Availability varies by application and feature, so check your Excel version before booking. For team work spanning several steps, discuss Excel training for teams with an anonymised description of the process.
Related options: Excel Expert Data Management: Power Query and Power Pivot; Excel Training for Teams and Businesses; Excel skills assessment.
Compare the course outlines
Sources and course details
- Excel Advanced Functions — published course outline
- Excel Expert Functions — published course outline
- Excel Expert Data Management — published course outline
- Microsoft Excel help and learning
Session availability and fees can change. Confirm booking details and any required software access before registering.