April 13, 2024 - Excel Training for MBA Students from the University of Georgia

Posted on: 01/21/2024

Excel training for the University of Georgia Professional MBA and Online MBA students .This workshop is hands-on, and will cover topics from Excel Essentials, Intermediate,and Advanced.

About the Terry College of Business

Website: Terry College of Business - University of Georgia (uga.edu)

Established in 1912, the C. Herman and Mary Virginia Terry College of Business has a rich tradition of delivering advanced business education. We provide a highly regarded undergraduate program, various specialized master’s degrees, diverse MBA program formats, and opportunities for doctoral study in eight distinct areas. The rigorous curriculum, outstanding faculty, and strong alumni network collectively contribute to preparing Terry students to emerge as leaders in both their careers and communities.

Just some of the Excel topics covered:

Business functions - Average, Median, Max, Min, Large, Small, Sum, Countif, Countifs, Sumifs, Today, Now, If, Rank, and many other functions.
Filters
Sort - one column, multiple columns, sort by color, sort by fiscal month
Scenarios
Auditing features
Latest Excel features for M365
Newest Excel functions
Advanced Filters
Advanced Sorting
PivotTables
Income Statement Analysis
Balance Sheet Analysis

NEW in 2024 - Using Copilot in Excel

We will look at analyzing data using Copilot in Excel. Copilot blog post.

Here are some of my courses

Recent Excel Videos from Chris Menard - Microsoft Certified Trainer (MCT)

5 Essential Excel Tips Everyone Should Know

Excel is a powerful tool used across various industries, and mastering its features can significantly boost your productivity. In this blog post, we'll explore five essential Excel tips that every user should know.

Excel Focus Cell: Enhancing Active Cell Visibility and Navigation

Microsoft Excel has introduced an exciting new feature called Focus Cell, designed to improve the visibility of the active cell and enhance navigation within spreadsheets. This powerful tool highlights the current cell's row and column, making it easier to track your position in large datasets.

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.

Mastering Loan Amortization: A Comprehensive Guide to Understanding and Comparing Loans

In today's ever-changing financial landscape, understanding loan amortization is crucial for anyone considering a major purchase, particularly a home. With recent changes in interest rates, it's more important than ever to grasp how loan amortization works and how to compare different loan options.

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.