Excel Advanced Training - Instructor-led - Nov 29

 

November 29, 2017 – Learn Excel Advanced features with Chris Menard

Webinar for Executive MBAs

10/17/2017 – Webinar at 7 pm for the University of Georgia Executive MBA students. Advanced Excel, PowerPoint, and Word features will be covered.

GSCPA - Excel Tips and Tricks

November 9, 2017 – Cobb Galleria – Chris Menard will present to the Georgia Society of CPAs Excel Tips and Tricks from 10:30 to 11:45 a.m.

GSCPA - Tech Fun Stuff

November 9, 2017 – Cobb Galleria – Chris Menard will present to the Georgia Society of CPAs Tech Fun Stuff from 2:15 to 3:05 p.m.

Excel Deep Dive Data Analysis for CPAs

November 9, 2017, from 3:15 to 4:30 p.m. Chris Menard will present to the Georgia Society of CPAs Excel – Deep Dive Data Analysis at the Cobb Galleria Centre.

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.

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

Excel Training for CPAs in AtlantaNovember 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.

Click here to see more information about Excel Basic on 11/16/2017.


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

Excel functions for the HR professional. Covered are today, datedif, networkdays, and workday.

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

Recent Blog Post

Send and Receive money for free with Google Wallet

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

Scrape data from Wikipedia to a Google sheet

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
Google Calendar – 3 Lab features you need to use

Google Calendar – 3 Lab features you need to use

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
Breakeven in Excel with multiple products

Breakeven in Excel with multiple products

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.

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 November 8, 2017

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

Excel Videos

Word Videos

Other Technology Videos

Pin It on Pinterest