Intermediate

EXCEL 102 · ADVANCED EXCEL

Excel 102 — Advanced Excel

GH¢ 2,000

Private 1-on-1: GH¢ 6,000

International student: GH¢ 2,600

Microsoft Excel · Claude in ExcelExcel basics needed8 sessions of 3 hours · Weekday or WeekendEvening & Weekend cohorts

Most businesses keep their records in Excel, but few people use it beyond simple totals. This course takes you from the Excel basics to the skills an office or business needs every week. You learn on your own Windows laptop, with made-up records from Ghanaian businesses in Ghana cedis. You build proper tables and clean messy data. You use formulas that make decisions, count what matches and look up prices: IF, SUMIFS, XLOOKUP and FILTER. You summarise hundreds of sales with pivot tables and slicers, and present them on a one-page dashboard. In the last session you use Claude, an AI assistant, inside Excel, and you learn to check every answer it gives. You need the Excel basics to start: entering data, SUM and AVERAGE, formatting money and a simple chart. Our Computer Literacy course teaches them. Taught in person at our Autodesk Authorized Training Center in North Legon, Accra.

LIMITED SEATS · EVENING & WEEKEND COHORTS

Enrol now →Ask a question

Clean Data

Proper tables, no errors or repeats

Advanced Formulas

IF, SUMIFS, XLOOKUP and FILTER

Pivot Tables

Slicers, charts and a dashboard

AI in Excel

Claude, and how to check its answers

SAMPLE FILE

See what graduates produce.

Download a sample project file from this course — the exact standard you will reach by the end of the programme.

PDF · Free

WHO THIS IS FOR

Office, accounts and admin staff

Small business owners

Job seekers who need advanced Excel

Computer Literacy graduates

WHAT YOU’LL ACHIEVE

✓

Build Excel Tables with frozen headings and drop-down lists

✓

Clean messy names, phone numbers, dates and repeated rows

✓

Use IF, IFS, SUMIFS, COUNTIFS and AVERAGEIFS

✓

Bring in prices from another table with XLOOKUP, VLOOKUP and INDEX with MATCH

✓

Answer business questions with filters, FILTER, SORT, UNIQUE and Goal Seek

✓

Summarise data with pivot tables, slicers and pivot charts

✓

Build a one-page dashboard and save it as a PDF

✓

Use Claude inside Excel, and check its answers before you use them

SYLLABUS SNAPSHOT

Tables, shortcuts and absolute references

Move around a large sheet fast, copy formulas with dollar signs, and turn a list into an Excel Table with drop-down lists. You produce: a sales list turned into a proper table.

Cleaning messy data

Fix extra spaces, capital letters, split names, phone numbers, repeated rows and dates stored as text. You produce: a customer list with no errors or repeats.

IF, SUMIFS and COUNTIFS

Formulas that test a condition, count and add only the rows that match, and colour overdue sales. You produce: a sales summary by category and payment method.

Lookup and date formulas

VLOOKUP, XLOOKUP and INDEX with MATCH, band lookups for discounts, and days overdue. You produce: prices and discounts brought in from a price list.

Sorting, filtering and what-if tools

Multi-level sorts, filters, FILTER, SORT, UNIQUE, SUBTOTAL, Goal Seek and Scenario Manager. You produce: answers to five business questions.

Pivot tables and slicers

Summarise six months of sales by month, category and payment method, with slicers and pivot charts. You produce: three linked pivot tables.

Charts and dashboards

Choose the right chart, build combo charts and sparklines, and put the key figures on one page. You produce: a one-page sales dashboard, saved as a PDF.

Claude in Excel, and your final project

Ask Claude to explain and fix formulas, check every answer, and keep personal data safe. You produce: an AI Check sheet, and your final project started.

CAPSTONE PROJECT

A report workbook and one-page dashboard built from a year of raw sales records.

TRUSTED BY

Office, accounts and admin staff

Small business owners

CAREER OUTCOMES

Roles our graduates fill:

Data entry officerAccounts assistantSales or stock administratorOffice manager

LAPTOP SPECIFICATIONS

Minimum

· Windows 10 or later

· 8GB RAM

· Microsoft 365, or Excel 2021 or later

Excel 102 — Advanced Excel

Ready to enrol in Excel 102 — Advanced Excel?

Excel 102 — Advanced Excel

Ready to enrol in Excel 102 — Advanced Excel?