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)

Excel 7 Easy Tips Everyone Should Know

Excel is a powerful tool that can significantly enhance productivity when used effectively. Here, we present seven time-saving Excel tips that will help you work more efficiently.

Copilot In Excel: NEW Feature Enables Copilot Use Without a Table

Copilot in Excel has introduced some exciting new features that are designed to enhance your productivity. Copilot in Excel handles sorting, conditional formatting, pivottables, and asking questions. You can now do this without having a Table.

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.

Analyzing 50+ Years of Mortgage Rates in Excel: Insights and Trends

Understanding mortgage rates is crucial for anyone looking to buy a home or refinance their existing mortgage. In this comprehensive analysis, we'll dive deep into over 50 years of mortgage rate data using Microsoft Excel. We'll explore historical trends, calculate key statistics, and examine how changes in interest rates impact monthly payments.

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.