Master Excel by Playing Games

Navigate a maze from start to finish using only the keyboard, touching all light green checkpoints and deleting every X along the way in the practice maze.

Select a maze level in maze index and practice bronze, silver, and gold in timer-free mode while learning shortcut keys; increase difficulty by reducing time per maze toward phase one.

Navigate an Excel maze using shortcuts for copy, paste, transpose, and filter, while mastering date and time entry, comments, and paste special divide.

Master essential Excel shortcuts in maze three to navigate large data sets efficiently. Learn selection, moving the active cell, sums, saving, hyperlinks, strikethrough, and fill-right.

Master excel by playing games maze 4 teaches copying and pasting formulas, editing with f, and switching absolute to relative references, plus vlookup, dependents, precedents, and paste special values.

Navigate excel mazes using keyboard shortcuts like home, ctrl+shift, and arrow keys to hide or reveal columns and rows. Find, paste special, and move with enter or tab.

Explore mazes six through ten to reinforce shortcut keys learned in mazes one through five. Read tool tips, apply what you learned, and build muscle memory to finish each maze.

Create a custom Excel shortcut by recording a macro named highlight and assigning a shortcut key, then apply a yellow fill and learn how to delete the shortcut.

Learn to insert multiple rows or columns, select multiple tabs, fill across blank cells with ctrl+enter, use format painter, and auto-fit column widths.

Explore foundational Excel concepts by distinguishing formulas from functions, and properly referencing cells using operators. Practice five basic functions and discover built-in features that simplify working with formulas and functions.

Master Excel cell referencing by using cell addresses and ranges to keep formulas dynamic, replacing hard-coded numbers with references like A1, A2, and A1:A4.

Explore how the dollar sign creates absolute and mixed references in excel, and how copy-paste behavior shifts relative references between a1, a2, and b1, b2.

Explore Excel's operators, from arithmetic like plus, minus, multiply, divide, percent, and exponent to comparison operators, guided by the pemdas order of operations and context-specific syntax.

Explore five basic Excel functions, including concatenate and the if function, and learn how syntax, arguments, and tips and tricks unlock mastery of about twenty five essential functions in Excel.

Master the sum function in Excel by learning syntax and how to add numbers, cell references, and ranges, with hands-on examples and tips to avoid pound value errors.

Master the trim function to remove extra spaces from text, clean imported data, and improve exact matches for VLOOKUP and MATCH, preparing data for concatenate and other Excel operations.

Master the concatenate function in Excel to join text and cell references into a single cell, using separators and quotes, explore ampersand alternatives, and compare with the concat function.

Master the if function in Excel by performing a logical test and returning true or false. Use =IF(logical_test, value_if_true, value_if_false) to evaluate conditions, such as equals or greater than checks.

Discover Excel's formulas tab to access functions including financial, logical, text, date/time, and lookup, learn their syntax and arguments, and use evaluate formula to build and debug nested if statements.

Master vlookup by solving issues with three secrets: trim spaces, text versus numbers, and absolute table references, using quick copy and paste values shortcuts.

Celebrate finishing the course and the fun, game-based approach to learning Excel, and consider leaving a five-star review to guide others.