Productivity · Beginner
Excel & Spreadsheets Essentials
Formulas, lookups, PivotTables and dynamic arrays, the parts you use daily.
What you will learn
The 11 topics inside Excel & Spreadsheets Essentials
Each topic has its own goal, its own questions and its own mastery score, so you always know which part is still weak.
Charts
Pick a chart that matches the comparison.
Dates and times
Do arithmetic on dates without surprises.
Dynamic arrays
Return many results from one formula.
Errors and auditing
Diagnose formula errors instead of hiding them.
Logical and text functions
Branch on conditions and reshape text.
Lookups
Retrieve a matching value reliably across tables.
PivotTables
Summarise a table without writing formulas.
Power Query and data import
Import, clean and reshape data with a repeatable query.
References and formulas
Control how a formula behaves when it is copied.
Validation and formatting
Stop bad input and make patterns visible.
What-if analysis
Use Goal Seek, data tables and Solver for scenarios.
Example questions
Real questions from this course
These are taken straight from the course. Pick an answer, then open the explanation to see why it is right.
Sample 01
How does Excel represent fractional times of day within its internal date-time numbering system?
Show the answer and why
Answer: A time is stored as a decimal fraction of a single day, such as 0.5 for noon.
Time is simply the fractional part of a 24-hour day in Excel's unified serial number system. This defends against the misconception that times and durations are stored differently from dates.
Times are stored as a decimal fraction of a 24-hour day. For example, 12:00 PM is represented as 0.5 because it is halfway through a 24-hour day serial number.
Sample 02
Why is INDEX MATCH still relevant and used in Excel workbooks despite the introduction of XLOOKUP?
Show the answer and why
Answer: INDEX MATCH provides backward compatibility for workbooks opened in older Excel versions.
Defends against the misconception that INDEX MATCH is obsolete. While XLOOKUP is generally preferred in modern Excel, INDEX MATCH remains crucial for legacy spreadsheet support and compatibility.
INDEX MATCH maintains backward compatibility with older versions of Excel that do not support dynamic array functions like XLOOKUP. Additionally, experienced authors still use it for specific two-dimensional matrix lookups.
Sample 03
Which Error Alert style in Excel Data Validation completely prevents a user from committing invalid data into a cell when an entry fails validation?
Show the answer and why
Answer: A stop alert completely prevents committing the invalid entry to the worksheet cell.
Only the Stop error alert style strictly prevents committing invalid entries, whereas Warning and Information allow overrides.
Choosing a stop alert completely blocks the user from saving the invalid entry in the cell. Options like Warning or Information allow the user to bypass the alert and keep the invalid entry.
Excel & Spreadsheets Essentials is free with an account, along with every other course in the library.
Start free