Every Excel topic, mapped for learning.

Core workbook skills: navigation, data entry, formatting, printing, tables, and the habits that make every later Excel topic easier.

• Workbook layout and navigation
• Data entry and editing
• Formatting and number formats

Operators, references, lookup formulas, logical tests, text cleanup, date math, error handling, and modern dynamic array patterns.

• Formula syntax and operators
• Relative, absolute, and mixed references
• Lookup formulas

Excel Tables, named columns, structured references, totals rows, table styles, and practical table design.

• Create and format Excel Tables
• Structured references
• Totals rows and table summaries

Duplicate removal, blanks, whitespace, data validation, text splitting, Flash Fill, normalization, and repeatable cleanup workflows.

• Remove duplicates and blanks
• Trim and clean text
• Split and combine columns

Sorts, filters, custom views, slicers, advanced filters, grouped rows, and practical list exploration.

• Basic sorting and filtering
• Custom sort orders
• Advanced Filter

Chart selection, formatting, combo charts, sparklines, conditional formatting, map-style visuals, and storytelling with data.

• Choose the right chart
• Format charts clearly
• Combo charts and secondary axes

Pivot table setup, fields, grouping, calculated fields, slicers, pivot charts, refresh behavior, and source-data habits.

• Create your first pivot table
• Group dates and numbers
• Value field settings

Dashboard layouts, KPIs, visual hierarchy, slicers, report refreshes, printable summaries, and executive-ready workbook design.

• Dashboard planning
• KPI cards and summary blocks
• Interactive dashboards

Importing data, cleaning steps, merges, appends, parameters, folder queries, refreshes, and reusable transformation logic.

• Get data into Power Query
• Clean and transform columns
• Merge and append queries

Tables, relationships, measures, DAX basics, star schemas, model-driven pivots, and scalable reporting logic.

• Data model basics
• Relationships
• DAX measures

Descriptive statistics, what-if tools, forecasting, scenarios, Solver, analysis add-ins, and practical business analysis.

• Descriptive statistics
• What-if analysis
• Forecasting

Assumptions, scenarios, forecasting, valuation logic, model checks, sensitivity tables, and financial statement workflows.

• Model structure and assumptions
• Revenue and cost forecasting
• Scenario and sensitivity analysis

Macro recording, VBA basics, workbook events, loops, user forms, worksheet automation, and practical code safety.

• Record your first macro
• VBA editor basics
• Loops and conditions

Keyboard shortcuts, quick access setup, selection tricks, navigation, templates, reusable workflows, and time-saving habits.

• Navigation shortcuts
• Selection and editing shortcuts
• Quick Access Toolbar

Comments, notes, sharing, version history, protection, tracked changes alternatives, and review-ready workbook habits.

• Comments and notes
• Sharing and co-authoring
• Version history

Rules, formulas, icon sets, color scales, data bars, duplicate checks, variance flags, and report-friendly highlighting.

• Highlight cells rules
• Formula-based rules
• Icon sets, data bars, and color scales

Dropdowns, dependent lists, custom validation formulas, input messages, error alerts, and controlled worksheet entry.

• Dropdown lists
• Dependent dropdowns
• Custom validation formulas

Named ranges, Name Manager, formula tracing, error checking, Watch Window, Evaluate Formula, and spreadsheet audit habits.

• Named ranges and Name Manager
• Trace precedents and dependents
• Evaluate Formula and error checking

Layout patterns, number formats, styles, sheet organization, workbook conventions, readability, and professional spreadsheet presentation.

• Worksheet layout patterns
• Number formats and styles
• Workbook navigation design

Print areas, page breaks, scaling, repeating headers, margins, headers, footers, page setup, and PDF export.

• Print areas and page breaks
• Scaling and fit-to-page
• Repeating rows and headers

CSV files, text imports, web data, workbook links, external connections, exports, file types, and refreshable data flows.

• CSV and text imports
• External workbook links
• Web and online data

Template structure, reusable dashboards, budget workbooks, checklists, input sheets, documentation, and protected starting files.

• Template planning
• Reusable input sheets
• Template protection

Invoices, bank reconciliations, ledgers, aging reports, budgets, variance checks, and accounting-ready workbook controls.

• Invoice trackers
• Bank reconciliation
• Aging reports

Task trackers, timelines, Gantt-style views, risks, owners, status reporting, milestones, and project dashboards.

• Task trackers
• Gantt-style timelines
• Risk and issue logs

Inventory lists, reorder points, stock movements, simple scheduling, operations dashboards, and exception tracking.

• Inventory lists
• Reorder points
• Stock movement logs

Excel Copilot, prompt writing, formula help, summaries, data analysis questions, review checks, and safe AI-assisted workflows.

• Prompting for spreadsheet help
• AI-assisted formula writing
• AI summaries and insights

Readable layouts, color contrast, alt text, keyboard use, accessible tables, clear labels, and usability checks for shared workbooks.

• Readable worksheet structure
• Color contrast and meaning
• Alt text and object labels