Non-accredited short course
Microsoft Excel 365 Advanced
Experienced Excel users who build reports or manage recurring data.
Programme information
Microsoft Excel 365 Advanced
Short course · Digital skills and AI
Entry Requirements
Recommended: Excel 365 Intermediate or equivalent skills in formulas, tables and PivotTables. Use desktop Excel 365 with Power Query support.
Course Outline and Delivery
Practical outcome. Build a refreshable management dashboard using Power Query.
On-site, live online or blended · 2 training days Self-paced online · 16 study hoursWhat you’ll learn
- Advanced formulas and dynamic arrays
- Power Query import and transformation
- Combining data and checking errors
- Interactive PivotTables and dashboards
- Refresh and workbook controls
Assessment and Completion
Use Power Query to combine and clean data, build advanced calculations and design a management dashboard. Test the workbook against a new reporting period.
Practical task. Combine monthly source files into a refreshable management dashboard and verify the results with new data.
Completion and recognition
Submit a refreshable dashboard workbook, document its inputs and refresh steps, and demonstrate that the outputs update correctly. Finweb issues a Certificate of Attendance to learners who meet the attendance requirements.
Dates and Fees
Ask Finweb about dates, fees, delivery options and what is included.
