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

Posted on: 04/29/2024

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

Session and Conference Details

Session Title: Excel Copilot: Data Analysis Simplified
Time: 10:45 AM - 12:15 PM MT
Format: in-person and hands-on
Conference: Administrative Professionals Conference (APC)
APC Webpage: https://www.apcevent.com/session/excel-copilot-data-analysis-simplified/
Speaker page: https://www.apcevent.com/speaker/chris-menard-2/
Resort: Gaylord Rockies Resort & Convention Center

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 Excel Slicers: A Comprehensive Guide

Excel slicers are powerful tools that enhance data filtering in Microsoft Excel, making it easier to visualize and analyze your data. In this blog, we will explore how to create and effectively use slicers, as well as their advantages and limitations in comparison to traditional filters.

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

In today's ever-changing financial landscape, understanding loan amortization is crucial for anyone considering a major purchase, particularly a home. With recent changes in interest rates, it's more important than ever to grasp how loan amortization works and how to compare different loan options.

Microsoft Word to Adobe Acrobat with Bookmarks

We don't usually want to email, or share are Word files. Frequently, we make our Word documents PDF files. If you lay out your Word document correctly, it is easy to make bookmarks in the PDF.

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

Dictate in Word, Outlook, OneNote, and PowerPoint allows users to use speech-to-text to author content in files.

Exploring the New Chat & Channels Experience in Microsoft Teams

Explore the new integrated chat and channels experience in Microsoft Teams. Learn how to navigate the updated interface and maximize your productivity.

Navigating the New Microsoft Teams Refreshed View: A Comprehensive Guide

Microsoft Teams has introduced an exciting new feature in October 2024 called the "Refreshed View of all your Teams and Channels page." This centralized hub is designed to help users manage their teams and channels more efficiently. In this comprehensive guide, we'll explore how to access and utilize this new feature, including its filtering options, sorting capabilities, and search functionality.

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

Outlook on the web has many features that Outlook desktop doesn't have. I'll cover three calendar features that Outlook on the web has that Outlook desktop doesn't provide.

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

Your inbox in Microsoft Outlook can become overwhelming to manage. The average office worker receives around 121 emails every workday. Microsoft Outlook has some easy commands located on the Home tab to help manage your inbox.

Previous ASAP Conferences where Chris Menard has presented

In-Person Conference

September 13, 2022 - Microsoft 365 - New and Upcoming Features - Administrative Professionals Conference - Disney's Coronado Springs Resort in Orlando, FL | Webpage: https://chrismenardtraining.com/post/september-13-2022-microsoft-365-new-and-upcoming-features-administrative-professionals-conference
September 14, 2022 - The Best Overlooked Zoom Features - Administrative Professionals Conference | Webpage https://chrismenardtraining.com/post/september-14-2022-the-best-overlooked-zoom-features
April 19-21, 2023 - Mastering Microsoft One Drive - EA Ignite Conference at Marriott Waterfront in Baltimore MD | Webpage https://chrismenardtraining.com/post/april-19-21-2023-ea-ignite-conference-at-marriott-waterfront-in-baltimore-md
November 6-8, 2023 - Microsoft Teams 2.0: What’s New and What it Means for You - EA Ignite Conference in Austin, TX | Webpage https://chrismenardtraining.com/post/november-2023-ea-ignite-conference-in-austin-tx

Webinars

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