# FREE Excel Tutoring (Powered by AI) — Learn Fast!

Source: https://www.youtube.com/watch?v=Rj7yrivdPbc
Recap page: https://rapidrecap.app/video/Rj7yrivdPbc
Generated: 2025-07-14T17:06:39.736+00:00

---
## Quick Overview

Microsoft Copilot Vision acts as a free, built-in AI tutor within Excel, capable of explaining data, performing calculations like AutoSum and XLOOKUP, and creating pivot tables and charts directly from your spreadsheet data, eliminating the need for external searches or manual formula creation.

**Key Points:**
- Copilot Vision is a free, built-in AI tutor for Excel, accessible directly from Windows.
- It can summarize and explain complex spreadsheet data in plain English, identifying trends and making recommendations.
- Copilot assists with basic calculations like AutoSum, totaling units sold (e.g., 10,850 cookies in January).
- It guides users through advanced functions such as XLOOKUP to populate data based on IDs.
- Copilot helps create pivot tables to summarize data by region and generate visual charts like column charts.
- Users can customize Copilot's voice from several options, including Canyon, Grove, and Wave.
- The feature extends beyond Excel to other Microsoft apps like Word and PowerPoint, and even websites.

![Screenshot at 0:06: An Excel PivotChart displaying a bar graph of 'Sum of Units Sold' across different regions, demonstrating Copilot's data visualization capabilities.](https://ss.rapidrecap.app/screens/Rj7yrivdPbc/00-00-06.png)

**Context:** Microsoft has introduced Copilot Vision, an AI-powered feature integrated into Windows, designed to act as a personal tutor across various applications. This video specifically demonstrates its capabilities within Microsoft Excel, showcasing how it can assist users with data analysis, formula creation, and visualization tasks without requiring prior expertise or external searches.

## Detailed Analysis

Microsoft has introduced Copilot Vision to Windows, functioning as a personal AI tutor directly within applications like Excel. Users can launch Copilot, share their Excel screen, and then verbally ask questions or request tasks. Copilot can summarize complex sales data, identifying trends like the Sugar Cookie product having the lowest sales and highest returns across all regions, suggesting it for removal. It assists with calculations by guiding users through functions like AutoSum to total units sold (e.g., 10,850 cookies in January) and XLOOKUP to populate product names based on product IDs, explaining each step. Furthermore, Copilot helps create data visualizations, such as pivot tables to summarize units sold by region and column charts to visually compare regional sales, highlighting the West region as the highest performer. While generally effective for everyday tasks, the presenter notes occasional misunderstandings or pauses. The feature is not limited to Excel, extending to Word, PowerPoint, and websites, with future updates promising direct on-screen highlighting for instructions.

### Introduction to Copilot Vision

- Microsoft Copilot Vision is a new AI feature in Windows that acts as a built-in tutor for applications like Excel
- It can explain data, help fix mistakes, and teach users how to work with data in plain English
- The feature is free to use and can be accessed by searching for 'Copilot' on the taskbar or downloading it from the Microsoft Store.

### Getting Started with Copilot Vision in Excel

- Users launch the Copilot app and click the 'Share screen with Copilot' icon to select the Excel window
- This focuses Copilot's attention on the active spreadsheet, allowing it to understand the data context.

### Analyzing and Interpreting Data

- Copilot can summarize sales data, detailing products, regions, units sold, revenue, and returns
- It can analyze data to provide recommendations, such as suggesting the Sugar Cookie be cut from the product line due to low sales and high returns across all regions.

### Performing Calculations with Copilot

- Copilot guides users through Excel functions like AutoSum to quickly total columns (e.g., summing units sold to 10,850)
- It also assists with more complex functions like XLOOKUP to fill in missing data, such as product names based on product IDs, by explaining the required arguments.

### Creating PivotTables and Charts

- Copilot helps create pivot tables to summarize data by categories, like units sold by region
- It also recommends and assists in generating appropriate charts, such as a column chart, to visually represent data comparisons and identify top-performing regions.

### Customizing Copilot's Voice

- Users can change Copilot's voice by clicking the microphone icon in the app and then the settings gear
- Multiple voice options like 'Grove', 'Wave', 'Rain', 'Meadow', 'Canyon', 'Birch', 'Elm', and 'Alder' are available for preview and selection.

### Overall Impressions and Future Capabilities

- Copilot Vision works surprisingly well for everyday tasks, acting as a helpful built-in tutor
- Future updates are expected to include the ability for Copilot to directly highlight areas on the screen, rather than just describing them
- The feature is applicable across various Microsoft apps like Word, PowerPoint, and even websites.

![Screenshot at 0:05: An Excel spreadsheet showing a SUM formula being entered in a cell below a column of numbers.](https://ss.rapidrecap.app/screens/Rj7yrivdPbc/00-00-05.png)
![Screenshot at 0:06: An Excel PivotChart displaying a bar graph of 'Sum of Units Sold' across different regions (Central, East, West).](https://ss.rapidrecap.app/screens/Rj7yrivdPbc/00-00-06.png)
![Screenshot at 0:18: The Microsoft Copilot interface showing a list of open applications that can be shared, with 'Book1 - Excel' highlighted.](https://ss.rapidrecap.app/screens/Rj7yrivdPbc/00-00-18.png)
![Screenshot at 0:32: An Excel spreadsheet with two tables, one for 'Order ID' and 'Product ID' and another for 'Product ID' and 'Product Name', demonstrating a lookup scenario.](https://ss.rapidrecap.app/screens/Rj7yrivdPbc/00-00-32.png)
![Screenshot at 1:15: The Copilot app interface with a large 'Good afternoon, Kevin' greeting and a 'Share screen with Copilot' icon in the bottom right corner.](https://ss.rapidrecap.app/screens/Rj7yrivdPbc/00-01-15.png)
![Screenshot at 1:50: A man in a blue shirt is superimposed over an Excel spreadsheet containing sales data for cookie products, with the Copilot voice interface at the bottom.](https://ss.rapidrecap.app/screens/Rj7yrivdPbc/00-01-50.png)
![Screenshot at 3:10: An Excel spreadsheet showing the AutoSum function '=SUM(D2](https://ss.rapidrecap.app/screens/Rj7yrivdPbc/00-03-10.png)
![Screenshot at 4:05: The 'Function Arguments' dialog box for the XLOOKUP function in Excel, showing fields for 'Lookup_value', 'Lookup_array', and 'Return_array'.](https://ss.rapidrecap.app/screens/Rj7yrivdPbc/00-04-05.png)
![Screenshot at 5:35: An Excel PivotTable displaying 'Sum of Units Sold' for 'Central', 'East', and 'West' regions, with a 'Grand Total' of 10,850.](https://ss.rapidrecap.app/screens/Rj7yrivdPbc/00-05-35.png)
![Screenshot at 6:09: An Excel spreadsheet showing a PivotTable and a menu for inserting different chart types, with '2-D Column' charts highlighted.](https://ss.rapidrecap.app/screens/Rj7yrivdPbc/00-06-09.png)