Latest news

Excel Advanced - Gwinnett County Georgia - November 18, 2014

Chris Menard teaches Microsoft Excel 2010 advanced in Gwinnett on November 18, 2014. Topics include PivotTables, Charts, Data Validation, Advanced Filters, Read more

Microsoft Excel Intermediate - November 14, 2014

Microsoft Excel Intermedite - Gwinnett County - Lawrenceville and Duluth. Covered in this Excel class is 3D reference, filters, sorting, sorting by colors, advanced sorting, advanced printing options, and other topics. Instructor is Microsoft Master Instructor Chris Menard. Chris trains many corporate clients in metro Atlanta. Read more

Gwinnett - Excel Essentials - November 11, 2014

Microsoft Excel 2010 training will be held on November 11, 2014 in Lawrenceville, Georgia. Just some of the topics covered include functions, printing, conditional formatting, and working with the Excel environment. Class is open for Duluth - Lawrenceville GA employees of Gwinnett Medical Center Read more

Microsoft Word Advanced - October 29, 2014

This course builds on the skills taught in Word Intermediate. In this advanced course, students will learn how to perform a mail merge, create an index, track document changes, creating, modifying, and protecting forms, and other advanced Word topics. Class is taught by Microsoft Office Master Instructor Chris Menard. Location is Gwinnett County near Atlanta Georgia. Read more

On Tilt For Ta Tas - Charity Poker Tournament - Henry County Georgia - November 1, 2014

Poker Tournament to fight Breast Cancer on November 1, 2014 in Stockbridge, Georgia. Proceeds to go to Local Breast Cancer Research and Treatment Centers in Coweta County, Fayette County and Henry County. Tournament will be held at the Wishing Well in Stockbridge. Read more

Contact us

First and last name:
Your e-mail address:
Your phone number:

Please type the code from the verification image in the box below.

Microsoft Office Training - Atlanta, Georgia

Written By Chris Menard

We provide on-site training in Microsoft Office Excel, Word, PowerPoint, and Outlook.  We train anywhere in the US. Chris Menard is the first Microsoft Office Master Instructor in the world and has been featured on Microsoft's training website. 

View Chris Menard's training credentials.

Just several of Menard's clients include:

  • University of Georgia - Athens and Atlanta
  • Gwinnett Medical Center - Lawrenceville and Duluth GA.  Exclusive MS Office trainer since 2009.
  • Mizuno USA in Norcross - Excel training
  • Ronald Blue in Atlanta - Excel training
  • International Association of Administrative ProfessionalsChris Menard - Microsoft Office Master Instructor (IAAP)
  • Kids II - PowerPoint and Excel training
  • Georgia-Pacific Corporation
  • Coca-Cola - Menard created a 2 hour Excel training video what was used in over 150 countries
  • Georgia Society of CPAs - frequent speaker for GSCPA and most of Menard's Excel classes count for A&A credit.
  • IRS in Atlanta - trained in Excel 2007
  • Smith, Welch, Webb & White - attorneys in metro Atlanta- trained in PowerPoint, Word, and Excel.

Microsoft Word - add the filename and path to the footer of a document

To add the filename and path to a Word document do the following:

  1. After you document is saved, in the footer of the document, click the Insert Tab
  2. Click Quick Parts
  3. Select Field
  4. Change categories to Document information
  5. Select filename
  6. Check add path
  7. Click OK
  8. Go to print preview and view the filename and path
  9. Close print preview

Google Calendar - how do I import appointments and events into my Google Calendar?

A lot of people use Gmail and the Google calendar. Businesses even use Google Apps for their email client and calendar. If you have to add a couple appointments, just add them manually, but if you have to add a lot of appointments to your calendar, you can import a CSV file into your calendar.

In the video below I show specifically how to import appointments into your Google Calendar. If you are like me and use multiple calendars, you can even decide what calendar to import into.

Here is a CSV file to download if you don't want to set up a CSV file from scratch. 
Row 1 in the file is the header information.  Don't change it.  Row 2 is a sample appointment to get you started.  Just type over the sample appointment in row 2. 

Microsoft Excel - filters and subtotal function

When using filters in Excel, the functions average, max, min, and sum will give you the wrong answer since they include the hidden rows. Use the Subtotal function to get the correct answer.

Microsoft Excel - Data Validation based on another data validation list

This short video shows how to create a data validation list in Excel based on another data validation list. You will need to name ranges and use the Indirect function in Excel.

Microsoft Excel - Mixed Reference

Use Mixed Reference in Excel when you need to freeze just a column or row when doing a formula. In the video shown, we are trying to determine gross revenue but we don't know the number of attendees yet or the price to charge for our conference.

The file used in this example can be downloaded here.

Microsoft Excel - combination chart (2 axis chart)

When charting data in Excel with a large variance, you need to use a combination chart with 2 axis.

The file used in this example can be downloaded here.

Microsoft Excel - Conditional Formatting with Functions

Use functions with Conditional Formatting in Excel to highlight entire rows above the average, every other eConditional Formatting Above Averageven row, every other odd row, or every fifth row.

The video demonstrates how to show the entire row above the average. 

The function used is =$F2>=Average($F$2:$F$18)

At the two minute mark, the video show how to make every other row a different background color and how to make a fifth row a different background color.  =mod(row(),2)=0

The file used in this example can be downloaded here.

IRFANVIEW - batch resize images or pictures

Question: I have a lot of pictures I need to email to friends and family to share. Most of the images are over 4 MB. Is there an easy way to quickly resize them all so I can email them out.  My email account has a file attachment maximum of 25MB.  I have over 50 pictures. 

Answer: Yes! IRFANVIEW is a free program for home use. You can use it to batch resize your pictures. This comes in handy for PowerPoint so the presentation does not become to large, for emailing images, and for uploading pictures to Facebook.  In the video below, the original ten pictures are 36 MB.  After resizing, they are 1 MB!

  1. Right click and open an image in IRFANVIEW
  2. Click File | Batch Conversion Rename
  3. Click Add All
  4. Click Advanced and make sure the width is between 600 and 800
  5. Click OK
  6. Click Use Current (look in) directory
  7. At the end of the last backslash type in "smaller" without the quotes.  Example: C:\Users\Triality 1\Desktop\Pictures\smaller
  8. Click Start Batch
  9. Close IRFANVIEW when done

Microsoft PowerPoint - insert a Word Doc into PowerPoint

Question:  I have a Word document that I need to insert into PowerPoint.  Is Copy / Paste the only way to get it in PowerPoint?

Answer:  Use PowerPoint's Slide from Outline feature to get a Word Document into PowerPoint. 

  1. Home Tab
  2. New Slide drop down arrow
  3. Slides from Outline
  4. Find the Word Document
  5. Insert

Make sure you use Heading 1 and Heading 2 styles in MS Word.  Heading 1 becomes the slide title and Heading 2 becomes the first level bullet.  Normal style will not go into PowerPoint.

Microsoft Excel - Add number quickly

Question: is AutoSum and Autofill are fastest excel tools to add numbers and copy formulas?

Answer: usually, but often you have groups of data you want to add that are not part of one data range. In that case this tip is the fastest way to add numbers.  Here is a short two minute video I created for SCB TV on the fastest way to add numbers in Excel.

  1. Select your first range and stop where you want your totals for the months or quarters. 
  2. Hold down CTRL and select the other ranges.  Still stopping where you want your totals. The CTRL key allows you to select non adjacent ranges.
  3. Let go of the CTRL key after selecting the other ranges.
  4. Click AutoSum.
  5. Now select all the ranges including the Grand Totals, Column F and Row 17 in the video below.  Click AutoSum.

Microsoft Word - Odd and Even headers and footers for duplex printing

Question: how do I print double sided with the page numbers on the outside of the pages? 

If you want to print two sided, here is how you create odd and even headers or footers in MS Word. 

Creating odd and even headers and footers are a must in Microsoft Word if you are going to do two-sided printing.  Think about opening any book.  The page numbers are always on the outside of the pages.  Here is a short video I created on how to do 2 sided printing.

Windows 8 Keyboard Shortcuts
  • Here is one page pdf of my favorite windows 8 keyboard shortcuts

Word and Excel keyboard shortcuts and quick guide

Microsoft Excel - 3D reference

Question: How to I create a 3D reference Excel?

Another excel feature that most people do incorrectly.  If you are summing up multiple worksheets that are set up the same except for the numbers, the incorrect way is to do = click the worksheet, click the cell, plus symbol, and click the next worksheet and keep repeating.  This method may give you the correct answer but it is very time consuming and if you add worksheets it will have to be edited. 

Microsoft Excel - How do I fill in empty cells on a worksheet quickly?


  1. Select the first cell that has information to the last empty cell. 
  2. Press F5 on the keyboard
  3. Click Special. Select Blanks. Click OK twice.
  4. In the active cell, reference the cell above or to the right.  Example =C2
  5. Hold down CTRL and press ENTER.
  6. Select all, copy and paste values.

Microsoft Excel - How do I create a data validation list?
This works in all version of MS Excel.  Also shown is how to quickly remove duplicates in Excel.

Word video: How do I create a Table of Contents in Word with two columns?
This short video shows you how to use section break next page and section break continuous to make a 2 column table of contents in Microsoft Word

About Chris Menard
Chris Menard is a Microsoft Office Master Instructor.  Microsoft in Alpharetta calls on Menard to train some of their largest clients including Coca-Cola and Georgia-Pacific Corp.   Menard recently presented to over 220 Administrative Professionals in Atlanta at the IAAP annual meeting.

In 2010, Menard created an Excel 2007 video for the Coca-Cola Company that was distributed to over 150 countries. Chris Menard has a BBA in Accounting and is a frequent speaker for the Georgia Society of CPAs.

Have a technology question for Chris Menard? 
Email him at with your question.  

My Google+ Profile