2024 Upcoming Public Speaking Events with Chris Menard

Posted on:  04/26/2024
2024 Upcoming Public Speaking Events with Chris Menard

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

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 certified Microsoft Trainer (MCT) and works as a full-time Trainer at BakerHostetler - one of the largest law firms in the US. He runs a YouTube channel with 900+ technology videos that cover various tools such as Excel, Word, Zoom, Teams, Gmail, Google Calendar, and Outlook. To date, the channel has helped over 20 million viewers. Menard also does 2 to 3 public speaking events every year, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the Support Staff 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