The Excel Day-1 Practice Sandbox (10 Hands-On Labs)

Stop watching endless tutorials without practicing.

The Excel Day-1 Practice Sandbox is a hands-on workbook designed to help you learn by doing. Instead of starting from a blank screen, you get 10 ready-to-use practice sheets with realistic sample data, dedicated green target zones, and clear instructions at the top of each tab.

• Lab 01: Flash Fill Magic – Split names, extract text, and clean emails in 1 second with Ctrl + E.
• Lab 02: Dynamic Tables – Turn messy ranges into smart tables (Ctrl + T) that auto-expand formulas.
• Lab 03: The F4 Lock – Master absolute cell references ($A$1) so your math never breaks when dragging.
• Lab 04: Copy Visible Only – Copy filtered tables without pasting hidden rows using Alt + ;.
• Lab 05: Fast Navigation – Jump across thousands of rows instantly without mouse scrolling (Ctrl + Arrows).
• Lab 06: Modern XLOOKUP – Search left and right easily without broken VLOOKUP column counting.
• Lab 07: Dropdown Lists – Add clean, audit-proof selection menus to input columns.
• Lab 08: Visual Alerts – Highlight high-value numbers automatically with Conditional Formatting.
• Lab 09: Text Cleaner – Strip ghost spaces and non-printable characters using TRIM and CLEAN.
• Lab 10: Dynamic Totals – Use SUBTOTAL 109 to calculate sums that adapt when you filter.

What you get:

• Instant digital download (.xlsx file).
• Works on Microsoft Excel 365, Excel 2021, 2019, and Excel for Mac.
• 10 interactive worksheets + 1 master README sheet.