Oct 28, 2024 - I'll be Speaking at the Administrative Professionals Conference on Excel Copilot: Data Analysis Simplified

Posted on:  04/29/2024
Oct 28, 2024 - I'll be Speaking at the Administrative Professionals Conference on Excel Copilot: Data Analysis Simplified

On October 28, 2024, in Aurora, CO, I'll present a transformative session on Excel Copilot: Data Analysis Simplified. Copilot is a powerful tool that will revolutionize how we interact with Excel, offering unparalleled capabilities to sort and filter data easily, apply conditional formatting for dynamic visual cues, create charts that tell compelling data stories, and master PivotTables for in-depth analysis.
Whether you're a seasoned professional or new to Excel, Copilot for Excel is designed to enhance your productivity and insight, turning complex data into actionable intelligence. Join us to unlock Excel's full potential and elevate your analytical skills to new heights.

Update on October 21, 2024 - Copilot Wave 2 is available

What is Coplot Wave 2 for Excel?

Copilot Wave 2 for Excel introduces several exciting features designed to enhance data analysis and automation. Here are some of the key updates:

  • Python Integration: You can now use Python directly within Excel for advanced data analysis, making it easier to perform complex calculations and visualizations.
  • Enhanced Formulas and Functions: Support for more formulas like XLOOKUP and SUMIF, along with improved conditional formatting.
  • Advanced Visualizations: Copilot can help you create and iterate on visualizations such as charts and PivotTables to better fit your needs
Copilot in Excel - Presentation by Chris Menard - October 28, 2024

Copilot in Excel - Presentation by Chris Menard - October 28, 2024

Session and Conference Details

Session Description

Copilot for Excel is the key to unlocking Excel's full potential. Experience the power to effortlessly sort and filter your data for deeper insights, apply visual cues with conditional formatting, create impactful charts, and master PivotTables for comprehensive data analysis. With Copilot, you'll witness the transformation of raw data into meaningful information, opening up new possibilities in your data analysis journey.

Note: Most of this session will be hands-on. Bring your laptop loaded with Copilot. If you are new to Copilot, feel free to attend and learn how this AI tool in M365 can transform your work.

Recent Excel Copilot Video by Chris Menard

Copilot Wave 2: Exciting Advanced features in Excel - XLOOKUP

In this tutorial, I demonstrate how to leverage the advanced capabilities of Microsoft 365 Copilot in Excel to convert revenues from various currencies to USD using XLOOKUP. I walk you through creating a table and utilizing Copilot to automatically generate the necessary formula for currency conversion. Perfect for those looking to enhance their Excel skills, this video also tests the Copilot’s efficiency with real data. 

Copilot in Excel: Using Conditional Formatting

In this video, I demonstrate how to use Copilot in Microsoft Excel to seamlessly apply conditional formatting to data involving text, dates, and numbers. I first ensure the worksheet meets the prerequisites for using Copilot by saving it to OneDrive or SharePoint, enabling Autosave, and structuring the data as a table.

Through practical examples, I showcase Copilot's capability to intuitively handle requests such as highlighting certain states in a specific color, marking purchases above a threshold, and changing the font color for recent invoice dates. 

How to Write Excel Formulas with Microsoft Copilot

Get Started with Copilot in Excel - Let me walk you through data setup and Copilot-assisted formulas.

In this video, I demonstrate how to use Copilot in Excel, specifically focusing on setting up data and using formulas. I show how to save data as a table and the necessity to have your data in Microsoft OneDrive or SharePoint for Copilot to function. Then we look at how Copilot can generate formula suggestions and how to add these to your table.

Copilot can interpret your questions to create new formulas and columns.

Recent Articles

Mastering Loan Amortization: A Comprehensive Guide to Understanding and Comparing Loans

Mastering Loan Amortization: A Comprehensive Guide to Understanding and Comparing Loans

Analyzing 50+ Years of Mortgage Rates in Excel: Insights and Trends

Analyzing 50+ Years of Mortgage Rates in Excel: Insights and Trends

Microsoft Word to Adobe Acrobat with Bookmarks

Microsoft Word to Adobe Acrobat with Bookmarks

Dictate Feature Updates in Word, Outlook, PowerPoint, and OneNote

Dictate Feature Updates in Word, Outlook, PowerPoint, and OneNote

Copilot in Teams Control Access: Manage Recordings, Transcriptions & AI Insights

Copilot in Teams Control Access: Manage Recordings, Transcriptions & AI Insights

Teams Calls vs. Meetings: What is the Difference?

Teams Calls vs. Meetings: What is the Difference?

Outlook on the web - 3 Calendar features the desktop version doesn't have

Outlook on the web - 3 Calendar features the desktop version doesn't have

Outlook - Manage your Inbox using Ignore, Archive, Block, Delete, and Clean Up

Outlook - Manage your Inbox using Ignore, Archive, Block, Delete, and Clean Up

Previous ASAP Conferences where Chris Menard has presented

In-Person Conference

Webinars

Beginner’s Guide to Microsoft Copilot - On-Demand | Webpage https://www.asaporg.com/webinars/beginner-s-guide-to-microsoft-copilot

Categories