March 15, 2018 – Recording on YouTube of the live webinar hosted on Microsoft Excel’s Insights. Insights in Excel is a game changer for data analysis. Another webinar on Insights will be held in April 2018.
If you see data in Wikipedia and you need to pull it into Microsoft Excel, don’t copy and paste. Use Get Data feature in Excel to query the data from the website.
Microsoft Office Training with Chris Menard
Looking for training in Excel, Word, PowerPoint, or Outlook Atlanta? You have come to the right place. Welcome to my website. I provide onsite Microsoft Office 365 to clients in metro Atlanta and anywhere in the US. I provide two types of training. One is hands-on, instructor-led training, at your location. The other training I provide is online training that is available 24-7. Most of my clients are located in Atlanta and include Gwinnett Medical Center, Coca-Cola, Mizuno USA, the University of Georgia, the Georgia Society of CPAs, Clayton County Water Authority, and many others.
Insights in Excel: game-changing new Excel feature
View the latest YouTube video on Insights in Excel with Chris Menard.
When I’m not training in Microsoft Office, I create free technology video for my YouTube. Currently, I have over 300 videos that cover Excel, Word, PowerPoint, Gmail, Google Calendar, Outlook, OneDrive, and many other software programs. Most of the videos originated from questions asked during one of my instructor-led training classes.
Feel free to contact me or view some of my YouTube videos. The table of contents from my Excel, Word, PowerPoint, and Outlook classes are found on their respective links. Thank you for visiting my site.
Chris Menard – Software Trainer / Microsoft Office Master Instructor / Instructional Designer
Chris Menard has been featured on Microsoft’s training website, the Atlanta Journal twice, Yahoo business news, and Certiport’s website. His clients include Coca-Cola in Atlanta, Georgia-Pacific LLC, the University of Georgia’s Executive MBA students, Ronald Blue Trust, Delta Air Lines, Kids II, Gwinnett Medical Center, and many other clients in metro Atlanta.
April 20, 2018 – Excel & Word Tips to Make Your Life Easier!
Join Chris Menard at the 2018 Administrative Professional Day Conference in Athens, Georgia. Menard’s sessions will be instructor-led and hands-on. Everyone attending will be using a desktop computer. Just some of the topics covered include using slicers in your data, advanced PivotTables, changing crosstab data in Excel to a flat file, using advanced paragraph and charter styles in MS Word, and working with advanced Index settings in Word.
Over 240 attendees came together for the 2017 event to network and push their professional skills forward. This event is sponsored by The University of Georgia Center for Continuing Education. The Center for Continuing Education celebrates the office professionals who make offices work. Come join us for a day of exceptional professional development activities!
Microsoft Sway – Free Webinar on 2/28/2018
February 28, 2018 – Sway webinar will be held on 2/28/2018 at 2 PM ET. Click here to view more about Sway and register for the free webinar.
Sway is a great way to create and share interactive reports, presentations, personal stories, and more. Sway is FREE!!! It is also web-based, so there is nothing to download. Here is a recent Sway I created for Oakland Cemetery in Atlanta, GA. https://sway.com/BdpEBfJqRPto5ZKh
If you already have a free Microsoft account, you can start using Sway immediately. Some people don’t realize they already have a Microsoft account. If you have Hotmail or Outlook.com, you have a Microsoft account. If you don’t have a Microsoft account, you can sign up for one here.
Online Excel Training with Chris Menard
Online Excel Training – Chris Menard’s Excel Intermediate class is now available online. Company and group discounts are available. After publishing over 300 YouTube videos, and hearing from multiple instructor-led clients that he needs to make his courses available online, Chris finally did it. Excel is currently available online. By the end of August, all his courses – Word, PowerPoint, and Outlook – will be online. Menard still provides instructor-led training to clients in metro Atlanta. All the online courses have student files so you can follow along. All the videos also have closed captioning for the hearing impaired. Menard still provides instructor-led training to clients in metro Atlanta and the Southeast. All the online courses have student files so you can follow along. All the videos also have closed captioning for the hearing impaired.
Microsoft Excel – Learn how to use Tables in Excel
January 9, 2018 – Start off 2018 by learning how to use Excel Tables. Chris Menard wrote an article for the Georgia Society of CPAs on six reasons to use Tables in Excel. The technology article is part of the GSCPA’s magazine. The magazine will be out the first or second week in January. It goes out to 11,000 members of the GSCPA, but Chris is creating a free training course, along with sample files, on using tables in Excel. The course is now available to CPAs and the public.
The article was written on six reasons to use Tables in Excel. Th word limit was 900 works. The online training course, which is located at https://chrismenardtraining.teachable.com/p/excel-tables covers ten reasons to use Tables in Excel.
Microsoft Word – 50+ YouTube Videos by Chris Menard
Covered in this playlist are over 50 Word training videos. Creating an index, using styles in Word, generating at Table of Contents, working with mail merge, headers and footers, spell check, using AutoComplete, working with page margins and orientation.
Also covered is selecting words, paragraphs, and the document with the mouse and keyboard. Formatting with the font group. Paragraph alignment for left, center, right and justified.
In addition, will be tables and tab stops and the format painter. Click here for the Microsoft Word Playlist
Word Videos below
Videos below show the format painter, find & replace in Word, and autocorrect.
Latest Blog Post
PivotTables in Excel with the Median Function. Shown are six features in six minutes. They include Average, Median, AverageIf, If, array function, and nested If with the median. The PivotTable works with a helper column added to the data.
Webinar Date: 3/15/2018 Host: Chris Menard - Microsoft Trainer in Atlanta, GA Prep until 3:31 - Live Webinar on Insights in Excel from March 15, 2018. Insights in Excel came out in December 2017 and is slowing rolling out to Office 365...read more
Recent Blog Post
Extracting email address from a text string in Excel can be tricky. I made a video demonstrating three methods of extracting the email addresses. I also showed how to take the email addresses and add a comma between them. This is handy when you need to...read more
February 28, 2018, at 2 PM ET - Webinar on Sway Are you ready to learn Microsoft Sway? Join Chris Menard and Cristian Cotovan on 2/28/2018 at 2 PM ET for a free 30-minute webinar on Microsoft Sway. What can you do with Microsoft Sway? Use Sway to show: new hires...read more
You can use Microsoft's Map Chart to compare values and show categories across geographical regions. The map chart works with geographical regions. This means your data should have Countries Regions States Counties Postal codes Note: This feature is only...read more
If you see data on a webpage and need to pull it into Microsoft Excel, don't copy/paste. Excel 2016 has a feature called Get Data / From Other Sources / From Web. In the example below I'm pulling population data for the 50 states from Wikipedia into Excel....read more
Microsoft Office Applications
I teach Excel, Word, PowerPoint, and Outlook. I’ve spotlighted three of the MS Office applications below. Click any of the icons below for Excel, Word, or PowerPoint to see the table of contents for those classes.
Bring out your best writing with Microsoft Word training from Chris Menard. After training, you will be able to create a table of contents, work with Styles, use advanced page formatting, build an index, create odd and even headers and footers, use SmartArt, and many other advanced features.
Start using PowerPoint correctly. Find high-quality images for your slides, insert video and audio into your presentation. Create presentations that captivate your audience and more importantly relate what you are trying to share.