---
title: "Microsoft Excel 365 Advanced | Finweb"
description: "Microsoft Excel 365 Advanced \u2014 entry requirements, learning outcomes, delivery and assessment information."
url: https://finwebsa.co.za/short-courses/microsoft-excel-365-advanced/
source: Finweb Business Consultancy
last_updated: 2026-11-18
---

Non-accredited short course

# Microsoft Excel 365 Advanced

Experienced Excel users who build reports or manage recurring data.

[Request Programme Information](https://finwebsa.co.za/contact/?type=programme&course-outline=Microsoft+Excel+365+Advanced#enquiry)

[View course outline ↓](https://finwebsa.co.za/short-courses/microsoft-excel-365-advanced/#structure)

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
1. Power Query import and transformation
1. Combining data and checking errors
1. Interactive PivotTables and dashboards
1. 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.

[Request information](https://finwebsa.co.za/contact/?type=programme&course-outline=Microsoft+Excel+365+Advanced#enquiry)

[Request a group quote](https://finwebsa.co.za/contact/?type=proposal&course-outline=Microsoft+Excel+365+Advanced#proposal)

Related courses

- [Microsoft Excel 365 Intermediate](https://finwebsa.co.za/short-courses/microsoft-excel-365-intermediate/)
- [Microsoft Power BI & Data Analytics](https://finwebsa.co.za/short-courses/microsoft-power-bi-data-analytics/)
- [Advanced End User Computing](https://finwebsa.co.za/skills-programmes/advanced-end-user-computing/)

[Back to the programme directory](https://finwebsa.co.za/qualifications/#current)
