Analyze Data Command in Excel - Ask questions about your data using AI

Posted on: 04/03/2023

Need to quickly understand your data in Excel and ask questions about your data? Easy to do using Excel's Analyze Data command located on the Home tab in Excel. Analyze Data using Artificial Intelligence (AI).

You can type questions, and Excel will return results in a PivotTable format. For example, I can type "Show me our three largest clients for 2023?" Analyze Data will give you the answer. Analyze Data also shows you charts for your data and even displays possible questions you may want to ask.

YouTube Video

Download the file used in the video

Analyze Data

Analyze_Data_Chris_Menard (Size: 60.9KB)

Teams Online Training with Chris Menard

Over 3 hours of Teams Training Material. New Teams features will be added to the course as they roll out.

Lifetime access to Teams Course Beginner to Pro with coupon

50% off coupon

Just some of the topics covered

Navigation Teams
Using private Chat
Using group Chat
Teams Meetings
1. Scheduling Meetings
2. Meeting controls
3. Roles in a meeting
4. Sharing resources
5. PowerPoint in a meeting
6. Scheduling Team meetings from Outlook
Working with Teams and Channels
1. Conversations
2. Files
3. Wiki and OneNote
Using Outlook and Teams
Using apps in Teams

Recent Articles

OneNote - SORT PAGES - New Feature - 2022

Previously, in OneNote, if you wanted to sort pages, you had to drag them around manually. Now, you can sort your pages in OneNote automatically!

3 AWESOME TIPS when working with OneNote & Outlook

Need to stay organized with Outlook? Use Microsoft OneNote and Outlook together. Three tips on working with OneNote and Outlook. Tip 1 - Insert your meeting invitation into OneNote. You can see a list of attendees and check that they attended, and take meeting notes.

How to Remove Duplicates Running Left to Right in Excel Using Power Query

Removing duplicates in Excel is a common task, but it can be challenging when the duplicates are running horizontally (left to right) instead of vertically. In this blog post, we'll explore an advanced Excel technique using Power Query to efficiently remove duplicates across rows. This method is particularly useful when dealing with complex data structures where traditional duplicate removal methods fall short.

Become an Expert at Using the TOCOL Function in Excel to Merge Columns

The TOCOL function in Excel is a powerful tool for combining data from multiple columns into a single column.

Copilot in MS Forms: Creating Efficient and Insightful Surveys

Creating surveys can be a daunting task, especially when you aim to gather insightful responses efficiently. With the introduction of Copilot in Microsoft Forms, the process becomes streamlined and intuitive.

Analyze Results from Microsoft FORMS POLLS in Excel | Watch Chris Work

I recently spoke at the Administrative Professional Day Conference hosted by the University of Georgia. After reviewing my survey results in Microsoft Forms, I realized I needed to analyze the survey data. Forms results are immediately available in Excel.

Chris Menard

Chris Menard is a Microsoft Trainer (MCT) and works as a full-time Trainer at BakerHostetler - one of the largest law firms in the US. Chris runs a YouTube channel with 900+ technology videos that cover various tools such as Excel, Word, Zoom, Teams, Gmail, Copilot, Google Calendar, and Outlook. To date, the channel has helped over 20 million viewers. Menard also does 2 to 3 public speaking events yearly, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the University of Georgia, and CPA conferences. You can connect with him on LinkedIn at https://chrismenardtraining.com/linkedin or watch his videos on YouTube at https://chrismenardtraining.com/youtube.