2024 Upcoming Public Speaking Events with Chris Menard
Posted on: 04/26/2024
2024 Speaking Events with Chris Menard
2024 Southeastern Accounting Show (SEAS) and Administrative Professionals Conference (APC)
|
Date |
Time |
Event |
Location |
Session Title |
|
Aug 22, 2024 |
12:10 pm ET |
Southeastern Accounting Show (SEAS)
Host: The Georgia Society of CPAs (GSCPA) |
Atlanta, GA
Cobb-Marietta Coliseum & Exhibit
|
Data Analysis In Excel |
|
Aug 22, 2024 |
2:05 pm ET |
Southeastern Accounting Show (SEAS)
Host: The Georgia Society of CPAs (GSCPA) |
Atlanta, GA
Cobb-Marietta Coliseum & Exhibi |
Copilot in M365 |
|
Oct 28, 2024 |
10:45 am MT |
Administrative Professionals Conference 2024
Host: American Society of Administrative Professionals (ASAP) |
Aurora, CO
Gaylord Rockies Resort |
Excel Copilot: Data Analysis Simplified |
|
Oct 29, 2024 |
10:00 am MT |
Administrative Professionals Conference 2024
Host: American Society of Administrative Professionals (ASAP) |
Aurora, CO
Gaylord Rockies Resort |
M365 Copilot: Revolutionizing Productivity Across Apps |
Popular Excel Articles
-
Excel - Getting Started with Autofill - MUST KNOW FEATURE
Using AutoFill in Excel is one of Excel's most used features. To be proficient in Excel, you need to master AutoFill. In this video, we will look at using Autofill with Series, Columns, Number Patterns, Dates, and Text.
-
Excel Charts - three methods for filtering Chart Data
Filtering data in Excel charts is easy to do. The method you use should be based on the amount of data you have. In this video, I show three methods of filtering chart data. Method 1 is using Chart Filters. This is the easiest method.
Links to Sessions
Excel Copilot: Data Analysis Simplified
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.
Excel Copilot - Sample video 1 - How to Write Formulas with Microsoft Copilot
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.
Excel Copilot - Sample video 2 - Conditional Formatting with Copilot in Excel
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.
Copilot is a great addition to all Microsoft 365 products, but in Excel it's amazing at understanding prompts and taking action.
M365 Copilot: Revolutionizing Productivity Across Apps
Webpage https://www.apcevent.com/session/m365-copilot-revolutionizing-productivity-across-apps/
Embrace the future of work with M365 Copilot, your intelligent assistant that seamlessly integrates across the Microsoft 365 suite. Copilot revolutionizes productivity by providing real-time, AI-powered assistance in apps like Word, Excel, PowerPoint, Outlook, and Teams.
With Copilot, you can:
-
Generate content quickly in Word, crafting documents with ease.
-
Design presentations in PowerPoint with creative and impactful visuals.
-
Manage emails efficiently in Outlook, using smart replies and organization.
-
Collaborate effectively in Teams with instant meeting notes, recaps, and summaries.
M365 Copilot - Sample video 1 - Copilot in Word: Refine your Word Docs
M365 Copilot - Sample video 2 - Copilot in Word: Can Copilot Create a Business Plan?
In this video, I take you through the process of using Microsoft Copilot for M365 to craft a business plan within Word. Starting with an outline of the business idea - a computer repair shop - I demonstrate the detailed steps required to prompt Copilot for a tailor-made business plan. I highlight the necessity of providing specific and comprehensive information to guide Copilot's output.
I point out how Copilot enriches the document with additional insights and useful data representations, such as financial tables. This video illustrates Copilot's capability to serve as a robust foundation for a business plan, allowing for further personalization.
Data Analysis In Excel
Sample Data Analysis Videos
I demonstrate multiple ways to remove duplicates using Excel. We start with a simple list of customer numbers and use Conditional Formatting to highlight duplicate values. Next, I will show how to use the UNIQUE function to list unique values, followed by the method of actually removing duplicates with Excel's built-in feature. For a more complex scenario, I use the CONCATENATE function and helper columns to manage duplicate customer names and numbers, including using COUNTIF for advanced duplicate detection.
YouTube Video - 5 Methods for Calculating Running Totals in Excel
Chris Menard
Chris Menard is a Microsoft Trainer (MCT) and works as a full-time Trainer at BakerHostetler - one of the largest law firms in the US. Chris runs a YouTube channel with 900+ technology videos that cover various tools such as Excel, Word, Zoom, Teams, Gmail, Copilot, Google Calendar, and Outlook. To date, the channel has helped over 20 million viewers.
Menard also does 2 to 3 public speaking events yearly, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the University of Georgia, and CPA conferences. You can connect with him on LinkedIn at https://chrismenardtraining.com/linkedin or watch his videos on YouTube at https://chrismenardtraining.com/youtube.
Categories