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
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 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.
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.
Teams: Improved People Search - November 2024
Microsoft Teams has rolled out an enhanced people search feature, providing users with more efficient ways to find and filter content related to specific individuals. This update, released in November 2024, offers a streamlined approach to searching for messages, files, and conversations associated with team members. Let's explore how to make the most of this new functionality.
Follow a Meeting" Feature in Microsoft Outlook
The "Follow a Meeting" option allows users to indicate that they cannot attend a meeting but still want to receive information about it. This feature is particularly useful for staying in the loop on important discussions and decisions without physically being present in the meeting.
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