If you see data in Wikipedia and you need to pull it into a spreadsheet, don’t copy and paste. Use Google Sheets IMPORTHTML function. It is an amazing feature.
Microsoft Office Training with Chris Menard
Welcome to my website. I provide Microsoft Training in Excel, Word, PowerPoint, and Outlook 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, Gwinnett County, Cobb County, and Fulton County, but I travel anywhere to do training. I’ve been flown to Sonoma, CA to train a group in PowerPoint, and Orlando, FL and Dallas, TX to train companies in Excel.
When I’m not training in Microsoft Office, I create free technology video for my YouTube. Currently, I have over 260 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 / 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, Kids II, Gwinnett Medical Center, and many other clients in metro Atlanta.
Webinar for the Terry College of Business Executive MBA students
Covered in this 30-minute webinar from October 2017 are Scenarios in Excel, creating a report correctly in Word by using Section Breaks, unlinking headers in Word, If Statements in Excel, If And statements, and advanced Vlookup in Excel.
Note: ideal settings are to view full screen and change the settings to HD 720p. The setting cion looks like a gear in the bottom right of the video.
Microsoft Excel Instructor-led Training – November 16, 2017
November 16, 2017 – Excel Training in Atlanta with Chris Menard. In this course, you will learn spreadsheet terminology and the fundamental concepts of Microsoft Excel 2013 / 2016, including identifying Excel window components, navigating worksheets, and downloading templates. In addition, students will learn the basics of entering and editing text, values, and formulas, and how to save workbooks in the native Excel format, as well as in other formats.
You will learn how to move and copy data and formulas, how to determine absolute and relative references, and how to work with ranges, rows, and columns. You will also learn how to use simple functions, and how to easily apply formatting techniques to worksheet data. They will create and modify charts, and work with graphics. Finally, you will review workbooks for spelling errors, modify page setup, and print worksheets.
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 275 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 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
Excel functions for the HR professional. Covered are today, datedif, networkdays, and workday.
Recent Blog Post
Google Wallet is free! It is one of the fastest ways to send money, You can send money through either the app, in Gmail, or use the web. The website is wallet.google.com. You can send money to someone using just their email address or...read more
Do you ever have Wikipedia data you need in a spreadsheet? Using Google Sheets you don't have to copy and paste. Instead, use the ImportHTML function in Google Sheets and get the data from Wikipedia. https://youtu.be/1CtMtytSAto Scraping data can save you tons of...read more
The Google calendar is great. Not many people utilize the Labs feature in Google calendar. Here are three features you probably didn't know about, but should use from Google labs. Hide Morning and Night Do you have meetings at 2 am? Likely not. There is no...read more
Break-even overview Calculating the break-even on a company with only one product is relatively easy. Just take the total fixed expenses and divide by the contribution margin per unit. The contribution margin per unit is the unit sales price minus the unit...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.
Other Technology Videos
Popular Excel & Word videos from Chris Menard