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.
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.
Categories