Skip to content

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 hours

What you’ll learn

  1. Advanced formulas and dynamic arrays
  2. Power Query import and transformation
  3. Combining data and checking errors
  4. Interactive PivotTables and dashboards
  5. 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.

Start typing to search the site.
↑ ↓ to move · Enter to open · Esc to closeSee all results →

Necessary Cookies — Always Active

On

These support essential website functions and cannot be switched off here.

Optional analytics is not enabled. There are no optional analytics cookies to accept.

You can change your choices later using Cookie Settings in the footer.