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.

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.

 

Today Function in Excel

Today Function in Excel

The TODAY function is a date/time function that shows the current date based on your computer time. The TODAY function will update automatically.

Teams Channel Calendar now available - New Feature

Teams Channel Calendar now available - New Feature

Channels in Teams can have their own calendar. This is a great new feature that allows Teams members to quickly see upcoming channel meetings all in one place.

OneNote - Copy text from picture - 2 reasons to use this awesome feature

OneNote - Copy text from picture - 2 reasons to use this awesome feature

Microsoft OneNote allows you to copy the text from a picture or image. OneNote supports Optical Character Recognition (OCR), which allows you to copy text from an image or picture and paste it on your notes or another application, like Word or Outlook, so you can edit the text. Another incredible feature on OneNote and OCR is the text in the picture is searchable!

OneDrive Personal Vault brings added security

OneDrive Personal Vault brings added security

OneDrive personal vault

Three tips for getting started with Excel Charts

Three tips for getting started with Excel Charts

Charts in Microsoft Excel are easy. This short video shows three tips for creating charts. I'll cover two keyboard shortcuts for making charts, using Recommend Charts, and creating charts using Quick Analysis.

Tax Brackets Explained using Excel's XLOOKUP function

Tax Brackets Explained using Excel's XLOOKUP function

Tax brackets show you the tax rate you will pay on each portion of your income. There are seven tax brackets. The United States has a progressive tax system based on your Taxable income, not Gross income or Net Income. Your income is taxed at different rates with a progressive tax system.

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.