- Home
- Free Courses
- Excel for the Office: Pivot Tables, Lookups and Charts
Excel for the Office: Pivot Tables, Lookups and Charts
Go beyond Excel basics: prepare data, build pivot tables, look up values with XLOOKUP, VLOOKUP and INDEX with MATCH, and present results in clear charts. Five short lessons and a quiz, with a certificate of completion.
Already have a campus account? Open the course
The short version
Free, no payment details
Sign up with your name and e-mail and confirm it with a 6-digit code. There is nothing to buy.
About 60 minutes
5 short lessons and one final quiz. Your progress is saved, so you can stop and come back on any device.
Certificate of completion
Finish every lesson and score 70% or more on the final quiz. Retakes are unlimited.
Not a program
This free short course is not part of a Ucademy diploma or certificate program and gives no program credit.
What you will learn
- Prepare a list for analysis with Excel tables, cleaning steps and data validation
- Build a pivot table and use Rows, Columns, Values and Filters to answer questions
- Group dates, show percentages and add a slicer to a pivot table
- Write lookups with XLOOKUP, VLOOKUP and INDEX with MATCH, and handle missing values
- Choose a chart type for the question and avoid charts that mislead
- Check totals against the source and assemble a one-page summary
Who it is for
Adults who already know basic Excel (formulas, SUM, sorting and filtering) and want pivot tables, lookups and charts for office and administrative work. It follows on from the free course Office Skills Starter.
What you need
- A computer with desktop Excel (Excel for the web works for most steps; menus may differ)
- Basic Excel skills such as formulas, cell references and sorting, as taught in Office Skills Starter
- About 60 minutes in total, which you can split across several days
Lessons
- 1Preparing data for analysis12 min
- 2Your first pivot table12 min
- 3Pivot tables that answer questions12 min
- 4Lookups: XLOOKUP, VLOOKUP and INDEX with MATCH12 min
- 5Charts and a one-page summary12 min
- ✓Excel for the Office: Final Quizfinal quiz
Where this course can lead
Administrative Assistant Diploma
This course is a short, practical introduction. The full program goes much further: 806 hours online plus an 86-hour internship: Microsoft Office, business communication, bookkeeping basics and office procedures.
Related reading
More free business & administration courses
Office Skills Starter: Email, Calendar and Excel
Learn the everyday office skills behind administrative work in Alberta: professional email, scheduling across time zones, file organization and Excel basics. Six short lessons and a…
See the course →
AI Tools at Work: Using ChatGPT and Copilot Safely
A free AI course for office work: write clear prompts for ChatGPT and Copilot, use them on everyday tasks, check what they produce and keep personal…
See the course →
Project Management Basics
Learn how a small project is defined, planned, tracked and closed: charter, scope, schedule, budget, risks and status reports. Five short lessons and a quiz, with…
See the course →Frequently asked questions
Yes. You sign up for a free account, take the five lessons and the quiz, and pay nothing.
Yes. When you finish the lessons and the quiz you receive a Ucademy certificate of completion. The course is not part of a Ucademy diploma or certificate program.
About 60 minutes in total. The course is online and self-paced, so you can take one lesson at a time.
You should know the basics, such as formulas, cell references, sorting and filtering. If not, take the free course Office Skills Starter first.
Yes. Lessons 2 and 3 build pivot tables step by step, including grouping dates, percentages and slicers, and Lesson 5 turns them into charts.
No. It is a free short course, not part of a Ucademy diploma or certificate program, and it does not give program credit.
Start Excel for the Office: Pivot Tables, Lookups and Charts today
Free, online and at your own pace, with a certificate of completion.