Excel Training for UGA's Executive, Online, and Professional MBA Students

A full day of training with Chris Menard

I will lead a full day of training on Microsoft Excel Beginner, Intermediate, and Advanced for the Executive, Online, and Professional MBA students at the University of Georgia Terry College of Business.

Please make sure you register below to receive info about future webinars.

If you encounter any problems, please contact Chris here.

**Chris Menard - Microsoft Certified Trainer**

Sign up to be notified on upcoming webinars with Chris Menard

<fieldset class="fieldset"> <legend>Schedule</legend> <h3> Saturday, September 27, 2025 - MBA Training</h3> <table border="1" cellpadding="1" cellspacing="1" style="width:100%;"> <tbody> <tr> <td style="text-align: center;"> 10:00am – 11:30am</td> <td> <strong>MS Excel: Essentials/Beginner</strong></td> </tr> <tr> <td style="text-align: center;"> 11:30am – 11:45am</td> <td> Break</td> </tr> <tr> <td style="text-align: center;"> 11:45am – 1:15pm</td> <td> <strong>MS Excel: Intermediate 1</strong></td> </tr> <tr> <td style="text-align: center;"> 1:15pm – 2:00pm</td> <td> Lunch</td> </tr> <tr> <td style="text-align: center;"> 2:00pm – 3:30pm</td> <td> <strong>MS Excel: Intermediate 2</strong></td> </tr> <tr> <td style="text-align: center;"> 3:30pm – 3:45pm</td> <td> Break</td> </tr> <tr> <td style="text-align: center;"> 3:45pm – 5:00pm</td> <td> <strong>MS Excel: Advanced</strong></td> </tr> </tbody> </table> <p> See below for details of topics covered in each session.</p> </fieldset> <p>  </p>

Venue

Terry Executive Education Center

The Terry Executive Education Center is Terry College’s “home away from home” in the Buckhead district of Atlanta. Designed and constructed to maximize the educational experience, the 33,000 square foot facility boasts modern conference rooms, a 120-capacity special events space, interview suites, private break-out rooms, and tiered executive classrooms.

Read more about the Terry College of Business MBA Programs

WORKSHOP RESOURCES

Resources and links:

Excel Keyboard Shortcuts for Windows, macOS, Andriod, Web and iOS

https://support.office.com/en-us/article/keyboard-shortcuts-in-excel-for-windows-1798d9d5-842a-42b8-9c99-9b7213f0040f
Online courses by Chris Menard - Teasm, Excel, and Copilot
https://courses.chrismenardtraining.com

Downloadable files (UGA)

UGA Excel keyboard shortcuts (Size: 117.4KB)

PDF version of keyboard shortcuts cheatsheet for Excel

UGA Excel keyboard shortcuts (Word format) (Size: 111.3KB)

Word format downloadable Excel keyboard cheatsheet.

UGA_2022 (Size: 2.3MB)

SPOTLIGHT TOPIC

Analyzing Financial Data with Excel

Vertical Analysis
Horizontal Analysis (aka Trend Analysis)
Cost-Volume Profit Analysis
Breakeven chart
Product Mix

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.

How to Remove Duplicates Running Left to Right in Excel Using Power Query

Removing duplicates in Excel is a common task, but it can be challenging when the duplicates are running horizontally (left to right) instead of vertically. In this blog post, we'll explore an advanced Excel technique using Power Query to efficiently remove duplicates across rows. This method is particularly useful when dealing with complex data structures where traditional duplicate removal methods fall short.

Become an Expert at Using the TOCOL Function in Excel to Merge Columns

The TOCOL function in Excel is a powerful tool for combining data from multiple columns into a single column.

Microsoft Excel 365 Essentials

Getting started

Topic A: Spreadsheet terminology
Topic B: The Excel environment
Topic C: Getting help
Topic D: Navigating a worksheet

Entering and editing data

Topic A: Entering and editing text and values
Topic B: Entering and editing formulas
Topic C: Working with pictures
Topic D: Saving and updating workbooks

Modifying a worksheet

Topic A: Moving and copying data
Topic B: Moving and copying formulas
Topic C: Absolute and relative references
Topic D: Inserting and deleting ranges, rows, and columns

Functions

Topic A: Entering functions
Topic B: AutoSum
Topic C: Other common functions

Formatting

Topic A: Text formatting
Topic B: Row and column formatting
Topic C: Number formatting
Topic D: Conditional formatting
Topic E: Additional formatting options

Printing

Topic A: Preparing to print
Topic B: Page Setup options
Topic C: Printing worksheets

Charts

Topic A: Chart basics
Topic B: Formatting charts

Managing large workbooks

Topic A: Viewing large worksheets
Topic B: Printing large worksheets
Topic C: Working with multiple worksheets

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.

Microsoft Excel 365 Intermediate

Using multiple worksheets and workbooks

Topic A: Using multiple workbooks
Topic B: Linking worksheets with 3-D formulas
Topic C: Linking workbooks
Topic D: Managing workbooks

Advanced formatting

Topic A: Using special number formats
Topic B: Using functions to format text
Topic C: Working with styles
Topic D: Working with themes
Topic E: Other advanced formatting

Outlining and subtotals

Topic A: Outlining and consolidating data
Topic B: Creating subtotals

Cell and range names

Topic A: Creating and using names
Topic B: Managing names

Tables

Topic A: Sorting and filtering data
Topic B: Advanced filtering
Topic C: Working with tables

Web and sharing features

Topic A: Saving workbooks as Web pages
Topic B: Using hyperlinks
Topic C: Sharing workbooks

Advanced charting

Topic A: Chart formatting options
Topic B: Combination charts
Topic C: Graphical elements

Documenting and auditing

Topic A: Auditing features
Topic B: Comments in cells and workbooks
Topic C: Protection
Topic D: Workgroup collaboration

Templates and settings

Topic A: Application settings
Topic B: Built-in templates
Topic C: Creating and managing templates

Microsoft Excel 365 Advanced

Advanced functions

Topic A: Logical functions
Topic B: Math and statistical functions
Topic C: Financial functions
Topic D: Displaying and printing formulas

Lookups and data tables

Topic A: Using lookup functions
Topic B: Using MATCH and INDEX
Topic C: Creating data tables

Advanced data management

Topic A: Validating cell entries
Topic B: Exploring database functions

PivotTables and PivotCharts

Topic A: Working with PivotTables
Topic B: Rearranging PivotTables
Topic C: Formatting PivotTables
Topic D: PivotCharts

Exporting and importing

Topic A: Exporting and importing text files
Topic B: Exporting and importing XML data
Topic C: Querying external databases

Analytical tools

Topic A: Goal Seek and Solver
Topic B: The Analysis ToolPak
Topic C: Scenarios
Topic D: Views

Macros and custom functions

Topic A: Running and recording a macro
Topic B: Working with VBA code
Topic C: Creating functions

Conditional formatting and SmartArt graphics

Topic A: Conditional formatting with graphics
Topic B: SmartArt graphics

Microsoft Word to Adobe Acrobat with Bookmarks

We don't usually want to email, or share are Word files. Frequently, we make our Word documents PDF files. If you lay out your Word document correctly, it is easy to make bookmarks in the PDF.

Dictate Feature Updates in Word, Outlook, PowerPoint, and OneNote

Dictate in Word, Outlook, OneNote, and PowerPoint allows users to use speech-to-text to author content in files.