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

Excel - Combine the SORT, UNIQUE, and COUNT functions

Excel has dynamic array functions. Two of the dynamic array function are SORT and UNIQUE. I will combine SORT and UNIQUE and also combine them with COUNT and the COUNTA functions. This came from a user that asked how many unique zip codes were in a spreadsheet.

Excel Import Data from the Web

Excel allows you to pull data on a webpage into Excel. This is a great time-saving feature. Getting data from a webpage is done in Excel on the Data Tab using Get and Transform Data group, From Web command.

Excel Sorting Tips with Chris Menard on January 24, 2023

Chris Menard will be live on YouTube and Linked showing Sorting Tips in Excel on January 24, 2023.

Excel - Convert Seconds to Minutes and Seconds - Watch Chris Work!

Frequently we have data in one format but need to convert it to another. Today's example is I have a column on seconds for the length of videos. I want to show minutes and seconds with a colon in between the minutes and seconds.

Teams Video Call or Meeting - Toggle View - Teams Tip

When you are in a Teams Meeting, or Video call, you can toggle between the shared screen and the presenter. This is a great tip when someone is sharing but then starts a discussion. You want to see the person and not the shared screen.

Teams - How to Manage Files and Folders in a Channel

Microsoft Teams Channels is a great way to communicate and collaborate. I love group chat also, but one HUGE advantage a Team has over a group chat is the ability to manage files and folders.

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.

Outlook Calendar - Meetings vs. Appointments

In Outlook we live in our calendar. We have three different types of calendar items - Meetings, Appointments, and Events. When do you use each?

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.

Word - Five Tips for Working with Heading Styles

Styles in Word are one of the best features in Microsoft Word. In this video, I give five tips for working with Styles.

Chris Menard

Chris Menard is a Microsoft Certified Trainer (MCT) and is employed full-time as a Trainer for BakerHostetler, one of the nation’s largest law firms. Menard has a YouTube channel with over 900 technology videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 15 million viewers have appreciated. Menard also does public speaking at conferences for CPAs and Administrative Professionals. Connect with Chris on LinkedIn at chrismenardtraining.com/linked or on YouTube at chrismenardtraining.com/youtube