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, 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.

 

Import CSV into Google Calendar: 7 Troubleshooting Tips

Import CSV into Google Calendar: 7 Troubleshooting Tips

If you have trouble importing events from CSV into Google Calendar, some of these tips might help troubleshoot what's wrong with your file.

Mail Merge: How to change default sending account in Outlook

Mail Merge: How to change default sending account in Outlook

Learn how to change the default email account used for sending mail merges in Outlook.

Outlook - 7 Calendar Tips Every User Should Know

Outlook - 7 Calendar Tips Every User Should Know

We spend a lot of time in our Outlook calendar. With these calendar tips and tricks, you'll learn how to use your calendar efficiently. I'll demonstrate to you how I use my Outlook desktop calendar to be more productive.

Excel - Find & Highlight Duplicate Rows - 3 Methods | Conditional Formatting

Excel - Find & Highlight Duplicate Rows - 3 Methods | Conditional Formatting

Microsoft Excel can find duplicates easily with Conditional Formatting. The issue is Conditional Formatting finds duplicates based on the cell value, but I want to find duplicate rows. I use three methods in the video to find duplicate rows. I start off with CONCATENATE, then use the TEXTJOIN function, and finally COUNTIFS with no helper column. To highlight the rows I use Conditional Formatting using a formula.

Teams - Why can't I record? Video call vs. meeting

Teams - Why can't I record? Video call vs. meeting

Microsoft Teams allows you to easily record meetings. I'm frequently asked, "Why can't I record?" or "Why is recording disabled?" The answer is that you are doing a video call. Most likely, you were chatting with one person (1-on-1 chat) or doing a group chat. A video call looks similar to a meeting, but it is a call, so the recording feature is disabled.

Three Great OneDrive Tips and Features You Might Not be Using

Three Great OneDrive Tips and Features You Might Not be Using

OneDrive has great features but here are three you might love - time savers, life savers, convenient and more!

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.