Leila Gharani | How to use Analyze Data in Excel (AI Creates Pivot Tables and Charts) @LeilaGharani | Uploaded February 2023 | Updated October 2024, 1 hour ago.
Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-courses
Data analysis in Microsoft Excel has just gotten a LOT easier. A feature called "Analyze Data" uses AI (artificial intelligence) makes this process simpler, faster and more intuitive. This feature used to be called IIDEAS in Excel but it was renamed to "Analyze Data". It automatically creates pivot tables for you so you don't even need to think about what to put in the rows and what to put in the columns of the pivot tables. You'll get pivot table and chart suggestions which you can immediately use. You'll also get data insights you might not be actively looking for which could be important for your analysis. This tool simply makes analyzing data in Excel really easy.
Requires Excel for Microsoft 365.
00:00 Data Analysis Made Easy with Excel AI
00:23 Analyze Data with AI in Excel
03:02 Automatically Create Charts by Asking Questions
04:36 Use Natural Language to Get Insights Into Data
06:42 Update Insights When Data Changes
07:46 Wrap Up
🌍 My Online Courses ► xelplus.com/courses
🎬 LINKS to related videos:
Excel What-If Analysis Data Table: youtu.be/4VuO1lO6USo
Power BI Slicers - A Step-by-Step Tutorial for All Types to Improve Data Analysis: youtu.be/kQ-yUKE_KHE
➡️ Join this channel to get access to perks: youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
🎥 RESOURCES I recommend: xelplus.com/resources
🚩Let’s connect on social:
Instagram: instagram.com/lgharani
LinkedIn: linkedin.com/company/xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel #ai
Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-courses
Data analysis in Microsoft Excel has just gotten a LOT easier. A feature called "Analyze Data" uses AI (artificial intelligence) makes this process simpler, faster and more intuitive. This feature used to be called IIDEAS in Excel but it was renamed to "Analyze Data". It automatically creates pivot tables for you so you don't even need to think about what to put in the rows and what to put in the columns of the pivot tables. You'll get pivot table and chart suggestions which you can immediately use. You'll also get data insights you might not be actively looking for which could be important for your analysis. This tool simply makes analyzing data in Excel really easy.
Requires Excel for Microsoft 365.
00:00 Data Analysis Made Easy with Excel AI
00:23 Analyze Data with AI in Excel
03:02 Automatically Create Charts by Asking Questions
04:36 Use Natural Language to Get Insights Into Data
06:42 Update Insights When Data Changes
07:46 Wrap Up
🌍 My Online Courses ► xelplus.com/courses
🎬 LINKS to related videos:
Excel What-If Analysis Data Table: youtu.be/4VuO1lO6USo
Power BI Slicers - A Step-by-Step Tutorial for All Types to Improve Data Analysis: youtu.be/kQ-yUKE_KHE
➡️ Join this channel to get access to perks: youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
🎥 RESOURCES I recommend: xelplus.com/resources
🚩Let’s connect on social:
Instagram: instagram.com/lgharani
LinkedIn: linkedin.com/company/xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel #ai
