Excel Skills Starter · Free course quiz

Quick Quiz — Advanced Excel Basics

What does VLOOKUP do? Sorts a column from smallest to largest Searches for a value in the first column of a range and returns a matching value from another column Deletes duplicate rows automatically

What is a PivotTable used for? Summarizing and analyzing large amounts of data without writing formulas Adding color to a spreadsheet Protecting a file with a password

Quick Tip: You are reading the free preview of this program. Practice with a real dataset — your own expenses, a small business's sales, or your organization's attendance records. Register for live classes to build a complete dashboard with instructor feedback.

Finished the free course?

Continue Advanced Excel with a live instructor, practical assignments, feedback and a Rescue Academy certificate.

Taught live by an instructor — online or in person. Free course lessons are for self-study and do not lead to a certificate — see registration options.