Sep 28, 2024 - Excel Training for Executive MBA Students at the University of Georgia

Posted on:  04/27/2024 Sep 28, 2024 - Excel Training for Executive MBA Students at the University of Georgia

On September 28, 2024, I will be honored to speak to the Executive MBA students at the Terry College of Business from the University of Georgia about the essential Excel skills for financial and data analysis.

Excel is a powerful tool for data manipulation, calculation, visualization, and reporting. In this presentation, I will demonstrate how to use some of its most useful features, such as Pivot Tables, sorting and filtering, and functions.

The EMBA students will learn how to create and customize Pivot Tables to summarize and analyze large datasets, sort and filter data to find the necessary information and use Excel functions to perform common financial calculations such as NPV, IRR, and PMT. We will also perform vertical and horizontal analysis on income statements and balance sheets.

Popular Excel Articles

  • Excel - Getting Started with Autofill - MUST KNOW FEATURE

    Using AutoFill in Excel is one of Excel's most used features. To be proficient in Excel, you need to master AutoFill. In this video, we will look at using Autofill with Series, Columns, Number Patterns, Dates, and Text.

  • Excel: Combining Unique and Sort functions

    The UNIQUE function in Excel is one of my favorite functions. Unique returns a list of unique values in a range. The SORT function in Excel sorts the contents of a range or array.

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
  • Conditional Formatting
  • Latest Excel features for M365
  • Newest Excel functions
  • Advanced Filters
  • Advanced Sorting
  • PivotTables
  • Income Statement Analysis
  • Balance Sheet Analysis
  • NEW this year - Copilot in Excel

Recent Articles

Excel Training for the University of Georgia's Online and Professional MBA Students

Excel Training for the University of Georgia's Online and Professional MBA Students

Saturday, April 5, 2025: I'll train the University of Georgia's online and professional MBA students in Microsoft Excel. Topics include PivotTables, Filtering, and even Financial Statement analysis.

Copilot in Excel - Ask Copilot Questions about Keyboard Shortcuts, Functions, and Steps

Copilot in Excel - Ask Copilot Questions about Keyboard Shortcuts, Functions, and Steps

Copilot in Excel can be asked for intermediate keyboard shortcuts, how-to steps, and function explanations.

Chris Menard

Chris Menard is a Microsoft Certified Trainer (MCT) and Microsoft Most Valuable Professional (MVP). Chris works as a Senior Trainer at BakerHostetler - one of the largest law firms in the US. Chris runs a YouTube channel featuring over 900 technology videos that cover various apps, including Excel, Word, PowerPoint, Zoom, Teams, Coilot, and Outlook. To date, the channel has had over 25 million views. Menard also participates in 2 to 3 public speaking events annually, 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