Excel learning path
Excel Resources
Excel resources on ExcelMojo help readers move from everyday workbook basics into formulas, charts, dashboards, reporting, analysis, and automation. Start with the beginner-friendly formula, formatting, data cleaning, and chart paths if you are building confidence, or jump into lookup functions, statistical analysis, what-if tools, and AI workflows when a specific spreadsheet task is in front of you. Each guide groups related articles into a learning path so you can understand the concept first, then apply it with examples, templates, comparisons, and troubleshooting notes.
20guides
725articles
6first paths
Build Excel knowledge in the right order.
1Excel Formula BasicsStudy formula basics through formula basics and function entry, formula auditing and display, symbols and formula utilities and...2Excel FormattingStudy formatting through cell formatting basics, data validation and drop downs, conditional formatting and highlighting and related examples.3Excel Data CleaningStudy data cleaning through duplicate and space cleanup, text and case preparation, sorting filling and lists and related...4Excel ChartsStudy charts through chart basics and setup, core chart types, comparison and composition charts and related examples.5Excel Tables and Data ToolsStudy tables and data tools through pivottable fields filters and grouping, excel tables and structured data, power query...6Excel Lookup FunctionsStudy lookup functions through core lookup functions, xlookup and dynamic array filters, index match and position functions and...
Most popular in Excel
Find the Excel area that matches your task.
Build stronger Excel skills
Use the Excel course library when you want structured practice after reading the articles.
All guides
Browse the complete Excel library.
Each guide groups the most useful articles into a learning path with flagship reads surfaced first.
Excel AI Automation and Analysis
Use ai automation and analysis for spreadsheet analysis, formulas, cleanup, reporting, prompts, and automation workflows.
Excel AI Tools and Copilot
Use ai tools and copilot for spreadsheet analysis, formulas, cleanup, reporting, prompts, and automation workflows.
Excel Charts
Study charts through chart basics and setup, core chart types, comparison and composition charts and related examples.
Excel Counting and Summing Functions
Study counting and summing functions through sum and autosum basics, count functions, database and aggregate functions and related examples.
Excel Dashboards and Reporting
Study dashboards and reporting through business reporting templates, planning and tracking workbooks and related examples.
Excel Data Cleaning
Study data cleaning through duplicate and space cleanup, text and case preparation, sorting filling and lists and related examples.
Excel Date and Time Functions
Study date and time functions through date basics and components, current date and time, formatting and date conversion and related examples.
Excel Errors and Troubleshooting
Study errors and troubleshooting through error basics and diagnosis, specific error fixes, formula error handling and related examples.
Excel Financial Functions
Study financial functions through time value of money basics, loan and payment functions, investment returns and interest and related examples.
Excel Formatting
Study formatting through cell formatting basics, data validation and drop downs, conditional formatting and highlighting and related examples.
Excel Formula Basics
Study formula basics through formula basics and function entry, formula auditing and display, symbols and formula utilities and related examples.
Excel Logical Functions
Study logical functions through if and logical tests, and or not and boolean values, conditional counting and summing and related examples.
Excel Lookup Functions
Study lookup functions through core lookup functions, xlookup and dynamic array filters, index match and position functions and related examples.
Excel Math Functions
Study math functions through math function overview and basic operations, rounding numbers and sign handling, trigonometry and matrix math and related examples.
Excel Productivity and Shortcuts
Study productivity and shortcuts through excel interface and core features, keyboard shortcuts and quick actions, developer tools add-ins and macros and related examples.
Excel Reference Functions
Study reference functions through cell reference basics, sheet and workbook references, row and column references and related examples.
Excel Statistical Functions
Study statistical functions through statistics and descriptive analysis, averages ranking and dispersion, correlation covariance and regression and related examples.
Excel Tables and Data Tools
Study tables and data tools through pivottable fields filters and grouping, excel tables and structured data, power query and data import and related examples.
Excel Text Functions
Study text functions through text function basics, extracting text and characters, cleaning and case conversion and related examples.
Excel What-If Analysis
Study what-if analysis through goal seek solver and scenarios, regression correlation and anova, forecasting functions and models and related examples.