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.

Removing Duplicates Using Power Query

We're going to take a look at removing duplicates using Power Query in Excel.

The 4 Percent Rule: Using Microsoft Excel to Plan for Retirement

Exploring the 4 percent rule through Microsoft Excel provides a hands-on approach to understanding how it might apply to your retirement planning.

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.

MS Forms - 3 new features: Format surveys, send to specific users, and receipt

Microsoft Forms has three new features that were recently rolled out. I'll cover all three in under three minutes. You can now format your surveys or quizzes using bold, italics, or underline. You can also send a survey out to specific users or groups in your organization, and you can have users get a receipt of their responses.

Chris Menard

Chris Menard is a certified Microsoft Trainer (MCT) and works as a full-time Trainer at BakerHostetler - one of the largest law firms in the US. He runs a YouTube channel with 900+ technology videos that cover various tools such as Excel, Word, Zoom, Teams, Gmail, Google Calendar, and Outlook. To date, the channel has helped over 20 million viewers. Menard also does 2 to 3 public speaking events every year, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the Support Staff 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.