Microsoft Excel Masterclass With ChatGPT, Copilot & AI

This lesson walks you through how to launch Microsoft Excel on a Windows desktop, from using the Start menu to searching and opening the application. You’ll also learn how to obtain a valid license through Microsoft 365, including available plans and features like cloud storage and multi-device access. The session explains what tools come bundled with the subscription, such as Word and PowerPoint. By the end, you’ll be ready to access Excel and understand the essentials of getting started with the software.

This lesson introduces the startup interface of Microsoft Excel, helping you understand how to navigate the platform right after launch. You’ll explore key sections like Home (recent files and pinned workbooks), New (blank sheets and templates), and Open (accessing files from your device or cloud storage like OneDrive). The session also explains account settings, Excel options, and basic interface controls. By the end, you’ll be comfortable navigating the Excel start screen and accessing your files efficiently.

This lesson provides a complete walkthrough of the Microsoft Excel interface, helping beginners understand how to open workbooks, navigate tabs, and use essential tools efficiently. You’ll explore key components like the Quick Access Toolbar, Ribbon, Formula Bar, worksheets, rows, columns, and different viewing options. The session also introduces important tabs such as Home, Insert, Formulas, Data, and View, explaining their core functions. By the end, you’ll have a strong foundation in navigating Excel confidently and understanding its workspace structure.

This lesson demonstrates how to use ChatGPT to quickly generate custom datasets for practicing Microsoft Excel skills. You’ll learn how to create realistic sample data for tasks like formulas, pivot tables, data analysis, and industry-specific exercises using effective prompting techniques. The tutorial also covers refining prompts, exporting datasets, and customizing data formats for different Excel scenarios. By the end, you’ll be able to generate unlimited practice datasets in minutes, making Excel learning faster and more practical.

This comprehensive lesson explores the integration of Microsoft Copilot within Excel to transform how you interact with data. You will learn to use natural language prompts to analyze business results, summarize key trends, and generate visual charts instantly. The course also covers advanced modeling techniques, such as applying "what-if" scenarios to project future growth across multiple quarters. By the end of this session, you will be able to perform complex calculations and explore various data possibilities with ease.

In this lesson, you will learn how to set up and prepare Microsoft Excel to effectively utilize Copilot. The setup requires a Copilot Pro account, an updated version of Excel, and having the autosave feature turned on with your file saved to a cloud drive. Additionally, you will discover how formatting your data as a table allows Copilot to better analyze your information. Once configured, the lesson will introduce the wide range of features available, including data insights, formula column suggestions, and conditional formatting.

This lesson provides a comprehensive overview of the Copilot pane, demonstrating how to open, close, move, and resize it within the interface. Students will explore various options for interacting with data, including creating formula columns, viewing data insights, applying conditional formatting, and utilizing suggested prompts tailored to specific tables. Additionally, the lesson covers how to input commands via the prompt area, either by typing or by enabling the microphone for voice commands

This lesson introduces Copilot Insights, demonstrating how the "show data insights" feature automatically analyzes a specified data range to generate useful pivot charts and trends, such as sales by date or quantity by reason. Students will learn how to review these AI-generated results for accuracy, add specific insights to new sheets, ask follow-up questions, or use the "change topic" option to refresh the analysis memory. Finally, the session covers how to instantly compile all generated visualizations and their underlying pivot tables into a clean grid pattern for comprehensive data review.

In this lesson, you will learn how to interact with Copilot to analyze specific data within a table by erasing memory to start fresh and asking targeted questions. The video demonstrates how Copilot processes data to identify top-performing sales personnel, break down sales by region, and generate charts or tables that can be added to new sheets. You will also explore Copilot's suggested prompts for sorting, filtering, and finding trends, highlighting the importance of clear prompt phrasing to achieve accurate results.

This lesson introduces Copilot Lab, a tool that provides optimized prompt suggestions tailored to specific tasks like creating, editing, or understanding data. Viewers will learn how to navigate the Copilot Lab page, applying filters based on specific apps like Excel or Outlook, as well as job types, to locate the most relevant prompts. Additionally, the lesson covers the "what's new" section, demonstrating how to stay up-to-date with Copilot's monthly feature updates and improvements.

This lesson covers the fundamental steps for managing files in Excel, focusing on how to open and save workbooks effectively. You will learn how to access existing files from recent or pinned lists, as well as browse specific folders to locate your documents. Additionally, the lesson clarifies the critical distinction between using "Save" to update an existing file with new changes and using "Save As" to name new workbooks or duplicate existing files under different names and locations.

This lesson guides you through the foundational steps of using Excel, beginning with how to properly create and save a new workbook. You will learn how to structure a basic spreadsheet by setting up table titles, column headers, and row headers using a monthly expense log as a practical example. The instructor also highlights the long-term consistency of Excel's interface across versions and outlines future tracking tasks like calculating totals, averages, and percentages

In this lesson, you will learn how to input expense numbers in Excel and adjust cell widths to keep text within borders. You will explore Excel’s default alignment standards—where text is left-aligned while dates and numbers are right-aligned to maintain a clean, readable layout. Finally, the session demonstrates how right alignment keeps decimal places perfectly aligned in a straight line, ensuring your data remains organized and user-friendly.

This lesson explores the essential data types in Excel, teaching you how to distinguish between text, numeric, alphanumeric, and date data. You will learn how to access the "Format Cells" menu to convert text into specific custom formats, such as month-and-year date displays. Additionally, the lesson covers how to enhance numeric presentation by adding decimal places and thousand separators. Finally, you will discover how to efficiently replicate these styles across multiple cells using the powerful Format Painter tool.

Learn the fundamentals of manual calculations in Excel, beginning with the essential use of the equals operator to perform basic mathematical operations. Rather than inputting absolute numbers, this lesson introduces the concept of cell references, which automatically adapt when data changes or when formulas are copied across columns and rows. By mastering relative cell movement, you can drastically speed up your workflow and efficiently manage totals across large sheets without repeating manual entry.

This lesson teaches students how to calculate and format expense percentages across rows and columns using basic cell formulas. It explores the practical difference between relative cell references, which change when a formula is copied, and absolute references that keep specific values constant. By using dollar signs before row numbers or column names, learners will master how to prevent unwanted cell shifting. Ultimately, the session prepares students to transition from manual additions to more advanced shortcuts and automated formulas

This lesson introduces Excel functions as a tool to make data calculations easier by replacing tedious, manual formulas with powerful shortcuts. The speaker demonstrates how to use the SUM function to add a range of cells, utilizing tools like ChatGPT to generate the correct syntax and the Excel formula builder to manually select specific data ranges. Finally, the lesson highlights how to save time by copying and pasting these functions across multiple columns and rows to automatically adjust and calculate totals.

This lesson demonstrates how to use Copilot in Excel to automatically generate a total column for monthly expense data, emphasizing that the data range must first be formatted as a table for the tool to function. While Copilot successfully generates and inserts a formula column for the total without requiring manual coding, its capabilities are currently limited when attempting to add formula rows. Ultimately, the lesson concludes that Copilot works well for adding a column with a formula but does not perform well when trying to add a row with a formula.

In this lesson, you will move beyond the manual method of calculating averages by dividing total expenses by the number of entries. Instead, you will learn how to leverage AI tools to generate the correct average formula for a specific cell range, such as finding the average January expenses. The lesson also demonstrates how to use the built-in formula bar to select the average function and choose your data range. Finally, you will see how easily this formula can be copied across columns to instantly calculate average expenses for consecutive months

Learn how to estimate and control the cost of running autonomous AI loops with confidence. This lesson covers monitoring usage, setting spending limits, and optimizing model selection to keep workflows efficient and budget-friendly. By the end, you'll know how to safely run long-running AI loops without worrying about unexpected API costs.

This lesson teaches you how to identify the lowest and highest values in a dataset using the MIN and MAX functions. You will learn how to apply these formulas to a specific range of cells, ensuring totals are excluded so your analysis remains accurate. The course demonstrates two efficient methods for implementing these tools: generating the formula code or utilizing the built-in functions formula bar. By the end of this lesson, you will be able to easily pinpoint your minimum and maximum data points, regardless of how many rows your spreadsheet contains.

Learn how to estimate and control the cost of running autonomous AI loops with confidence. This lesson covers monitoring usage, setting spending limits, and optimizing model selection to keep workflows efficient and budget-friendly. By the end, you'll know how to safely run long-running AI loops without worrying about unexpected API costs.

This lesson focuses on accelerating your Excel workflow by moving beyond traditional addition and formula-bar selections to utilize quick keyboard shortcuts. You will learn how to write the sum function directly with the tab key, execute the one-click AutoSum feature, and use the "Alt + =" shortcut to instantly calculate numbers located above or to the left of an active cell. Additionally, the lesson covers the Autofill technique, demonstrating how to drag the cursor from a cell's bottom-right corner to instantly copy and apply formulas to adjacent cells without manual copying and pasting.

This lesson explores how to expand the use of Excel's AutoSum feature beyond basic addition to include other essential functions like average, count numbers, maximum, and minimum. You will learn how to access these options through the formula bar arrow, apply them to calculate specific data points like maximum or minimum values, and handle empty cells effectively. Additionally, the video demonstrates how to combine these functions with the AutoFill tool to efficiently populate subsequent cell values across your spreadsheet

This lesson demonstrates how to efficiently manipulate data and add formula columns using Copilot. Learners will explore how to easily calculate percentages, extract specific elements like first and last names from a full-name column, and generate time-based metrics like sales years and months directly from existing dates. By utilizing automated prompt suggestions, students will see firsthand how quickly Copilot analyzes data and inserts precise new columns, eliminating the need to write complex formulas manually.

Learn how to estimate and control the cost of running autonomous AI loops with confidence. This lesson covers monitoring usage, setting spending limits, and optimizing model selection to keep workflows efficient and budget-friendly. By the end, you'll know how to safely run long-running AI loops without worrying about unexpected API costs.

Learn how to estimate and control the cost of running autonomous AI loops with confidence. This lesson covers monitoring usage, setting spending limits, and optimizing model selection to keep workflows efficient and budget-friendly. By the end, you'll know how to safely run long-running AI loops without worrying about unexpected API costs.

In this lesson, students will master Excel's fundamental cut, copy, and paste functions to efficiently manage and organize spreadsheet data. The session covers the crucial distinctions between moving data entirely and duplicating it elsewhere. Participants will learn multiple execution methods, including Home tab toolbar options, standard keyboard shortcuts like Ctrl+X, Ctrl+C, and Ctrl+V, as well as rapid drag-and-drop techniques. Additionally, the lesson demonstrates how to seamlessly apply these techniques across different sheets within a workbook.

In this lesson, you will learn how to adjust column widths and row heights to prevent text from being hidden or overlapping into adjacent cells. The speaker demonstrates three distinct methods to modify these dimensions: manually dragging the boundaries between columns or rows, inputting specific values via the right-click context menu, and double-clicking the border to automatically autofit the space to match the longest line of content. By mastering these techniques, you can ensure all cell data is clearly visible and professional looking.

In this lesson, you will learn the simple steps to hide and unhide rows and columns in a spreadsheet, allowing you to temporarily conceal data without deleting it. The speaker demonstrates how to select a specific column or row, perform a right-click, and choose the option to hide it. To bring the hidden data back into view, you simply select the surrounding rows or columns, right-click, and select unhide. This efficient technique can be applied to single or multiple rows and columns simultaneously to easily manage your data visibility.

This lesson teaches you how to efficiently manage data structure by inserting and deleting rows and columns in an Excel workbook. You will discover how inserting structural elements defaults to adding columns to the left and rows to the top of your selection. Finally, the video demonstrates both standard right-click mouse techniques and faster keyboard shortcuts—using Control, Shift, and the plus or minus keys—to modify your sheets without interrupting your workflow.

This lesson covers the fundamentals of cell and text formatting in Excel to transform plain, unorganized data into a clean and presentable spreadsheet. You will explore the font settings located on the Home tab, learning how to change fonts, adjust text sizes, and apply emphasis styles such as bold, italics, and underlines. The video demonstrates how to strategically modify sheet titles and subheadings to draw focus and improve readability, ensuring your final sheet looks eye-catching yet professional and consistent.

In this lesson, you will learn how to make your spreadsheets look more professional and presentable by customizing cell backgrounds and font colors. The video demonstrates how to navigate built-in color themes, standard colors, and advanced options, including using the custom tab to match precise brand aesthetics with hex codes. You will also discover how to apply consistent cell formatting across extended text ranges and use contrasting colors effectively for subtitles and tables.

Learn how to enhance the presentation of your Excel sheets by adding and customizing cell borders. This lesson covers the various border options available in the font box, including top, bottom, thick outside, and double borders. You will also discover how to adjust line styles, modify colors, and utilize the "More Borders" tab for advanced formatting control. By practicing these formatting techniques, you will be able to make your data tables look more professional and user-friendly.

In this lesson, you will learn how to make your Excel data dynamic and visually engaging by utilizing conditional formatting located on the Home tab. The session covers the step-by-step process of creating, editing, and managing custom rules to automatically change font and fill colors based on specific cell values. Additionally, you will discover how to leverage AI tools like ChatGPT to quickly generate the exact instructions and formulas needed for your formatting criteria.

This hands-on lesson teaches students how to use ChatGPT to generate custom practice datasets and instructions directly inside Excel. Learners will practice importing data, resolving common text formatting errors, and applying core functions like Sum, AutoSum, Average, and percentage calculations. Additionally, the course covers key data presentation skills, including absolute referencing, currency formatting, and cell styling, before requiring students to submit their own AI-generated practice tables.

This lesson provides an introductory understanding of how Excel lists function and the best practices for building them properly. Students will learn the importance of using formatted column headers to serve as data identifiers for both the user and Excel. The course covers critical structure requirements, explaining how completely blank rows or columns break a single dataset into separated pieces and disrupt shortcuts like selecting all data. Finally, the lesson emphasizes formatting consistency, ensuring that each column contains only its designated data category for a well-arranged, functional list

This lesson covers how to perform quick sorting to instantly organize spreadsheet lists. You will learn to use the "Sort and Filter" tools in the Data tab to rearrange text, numbers, or dates into ascending (A to Z) or descending (Z to A) order based on your active cell. This technique allows you to easily view data logically, such as grouping categories or ranking items from lowest to highest values.

Learn how to use multi-level sorting in Excel to organize data by multiple criteria simultaneously. By accessing the main sort options under the Data tab, you can prioritize columns to arrange primary groups first, followed by secondary groups in alphabetical order. This lesson demonstrates the process using first and last names, while exploring Excel's capability to support up to 60 or 64 levels of sorting.

In this lesson, you will learn the critical differences between a raw, unformatted data list and an Excel table. You will discover how manual formatting, like applying custom cell colors, can quickly become scrambled and messy when sorting or filtering data. The session demonstrates how to easily convert a basic list into an official Excel table using the "Format as Table" options under the Home tab's styles menu. Ultimately, you will see how utilizing formal tables preserves clean, alternating row colors and a highly readable presentation, no matter how much you sort or filter your data.

In this lesson, you will learn how to leverage Excel Copilot to quickly sort spreadsheet data from A to Z without needing to know default Excel sorting features. The session demonstrates how to write simple text prompts to execute standard sorting commands directly on your data columns. Additionally, you will discover the limitations of Copilot when attempting complex custom sorts, such as chronological month ordering, and learn when it is necessary to switch back to Excel's traditional manual sorting tools.

In this lesson, you will learn how to clean your data table and use the "change topic" feature to reset Copilot's memory for fresh, independent prompts. The video demonstrates how to navigate the editing options in Copilot to sort, highlight, and filter your dataset efficiently. You will also explore Copilot's specific sorting capabilities, focusing on how to organize data columns in ascending or descending order. By the end of this session, you will be able to confidently apply automated sorting to arrange categorical data from A to Z.

This lesson introduces the "Filter" option in Excel's Data tab, which allows you to isolate and view only the specific data you need from a large list, such as sales figures for a particular month or category. Enabling this feature adds drop-down arrows to all column headers, providing quick access to sorting tools and checkboxes to refine your dataset. The tutorial covers simple, single-column filtering by selecting specific items like "July" or "computers," while previewing the concept of multi-level filtering covered in the next video.

This lesson demonstrates how to apply multi-level filtering to effectively narrow down large datasets. Viewers will learn how to combine multiple criteria, such as filtering data by a specific product category and then refining the results by a particular month. The video also covers how to integrate advanced text filters, such as identifying products that contain a specific keyword, to isolate highly targeted information. Ultimately, this tutorial provides the essential skills needed to manipulate and analyze complex data through sequential filtering layers.

This lesson explores Excel's "subtotal" feature, a powerful alternative to manually sorting, inserting rows, and calculating category totals. Students will learn how to easily generate automated summaries—such as total sales by category or item counts by month—using the outline group options. The session also covers how to navigate the different data views, enabling users to seamlessly switch between viewing grand totals, subtotals, or the complete expanded dataset.

In this lesson, you will explore how to utilize Copilot to calculate subtotals within a dataset. You will learn the importance of preparing your data beforehand, such as sorting it by category, to help the AI effectively analyze and compile the information. The lesson demonstrates that while Copilot may not insert traditional subtotal rows directly into your existing table, it can successfully generate and present the calculated results for you to add to your sheet. Ultimately, this session provides an honest evaluation of Copilot's current limitations and capabilities regarding data subtotaling tasks.

Learn how to use Excel's Text to Columns feature to quickly split data into separate fields using delimiters or fixed-width formatting. This lesson also demonstrates how Microsoft Copilot can automate the same task with simple natural language prompts, eliminating the need for complex formulas. By the end, you'll be able to efficiently separate names and other structured text using both traditional Excel tools and AI assistance.

Learn how to use Excel's LEFT, RIGHT, and MID functions to extract specific portions of text from a cell. This lesson demonstrates how to separate structured values such as supplier IDs, part numbers, and product codes using simple formulas instead of manual editing. By the end, you'll be able to efficiently parse and organize text data across large datasets with ease.

Learn how to use Microsoft Copilot to automate text extraction tasks that would normally require Excel's LEFT, RIGHT, and MID functions. This lesson shows how simple natural language prompts can generate the required columns and formulas automatically, making it easier to extract supplier IDs, part numbers, and product codes. By the end, you'll know how to use AI to perform common text manipulation tasks faster and with minimal manual effort.