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 13, 2024 - 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

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.

Copilot for Excel: Transforming Complex Data with Advanced Delimiter Separation

Discover how Microsoft 365 Copilot revolutionizes Excel data management by automating complex tasks like delimiter separation. Explore the benefits and a step-by-step guide in our latest blog post.

Easily Combine Ranges with VSTACK and HSTACK in Excel

VSTACK and HSTACK are two great functions in Excel. We will use them to combine ranges.

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

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.

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.

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.