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 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.

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

Understanding mortgage rates is crucial for anyone looking to buy a home or refinance their existing mortgage. In this comprehensive analysis, we'll dive deep into over 50 years of mortgage rate data using Microsoft Excel. We'll explore historical trends, calculate key statistics, and examine how changes in interest rates impact monthly payments.

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.

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

If you're a Microsoft Teams user with Copilot, exciting new features have been rolled out. You can now manage who has access to meeting recordings, transcriptions, and AI-generated insights as the meeting organizer. This enhances security and privacy in your Teams meetings.

Teams Calls vs. Meetings: What is the Difference?

Understanding the distinction between a Teams call and a Teams meeting is crucial for effective communication within an organization. Both have unique features and functionalities that cater to different needs. Let’s dive into the specifics of Teams calls and meetings.

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