Work 路 intermediate
Spreadsheets Intermediate: Logic, Lookups, Text and Pivot Tables
Make spreadsheets smarter: IF logic, lookups, conditional sums and counts, text and date functions, and pivot tables that summarise data in seconds.
Not started
Finish every lesson, then sign in and pass the final assessment to earn a free certificate
Module 1: Working with real data
Questions about Spreadsheets Intermediate: Logic, Lookups, Text and Pivot Tables
What will I learn in Spreadsheets Intermediate: Logic, Lookups, Text and Pivot Tables?
Make spreadsheets smarter: IF logic, lookups, conditional sums and counts, text and date functions, and pivot tables that summarise data in seconds. The course has 4 lessons, organised in one module: Module 1: Working with real data.
How long does Spreadsheets Intermediate: Logic, Lookups, Text and Pivot Tables take?
About 50 minutes in total, across 4 lessons. You can learn at your own pace and stop and continue any time.
Do I need experience to take Spreadsheets Intermediate: Logic, Lookups, Text and Pivot Tables?
It helps to know the basics of the topic first. If you are new, start with the beginner course and come back.
Is Spreadsheets Intermediate: Logic, Lookups, Text and Pivot Tables free?
Yes. The whole course is free and you do not need an account to learn. A free account is only needed for the final assessment and the certificate.
Do I get a certificate for Spreadsheets Intermediate: Logic, Lookups, Text and Pivot Tables?
Yes, a free certificate of completion. Finish every lesson, sign in, and pass the 15-question final assessment with 80% or more. It is not an accredited qualification.
What should I learn after Spreadsheets Intermediate: Logic, Lookups, Text and Pivot Tables?
The next step is Spreadsheets Advanced: Modern Formulas, Modelling and Automation.