Productivity · FREE NOTES
Advanced Excel
Use advanced formulas, lookup functions, data cleaning, analysis, dashboards and reliable reporting techniques.

Contents
REVIEW BEFORE YOU MOVE ON
Questions and answers
Use these course-specific questions to check your understanding and revisit the chapter that explains each answer.
What is the main purpose of Formula design and error handling?
Reliable analysis depends on clean inputs, transparent formulas and a question worth answering. Formula design and error handling improves a workbook when the logic is visible. The purpose is to produce a useful, accurate result for the intended audience.
What is the main purpose of Logical and conditional functions?
Reliable analysis depends on clean inputs, transparent formulas and a question worth answering. Logical and conditional functions improves a workbook when the logic is visible. The purpose is to produce a useful, accurate result for the intended audience.
What is the main purpose of Lookup and reference functions?
Reliable analysis depends on clean inputs, transparent formulas and a question worth answering. Lookup and reference functions improves a workbook when the logic is visible. The purpose is to produce a useful, accurate result for the intended audience.
What is the main purpose of Text, date and dynamic array tools?
Reliable analysis depends on clean inputs, transparent formulas and a question worth answering. Text, date and dynamic array tools improves a workbook when the logic is visible. The purpose is to produce a useful, accurate result for the intended audience.
What is the main purpose of Data cleaning and validation?
Reliable analysis depends on clean inputs, transparent formulas and a question worth answering. Data cleaning and validation improves a workbook when the logic is visible. The purpose is to produce a useful, accurate result for the intended audience.
KNOWLEDGE CHECK
Test your understanding
Five questions based on the chapters in Advanced Excel. Choose one answer for each question, then submit your score.