Content Provider
Advantagecomputer

Self-Study CPE
6 STEPS TO AN EXTRA 100K FOR YOUR BOOKKEEPING FIRM
View Details/Register
UNLOCKING FINANCIAL EFFICIENCY WITH RAMP
View Details/Register
INTRODUCTION TO FIRMTAMER PRACTICE MANAGEMENT SOFTWARE: LIVE DEMO
View Details/Register
BILL SPEND & EXPENSE: THE POWER OF CLIENT ADVISORY SUCCESS AT PARABLE ACCOUNTING
View Details/Register
BILL DEMO: STREAMLINE CASH FLOW WITH INSIGHTS & FORECASTING
View Details/Register
Free cpe webinars
Get to REALLY Know Excel! (Functions You Need But Didn't Know You Were Missing)

GET TO REALLY KNOW EXCEL! (FUNCTIONS YOU NEED BUT DIDN'T KNOW YOU WERE MISSING)

Cost Free
CPE Credits 1.5 hours
CE Credits 0.0 hours
Course Level Basic
Instructional Method Group Internet Based
Prerequisites None
Advanced Preparation None
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!



 

Advantagecomputer

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.

Additional Materials
Cheat Sheet
Webinar Technical FAQs
Frequently Asked Questions
  • To receive CPE credit, you must register for the webinar before it starts.
  • CPE is available to all eligible participants within 24 hours of each webinar.
  • To receive CPE for multiple attendees, at least one person must sign up for the webinar. The post-webinar email contains a link to instructions for the proctor letter. Alternatively, you may log in to your account following the webinar and click on the MY ACCOUNT button to find a link to instructions. For paid courses, payment needs to be made for each attendee before credit will be issued.
Handout Materials
Presentation Slides
Nasba

NASBA Approved

CPAacademy.org (Sponsor Id#: 111889) is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.

CPAacademy.org 1685 S. Colorado Blvd, Suite #205, Denver, CO 80222

About Our Presenter

Advantagecomputer
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.