October 7, 2022 - Excel training for Executive MBA students

Posted on: 09/28/2022

Chris Menard is presenting virtually for the University of Georgia Terry College of Business on October 7, 2022. The presentation will be hands-on training for Executive MBA (EMBA) students. A full day of Excel training.

Just some of the topics covered:

Business functions - Average, Median, Max, Min, Large, Small, Sum, Countif, Countifs, Sumifs, Today, Now, If, Rank, and many other functions.
Filters
Sort
Latest Excel features for M365
Newest Excel functions
Advanced Filters
Advanced Sorting
PivotTables
Income Statement Analysis
Balance Sheet Analysis

Event details:

When: Friday, October 7, 2022
Location: Zoom - online meeting for the University of Georgia - Terry College of Business, Atlanta, GA

Sessions with Chris Menard:

Excel Essential 9:00 am to 10:30 am
Break: 10:30 am to 10:45 am
Excel Intermediate part 1: 10:45 am to 12:15 pm
Lunch: 12:15 pm to 1:00 pm
Excel Intermediate part 2: 1:00 pm to 2:30 pm
Break: 2:30 pm to 2:45 pm
Excel Advanced: 2:45 pm to 4:00 pm.

Latest articles

Speed Up Data Entry and Accuracy with Excel Data Validation Lists

In today's fast-paced work environment, efficiency and accuracy in data entry can significantly impact productivity. One of the best tools to achieve this in Excel is the Data Validation List feature. This guide will walk you through the process of setting up and using Data Validation Lists to streamline your data entry tasks in Microsoft Excel.

How to Remove Duplicates Running Left to Right in Excel Using Power Query

Removing duplicates in Excel is a common task, but it can be challenging when the duplicates are running horizontally (left to right) instead of vertically. In this blog post, we'll explore an advanced Excel technique using Power Query to efficiently remove duplicates across rows. This method is particularly useful when dealing with complex data structures where traditional duplicate removal methods fall short.

Copilot in Excel - Ask Copilot Questions about Keyboard Shortcuts, Functions, and Steps

Copilot in Excel can be asked for intermediate keyboard shortcuts, how-to steps, and function explanations.

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.

Blog Posts Week Starting February 17, 2025 - Snagit 2025, Teams NEW Feature, and Live Stream on Microsoft Copilot in Excel

February 16, 2025 - Next week, two videos and one Live Stream. Discover the power of Snagit 2025's new Step Capture feature! Stay organized and on top of your schedule with the new Calendar feature in Teams! Live stream on Friday, Feb 21, covering Copilot In Excel.

4 Great NEW Microsoft Teams Features: November & December 2024

Microsoft has been extremely busy with new Teams features in November and December 2024. Here is a quick overview of What's New - Name Pronunciation, New Chat and Channels Experience, Improved People Search, and the Refreshed View for Teams and Channels.

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.

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.

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.

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.