Take data from Wikipedia and other websites into Microsoft Excel

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.

Executive MBA Webinar in Excel

Webinar for the University of Georgia Terry College of Business Executive MBA students. Covered in the 30-minute webinar are tables vs. ranges, PivotTable Options, and saving filters.

Excel Tables - free online course

Here is my free online course on Ten Reasons to use Tables in Excel.

Scrape data from Wikipedia and pull into Google Sheets

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.

Online Excel Training

Learn Excel with Chris Menard on your schedule! Excel Intermediate Training at your own pace.

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-7Most 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

Microsoft Instructor Chris MenardChris 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.


Microsoft Excel – Learn how to use Tables in Excel

Excel Training for CPAs in AtlantaJanuary 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 Sway

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. Online Excel Training with Chris Menard


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

Pull web data directly into Microsoft Excel using Excel’s Get Data feature.

Pull website data in Excel

Pull website data in Excel

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

Recent Blog Post

Webinar – University of Georgia – EMBA students

Webinar – University of Georgia – EMBA students

UGA  - Terry College of Business in Atlanta - EMBA Webinar Date Recorded: January 17, 2018 Time: 7 pm to 7:30 pm Microsoft Office Master Instructor / Host: Chris Menard Introduction screen and music: Cristi Cotovan About the Executive MBA program at UGA Based in...

read more
Ten reasons to use Tables in Excel

Ten reasons to use Tables in Excel

Ten Reasons to Use Tables in Excel Microsoft Excel can be used to analyze vast amounts of data, and one of the best features in Excel for this purpose is changing your data range to a table. With tables, you can quickly sort and filter your data, add new...

read more

Deselect with the CTRL key in Excel

You can now deselect with the CTRL key in Excel. Version 1801 of Office 365 Excel allows you to deselect/unselect with the CTRL key. This was one of the most requested features of Excel users. Version 1801 was released on...

read more
Excel Functions for HR Professionals

Excel Functions for HR Professionals

Human Resource Professionals have a hectic schedule. They deal with benefits, training, staffing, retention, reviews, hiring, firing, personnel manuals, and many other HR aspects of their jobs. I've put together a list of Excel functions every HR...

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.

Excel Training

On-site Microsoft Excel training in Atlanta. There are three levels of Excel – Basic, Intermediate, and Advanced. It’s not a problem if you want to customize your class.

Word Training

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.

PowerPoint Training

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.

Chris Menard's YouTube videos

As of January 9, 2018

https://www.youtube.com/user/chrismenard7

Excel Videos

Word Videos

Other Technology Videos

Pin It on Pinterest