Chris Menard

Hello, I'm Chris Menard,
the First Microsoft Certified Application Specialist Instructor.

I provide professional training on
Microsoft 

Get top Microsoft Office training in your inbox

Join my email list where I send the latest blog posts, training articles, video tutorials and exclusive resources you can really use.

Upcoming training events with Chris Menard
UGAC logo
AUGUST

Excel for the Executive or Professional MBA

At the University of Georgia

Training sessions with Chris Menard

I will be conducting Excel Beginners, Intermediate and Advanced training sessions for the Executive or Professional MBA students from University of Georgia Terry College of Business in Atlanta.

Details about the 2021 sessions, downloadables and resources are available here:
Click here for topics covered

Date Session
Sat, Jul 17 Excel Training - PMBA
Sat, Aug 7 Excel Training - EMBA
Sat, Aug 14 Excel Training - PMBA
Sat, Aug 28 Excel Training - EMBA
Sat, Sep 18 Excel Training - PMBA

Take advantage of great Microsoft Office training!

Free training articles

Office Training Blog posts

I regularly post new articles, tutorials, how-tos on Microsoft Office programs but also Windows, Google, the web and more.

Read my blog

 

Free training videos

Training

I have hundreds of training videos and quick walkthroughs. Learn things you never thought you could do yourself!

 

Chris' Excel Course

Microsoft Excel Course

Learn Excel the right way, at your own leisure, with Chris Menard. I'll hold your hand through 7 units of intermediate Excel.

Take course

 

Office 365 Insider

Office 365 Insider Program

Be first to know what new features come out for Office 365! I test and send them exclusively to insiders weeks in advance!

Become an insider!

Here are some of the corporate clients I've trained since 1997:

Coca-Cola Atlanta
Clayton County Water Authority
Georgia Pacific
Georgia Society of CPAs
Gwinnett Medical Center
Mizuno USA
Ronald Blue Trust
University of Georgia

Bonnie P Matthews

"As a nurse moving into the education area, I needed to learn how to create PowerPoint presentations quickly and creatively and manage a variety of spreadsheets. I had the pleasure of attending several of Chris’ training classes.

He was very thorough and efficient, while keeping the class interesting with his energetic personality. He used scenarios that were relatable and we practiced in class for real-time learning. I walked away from his courses more proficient and ready to create education on my own.

I highly recommend Chris for your education and training needs."

– Bonnie P. Matthews

Watch hundreds of Office training videos on my YouTube channel

Make sure to visit and subscribe to be notified when I've uploaded new content.

Visit my channel

Latest blog posts, articles, tutorials and videos

I frequently post new videos, how-tos, tutorials and blog posts on how to use various functions in Microsoft Office applications. Make sure to visit often or subscribe to receive an update every time there's something new.

 

Excel file size out of control? Learn how to reduce Excel spreadsheet file size

Excel file size out of control? Learn how to reduce Excel spreadsheet file size

Sometimes Excel spreadsheet file size can get out of control, for no reason, despite not having a lot of data. Find out what to do to reduce the size again.

Teams: Live transcription in Teams meeting - 2021 New Feature!

Teams: Live transcription in Teams meeting - 2021 New Feature!

Teams Meetings now has live transcription! Live transcription is a written record of the spoken text that occurs during a meeting. It identifies each speaker, is captured automatically in near real-time, and is available during and after the meeting. Live transcription is different from the meeting feature Live captions. Captions are not recorded. You could use Live transcription if you joined a meeting late and you need to quickly catch up on what is happening.

Margin of Safety vs. Break-even point in Excel

Margin of Safety vs. Break-even point in Excel

Break-even point (BEP) is the level of sales where the total cost - fixed cost and variable cost - equals total revenues. Break-even is where Net Income is zero. There is no profit and no loss. The Margin of Safety (MoS) is a difference between actual/budgeted sales and the level of breakeven sales.

Excel MONTH Function - extract the month from a date | Excel One-Minute Quick Reference

Excel MONTH Function - extract the month from a date | Excel One-Minute Quick Reference

The MONTH function in Excel allows you to extract the month from the date. In this video, I show you how the month function works in Excel, the formula to use, reference the fields, formatting it so that you only see the month and nothing else.

Excel LARGE function | Find the second, third, n-th largest value | Excel One-Minute Quick Reference

Excel LARGE function | Find the second, third, n-th largest value | Excel One-Minute Quick Reference

The LARGE function in Excel returns the k-th largest value in a data set. For example, you can use LARGE to return the customer with the highest revenue, 2nd highest revenue, third-highest revenue, and so on.

Top 18 Keyboard Shortcuts for Google Chrome You Need to Use

Top 18 Keyboard Shortcuts for Google Chrome You Need to Use

Are you using these top keyboard shortcuts for Google Chrome? Save time and be more efficient by learning and getting used to these.

View more on the BLOG

Previous training events with Chris Menard

I've published my past events here so you can benefit from the resources. Many of them still have the recording available.

Excel: Advanced Functions for PMBA Students
September 2020

Functions covered: IF, AND, VLOOKUP, SUMIFS, MAXIFS, XLOOKUP (O365), New Dynamic Array Functions (O365)

Excel: Getting Started with Financial Statements
September 2020

We ran through several financial transactions using T accounts in Excel. We discussed debits and credits. Then created an Income Statement and Balance Sheet. Finally, we examined an income statement.

ZOOM Staff Training for UGA
June 2020

Topics covered: Host controls, Participants controls, Secure your Zoom meeting with a waiting room, Secure your Zoom meeting with a password, How to lock a meeting, Lockdown sharing controls, Lockdown annotation, Use a virtual background, How and when to use a co-host, Polling during a Zoom meeting, Set up recurring Zoom meeting.

Zoom Resources Page
Live speaking event on ZOOM: DeKalb Chapter of CPAS
June 2020

Zoom topics covered: Customizing the Waiting Room, Creating Polls, Screen sharing tips, Using virtual backgrounds in Zoom, Keyboard shortcuts.

Details and videos
Live speaking event: DeKalb Chapter of CPAS
February 2020

Excel topics covered: PivotTables, Importing data from the web, Geography and Stock Data Type, Unpivot Columns using Get & Transform, Using Tables

Details and videos
Performing Financial Ratios
January 2020

In this webinar, recorded on January 28, 2020, for the Executive MBA students for the University of Georgia Terry College of Business, we will look at financial ratios for the balance sheet, ratios for the income statement, and finally ratios that use both the income statement and balance sheet.

Details and view recording
Analyzing Financial Statements
January 2020

We analyze the Income Statements using vertical and horizontal analysis. We start off this webinar by using T Accounts to record transactions and then create an Income Statement and Balance Sheet.

Details and view recording
Business and Industry Conf.
November 2019

Training sessions with Chris Menard, hosted by The Georgia Society of CPAs (GSCPAs)

Excel Deep Dive Session Excel Tips to Set You Apart from the Pack
Essential Excel functions
December 2018

The University of Georgia Terry College of Business Executive MBA webinar.

Details and recording
Executive MBA Webinar 2
January 2018

Covers 10 reasons to use Tables instead of ranges in Excel. It covers PivotTable options for resizing columns and saving your source data. PivotTables portion of the video includes deleting your data source and still being able to manipulate your PivotTables. Plus, it shows how to have multiple subtotals inside a PivotTable.

Details and recording
Executive MBA webinar 1
September 2017

Follow up to my live Excel training for the EMBA students on September 23, 2017 in Atlanta, Georgia at the Terry College of Business. I have been training the EMBA students since 2010.

Details and recording

Microsoft Certified Application Specialist Instructor is the highest level of certification possible for the world's leading desktop software - Microsoft Office. View more about me and see my certifications here.