Build a rock-solid foundation with core Excel skills every data professional needs.
Transform from casual Excel user to interface expert with advanced Ribbon customization, strategic Quick Access Toolbar configuration, and comprehensive keyboard shortcut mastery for high-performance data analysis workflows.
Master Excel's three reference types to build robust, scalable spreadsheets. Learn when formulas break during copying and how to fix them with precise reference control.
Learn Excel's five core functions that handle 80% of data analysis tasks. Build dynamic dashboards, handle data quality issues, and create conditional logic that transforms raw data into actionable insights.
Master sophisticated formatting techniques including custom number formats, formula-based conditional formatting, performance optimization, and VBA automation for enterprise-level Excel solutions.
Master Excel Tables beyond basic formatting—learn advanced sorting hierarchies, sophisticated filtering criteria, and multi-table architectures that transform spreadsheets into robust analytical platforms for enterprise data management.
Master enterprise-scale data management with advanced Excel Tables, sophisticated filtering techniques, and performance optimization strategies for professional data analysis workflows.
Learn to transform overwhelming spreadsheets into organized, analyzable data using Excel's most powerful data management features. Master sorting, filtering, and tables with practical examples.
Transform from wrestling with unwieldy data ranges to orchestrating sophisticated analysis. Learn to architect Excel Tables for maximum performance, implement professional-grade filtering strategies, and create scalable analytical systems.
Master the art of creating Excel dashboards that automatically adapt to user input and data changes. Learn dynamic named ranges, interactive controls, and professional dashboard design patterns that eliminate manual chart rebuilding.
Transform chaotic real-world data into clean, standardized formats using Excel's powerful temporal and text manipulation functions. Learn advanced parsing techniques, error handling, and performance optimization strategies.
Master Excel's most essential functions for cleaning messy data. Learn to standardize dates, extract text portions, calculate time differences, and combine functions to solve real-world data problems.
Transform chaotic data entry into controlled, consistent input with advanced validation techniques including cascading drop-downs, custom validation formulas, and dynamic validation systems that scale with your organization.
Master Excel's most powerful analysis tool and transform overwhelming datasets into clear insights. Learn to build PivotTables from the ground up with real-world examples and practical techniques.
Learn to perform sophisticated data analysis with Excel's multi-criteria functions. Build dynamic dashboards, debug complex formulas, and optimize performance for large datasets with practical, real-world examples.
Master the advanced Excel lookup technique that outperforms VLOOKUP with bidirectional searches, better performance, and immunity to column insertions. Learn optimization strategies for large datasets and complex business scenarios.
Transform brittle spreadsheets into robust, self-documenting systems. Learn to create readable formulas with named ranges and Excel tables that adapt automatically as your data changes.
Transform static spreadsheets into dynamic analytical dashboards using Excel's most powerful interactive features. Learn advanced techniques for contextual visualization, multi-dimensional filtering, and temporal analysis that rival dedicated BI tools.
Transform messy spreadsheets into bulletproof analytical systems. Learn advanced error handling patterns, debugging techniques, and performance optimization strategies that separate Excel professionals from casual users.
Raw external data is almost never analysis-ready. This lesson teaches you a complete, repeatable workflow for splitting, cleaning, and normalizing imported data using Text to Columns, Flash Fill, and Excel's full suite of text transformation functions — with real-world scenarios and a hands-on exercise.
Most Excel users write formulas and hope they're right. This lesson teaches you to systematically verify them — using Trace Precedents, Trace Dependents, Evaluate Formula, Watch Window, and Error Checking to audit any workbook with professional rigor. Whether you're inheriting a financial model or building your own, these techniques will give you genuine confidence in your numbers.
Raw data is only as useful as it is readable. This lesson teaches you how to use Excel's custom number format system to display numbers, dates, and currencies exactly the way you need — without changing a single underlying value. Learn the four-section syntax, date/time codes, and professional cell formatting techniques from the ground up.