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

Schedule

Saturday, April 5, 2025 - MBA Training

10:00am – 11:30am	MS Excel: Essentials/Beginner
11:30am – 11:45am	Break
11:45am – 1:15pm	MS Excel: Intermediate 1
1:15pm – 2:00pm	Lunch
2:00pm – 3:30pm	MS Excel: Intermediate 2
3:30pm – 3:45pm	Break
3:45pm – 5:00pm	MS Excel: Advanced

See below for details of topics covered in each session.

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

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 can be asked for intermediate keyboard shortcuts, how-to steps, and function explanations.

August 19, 2025 - Southeastern Accounting Show (SEAS) - The CPA's Guide to Excel Data Analysis - Chris Menard

I will be presenting at the Georgia Society of CPAs' Southeastern Accounting Show on August 19, 2025. My first session will be The CPA's Guide to Excel Data Analysis: Turning Numbers into Knowledge

Speed Up Data Entry and Accuracy with Excel Data Validation Lists

In today's fast-paced work environment, efficiency and accuracy in data entry can significantly impact productivity. One of the best tools to achieve this in Excel is the Data Validation List feature. This guide will walk you through the process of setting up and using Data Validation Lists to streamline your data entry tasks in Microsoft Excel.

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.