Excel AI Automation and Analysis
Use ai automation and analysis for spreadsheet analysis, formulas, cleanup, reporting, prompts, and automation workflows.
ExcelMojo learning path
ExcelMojo Resources
ExcelMojo resources bring together Excel, Google Sheets, VBA, Power BI, and Tableau learning paths in one place. Start with a beginner guide if you are building confidence, or move straight into formulas, charts, dashboards, automation, reporting, and analytics topics when a specific task needs attention. Each category points to organized guides, article counts, and first reads so readers can move from core concepts to practical examples without losing the thread.
5topics
48guides
1714articles
Build spreadsheet and analytics skills in the right order.
1Excel Formula BasicsA practical first path before moving into deeper examples and advanced tasks.2Google Sheets BasicsA practical first path before moving into deeper examples and advanced tasks.3VBA Basics and MacrosA practical first path before moving into deeper examples and advanced tasks.4Power BI Basics and ComparisonsA practical first path before moving into deeper examples and advanced tasks.5Tableau BasicsA practical first path before moving into deeper examples and advanced tasks.
Explore topics
Find the ExcelMojo area that matches your task.
Each topic below opens into organized guides with article counts, first reads, and practical paths for formulas, automation, reporting, dashboards, and analytics.
Excel Resources
Learn Excel formulas, charts, dashboards, data cleaning, reporting, automation, and AI-assisted workbook skills through structured guide paths.
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.
Google Sheets Resources
Use Google Sheets guides for formulas, functions, formatting, charts, pivot tables, data cleanup, lookups, and finance/statistics work.
Google Sheets Basics
Study basics through sheet setup and row column basics, formatting and page layout, comments recovery and controls and related examples.
Google Sheets Charts Dashboards and Pivot Tables
Study charts dashboards and pivot tables through chart basics and setup, core chart types, dashboards timelines and pivot reports and related examples.
Google Sheets Data Cleaning Validation and Formatting
Study data cleaning validation and formatting through data validation and input controls, cell formatting and symbols, conditional formatting and highlighting and related examples.
Google Sheets Date and Time Functions
Study date and time functions through date function basics, current time and time conversion, date arithmetic and month calculations and related examples.
Google Sheets Dynamic Arrays and Advanced Functions
Study dynamic arrays and advanced functions through array formula basics, stacking and shaping arrays, row column and reduction functions and related examples.
Google Sheets Financial Functions
Study financial functions through time value of money basics, interest payments and loan schedules, depreciation and duration and related examples.
Google Sheets Formula Basics
Study formula basics through formula entry and function basics, references rows and lookup helpers, error handling and troubleshooting and related examples.
Google Sheets Logical Functions
Study logical functions through logical tests and boolean operators, conditional counting summing and averages, is and error-check functions and related examples.
Google Sheets Lookup Functions
Study lookup functions through core lookups and alternatives, vlookup variants and criteria, index match and xmatch and related examples.
Google Sheets Math Functions
Study math functions through basic math and arithmetic, counting and database aggregates, averages minimums maximums and ranking and related examples.
Google Sheets Statistical Functions
Study statistical functions through descriptive statistics and averages, correlation regression and forecasting, probability distributions and related examples.
Google Sheets Text Functions
Study text functions through text function basics and formatting, joining splitting and replacing text, extracting text and characters and related examples.
VBA Resources
Learn VBA macros, procedures, ranges, workbooks, worksheets, errors, and automation patterns for repeatable Excel work.
VBA Basics and Macros
Learn basics and macros through ordered macro lessons, code patterns, and practical Excel automation examples.
VBA Control Structures and Procedures
Learn control structures and procedures through ordered macro lessons, code patterns, and practical Excel automation examples.
VBA Errors and Debugging
Learn errors and debugging through ordered macro lessons, code patterns, and practical Excel automation examples.
VBA Range & Cells
Learn range & cells through ordered macro lessons, code patterns, and practical Excel automation examples.
VBA Strings Dates and Arrays
Learn strings dates and arrays through ordered macro lessons, code patterns, and practical Excel automation examples.
VBA Variables Data Types and Operators
Learn variables data types and operators through ordered macro lessons, code patterns, and practical Excel automation examples.
VBA Workbooks Files and Automation
Learn workbooks files and automation through ordered macro lessons, code patterns, and practical Excel automation examples.
VBA Worksheets & Workbooks
Learn worksheets & workbooks through ordered macro lessons, code patterns, and practical Excel automation examples.
Power BI Resources
Build Power BI skills from basics, data connections, Power Query, DAX, reports, sharing, and administration.
Power BI Basics and Comparisons
Build basics and comparisons skills with core concepts, practical reporting tasks, and related analysis examples.
Power BI Data Connections and Power Query
Build data connections and power query skills with core concepts, practical reporting tasks, and related analysis examples.
Power BI Data Modeling and DAX
Build data modeling and dax skills with core concepts, practical reporting tasks, and related analysis examples.
Power BI Service Sharing and Administration
Build service sharing and administration skills with core concepts, practical reporting tasks, and related analysis examples.
Power BI Visuals and Reports
Build visuals and reports skills with core concepts, practical reporting tasks, and related analysis examples.
Tableau Resources
Learn Tableau basics, data sources, calculations, charts, dashboards, filters, parameters, and reporting workflows.
Tableau Basics
Build basics skills with core concepts, practical reporting tasks, and related analysis examples.
Tableau Calculations & Functions
Build calculations & functions skills with core concepts, practical reporting tasks, and related analysis examples.
Tableau Charts and Dashboards
Build charts and dashboards skills with core concepts, practical reporting tasks, and related analysis examples.
Build spreadsheet and analytics skills with guided training
Use the course route that best matches the category you are studying after you have explored the core guides.