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.
10/16/2017 – Excel Training for CPAs – Accounting and Auditing Credit (A&A). The class is held at Ronald Blue Trust in Atlanta Georgia. Please contact Chris Menard for more information.
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.
Excel Training for CPAs – A&A Credit – October 16, 2017
October 16, 2017 – Chris Menard will train CPAs in his Excel Advanced class for CPAs. This class coun Save & Exit ts for A&A credit is offered to CPAs in Georgia. Menard has been a trainer for the Georgia Society of CPAs for over 10 years.
Covered is this Excel class is break-even analysis, vertical analysis of income statement, horizontal analysis of income statements, and cash flow. Also covered are financial functions and income and balance sheet analysis. Menard is the featured speaker at the upcoming GSCPA Business and Industry Conference on November 9th and 10th in Atlanta.
Excel Instructor-led Training on October 25, 2017
October 25, 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.
Online Excel Training with Chris Menard
The Best Online Excel Training Ever 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.
Latest Blog Post
Send and Request money for free with Google Wallet. Not only is it free, but it is also very fast.
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
Recent Blog Post
After you insert an envelope in Word, you end up with page 2 of your document being a blank page to type the letter. Page 1 is the envelope. Most of the time you only want the envelope and not the blank page. Steps for removing the blank page: Press...read more
If you want to become a master of Excel, you need to learn how to use array formulas. Array formulas will perform calculations that other formulas in Excel can't do. Here is example 1 - multi-cell calculation to return multi results Select D2 to D8. Type...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