Latest news

Menard to Speak at Administrative Profession Day at UGA in Athens

Chris Menard will present at UGA's annual Administrive Professional Day on Wednesday, April 23, 2014. Menard's presentation is "Excel Beyond The Basics". Menard has been presenting at UGA's conference since 2010. He also trains the Executive MBA students in Atlanta. Read more

Word level 2 - Lawrenceville and Duluth on April 25, 2014

Microsoft Word level 2 (Intermediate) at Gwinnett Medical Center on April 25, 2014. Topics include: Odd and even headers and footers, Tables, Working with Images, and a lot more Read more

Windows Training - May 1, 2014 Windows Training - May 1, 2014

Windows Training on May 1, 2014. Covered in this Windows training class will be File Management, customizing the desktop, creating folders, using the internet. Also covered will be advanced Google searches. Read more

Microsoft Word level 1 - June 5, 2014 - Gwinnett County

Microsoft Word level 1 training in Gwinnett County. Microsoft Office Master Instructor will train employees of Gwinnett Medical Center in MS Office Word level 1 on February 25, 2014 Read more

Chris Menard creates free training video on inserting file name and path in MS Word document for Smith, Welch, Webb & White

Free instructions and short video created for Smith, Welch, Webb & White on how to add the file name and path to a Microsoft Word document. Read more

Contact us

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

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




Steps:
  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?

Steps:

  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 chris@trialityonline.com with your question.  

My Google+ Profile