Latest news

Microsoft Word Level 1 - December 10, 2014 - Gwinnett County

Microsoft Word level 1 in Gwinnett County Georgia. Instructor is Chris Menard. Just some of the topics include: spell check, changing margins, setting paragraph formatting, autocorrect, print preview. Read more

Excel 2010/2013 - Basic Training - Atlanta and Gwinnett - Georgia

Microsoft Excel 2010 training on December 11, 2014 in Lawrenceville Georgia. Just some of the topics covered in this Excel traing class include:creating functions, creating a new workbook, renaming worksheets, moving worksheets, adjusting column width and row height. Read more

Kids II - Excel customized training

In this custom Excel class we learned conditional formatting, tranpose data, countif, countifs, sumif, sumifs, data validation, and pivottables Read more

Windows 7 Training Class - December 4, 2014 - Gwinnett County

Windows training on December 4, 2014 in Lawrenceville Georgia (Gwinnett County). Topics include creating folders, managing files, organizing your desktop, customizing your desktop, working with the taskbar, and many other topics. Read more

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

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