The Excel Autopilot Course 2025

Learn to analyze, summarize, and calculate data with pivot tables and pivot charts, using clean, uniquely headed raw data and interactive filtering that updates both the table and chart.

Learn to create and customize pivot tables from well-structured data, drag fields to rows, columns, and values, apply slicers and timelines, and format and refresh reports for clear insights.

Learn how to speed up Excel work by changing default settings, including font, default save location, language, and pivot table options, plus creating custom lists for autofill.

Select a pivot table, insert a chart such as a clustered column, design with options, add axis titles and data tables, and use a timeline to filter dates.

Learn to use the quick access toolbar in Excel to auto-fit column width and apply common commands. Customize with favorites, access via Alt numbers, and assign macros for faster work.

Master ten essential Excel shortcuts to work faster, including ctrl+a, ctrl+alt+v, F4, F2, ctrl+z, ctrl+e, and sheet navigation and paste special tricks for efficient data work.

Create your own tab in the Excel ribbon to keep tools handy. Customize the ribbon, name the tab, group commands like the developer tab, and insert the ones you want.

Discover how to use Excel templates from microsoft 365, including gantt charts, calendars, and timesheets, accessed via file, new, and keyword search.

Learn to customize Excel defaults by adjusting font and font size, save locations, separators, and themes through file, options, and custom lists to streamline your workflow.

Apply your company identity in Excel by customizing theme colors and fonts, saving hex or RGB colors, and applying them to charts and pivot tables via the quick access toolbar.

Explore how AI transforms Excel automation, enabling tools inside and outside Excel, data cleaning, insights, and natural language prompts to analyze data and forecast trends, while weighing accuracy and privacy.

Discover AI tools inside Excel, including geography data types and analyze data with natural language questions, then leverage Copilot to turn data into drafts, pivot tables, and charts.

Explore ChatGPT and Midjourney to enhance Excel work: use ChatGPT for formulas, macros, and M code in Power Query or Power BI, and generate visuals with Midjourney prompts on Discord.

Learn how Excel VBA macros automate repetitive tasks by recording actions, using the developer tab, the VBA editor, and modules.

Master the record macro tool in Excel's developer tab to create, name with underscores, assign shortcuts, store in workbook or personal folder, and edit by inspecting Visual Basic modules.

Learn the basics of the VBA editor, including macros in modules, user forms with controls, variables, and loops, plus event-triggered macros and pivot-table updates.

Learn how to declare with dim and use variables in VBA, selecting data types such as string, long, and decimal, and assign values from range A1, including last filled cell.

Explore four loop types in Excel autopilot: for, for each, do while, and do until, with variable declarations and macro execution.

Learn to use if statements in Excel and VBA, including if then else, else if, and select case, to test conditions and trigger actions or messages.

Automate common tasks in Excel with macros to reduce human error, generate pdfs, attach and email sheets, consolidate reports, auto-generate invoices, and create an index sheet with hyperlinks.

Learn to implement error handling and debugging in VBA by using option explicit, descriptive variable names, breaking complex code, commenting, and debugging with F8, F9 and on error resume next.

VBA events trigger macros in Excel when actions occur, such as opening a workbook. Place code in the worksheet or workbook object for the event to run.

Learn to connect to data, transform it, and load it into Excel with Power Query; automate consolidation across multiple files and PDFs, and refresh data in seconds.

Create a unified pivot table by combining multiple data sets in Power Pivot, adding to the data model, and linking tables before building the pivot.

Learn how Power BI visualizes data by integrating multiple sources, transforming data with Power Query, and building interactive dashboards with AI Q&A insights.

Use Power Query to consolidate country sales data from multiple Excel files into one workbook, transform and load, then create pivot charts with a month slicer.

Learn to automate intercompany reconciliation in Excel by building a macro that gathers data from multiple sheets into a reconciliation sheet and uses sumifs to match receivables and payables.

Define your automation goals and select the right tools before starting. Plan steps, test along the way, invest time to learn, and stay updated with Excel features.

Explore the Excel autopilot course 2025 and gain data insights with built-in AI tools. Automate tasks with macros and streamline data cleansing using Power Query for multi-source pivots.