Content Provider
Gotomyerp middlebanner 102220
Handout Materials
Presentation Slides
Additional Materials
Cheat Sheet
Free cpe webinars
Get to REALLY Know Excel! (Functions You Need But Didn't Know You Were Missing)


Cost Free
Presentation Length 1.5 hours

Recorded DateMay 18, 2020
CPE:Not available
(archived webinars do not offer CPE credits)
Course LevelBasic
Series: Excel
Course Description

Using ‘real-life’ work examples, this session is designed to show you how to put to use some of the most practical and powerful features and formulas of MS Excel. Literally hours of work can be done in just a matter of seconds. Consider the following analogy.

You hire someone to clean the floors of a large facility – let’s say 300,000 square feet. You come in next Tuesday to see how the work is progressing, and your mouth drops open. You are fuming! The guy went out and hired 150 people; gave them paper towels and spray bottles of cleaner and wax, and they are on their hands and knees cleaning the floors. “There’s no way I’m paying you for this!”, you scream. “Are you out of your mind?! This will take 2,000 man-hours of time… you’re fired! I’ve got machines with rollers, and controls to squirt out cleaner and wax…. 60 hours – tops! That’s all it would take”.

No one in their right mind would pay someone to do work like that, not using the tool. Why spend time every day typing and clicking, and clicking and typing, when the computer does the work for you?

Course Objectives:

  • Understand how Excel formulas really work and how to avoid the ‘pitfalls’

  • Learn incredibly simple and extremely valuable navigation tools and shortcuts

  • Learn how to clean up PDF to Excel converted data in a snap

  • Learn super practical and useful features and functions to control and format data input

  • Learn the power of IF statements… and much more!


Not logged

Advantage Computer Solutions has been owned and managed by Mr. Norman Axelman since 1999.

Advantage Computer Solutions offers comprehensive services to individuals and businesses including, but not limited to: training; consulting; bookkeeping and accounting assistance; web design; and repairs and networks. With over 25 years of professional experience, Mr. Axelman provides an outstanding level of computer training with a focus on useful and practical day-to-day features and functions, resulting in increased efficiency and productivity. The training offered is on a one-to-one basis, usually for just one hour at a time, allowing clients to learn at their own pace, without getting an ‘overkill’ of information.

Mr. Axelman is an adjunct professor for the Miami Dade College School of Continuing Education, has been retained as a computer instructor for a yearly national convention of Quickbooks users, and is accredited by the State of Florida to teach Continuing Education computer classes for licensed Community Association Managers.

Over the years Mr. Axelman has created and delivered numerous presentations and classes for various organizations, companies and schools including the University of Miami, Florida International University and City College of Miami.

About Our Presenter

If you are looking to greatly increase efficiency and productivity, call on Advantage Computer Solutions to professionally train your staff. At ACS we teach more than just features, functions and fabulous shortcuts… we teach how to use the computer as a tool.

Let us show you how to accomplish literally hours of work in just minutes or even seconds. Learn how to simplify and analyze data, and how to get the most out of your computer.