July 15, 2023 - Excel training for Professional MBA students
Posted on: 01/14/2023
Chris Menard is presenting virtually for the University of Georgia Terry College of Business on July 15, 2023. The presentation will be hands-on training for Professional 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
-
Scenarios
-
Auditing features
-
Latest Excel features for M365
-
Newest Excel functions
-
Advanced Filters
-
Advanced Sorting
-
PivotTables
-
Income Statement Analysis
-
Balance Sheet Analysis
Event details:
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.

The University of Georgia - Terry College of Business
About the Professional MBA Program at UGA
Through the Georgia Professional MBA, earn your MBA in 17, 20, or 23 months part-time through evening or Saturday classes and online learning. With classes held in Atlanta at the Terry Executive Education Center, you will build meaningful relationships with individuals from a vast array of backgrounds and experiences.
Website https://www.terry.uga.edu/mba/professional
The Terry College of Business offers four different MBA programs to fit your career goals and schedule.
-
Full-time MBA
-
Executive MBA
-
Professional MBA
-
Online MBA
Website to compare the MBA programs
Recent Word Articles
Recent Excel 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.
Online Microsoft Teams Training with Chris Menard
50% off coupon
Just some of the topics covered
-
Navigation Teams
-
Using private Chat
-
Using group Chat
-
Teams Meetings
-
Scheduling Meetings
-
Meeting controls
-
Roles in a meeting
-
Sharing resources
-
PowerPoint in a meeting
-
Scheduling Team meetings from Outlook
-
Working with Teams and Channels
-
Conversations
-
Files
-
Wiki and OneNote
-
Using Outlook and Teams
-
Using apps in Teams
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
Categories