Insightful Accountant Presents Getting to Really Know Excel Super Functions

by

"Let's see, instead of considering the total sales by customer and then calculating the total of all sales, I want to know the average sales by each of the company units across all of the company across all of the units in the country. What the heck? How on earth am I ever going to figure that out?"

Even though you may have a wealth of information with lots of formulas in Excel, it doesn't really help if you have a complex set of information that needs a more simplistic way of looking at all the details.  That's where the power of Excel 'super functions' like Pivot Tables come into play.

Pivot tables offer you a slew of ways to slice and dice your complex data to make it easier to digest. But the trick to using Pivot tables effectively is knowing exactly what you want to see before you start the process of setting them up, and knowing exactly how to use the super functions of Excel to produce the Pivot table to give you the information you are looking for, and that's where the experience of a 'seasoned instructor' comes handy.

During Insightful Accountant's  Getting to Really Know Excel Super Functions webinar Norman will give you keen insights into the use of Pivot Tables using his 25 years of experience to show you how you can apply those functions to your own business situations.

Pivot Tables give you answers to all kinds of questions you've been wondering about like your product sales, or effectiveness of your marketing budget, or the relationship of product costs to item revenues over time. Excel Pivot tables can give you fast and accurate answers to the complicated questions you need to run your business.

But Pivot Tables are not all Norman will also teach during this 1-hour webinar, he will also provide instruction on VLookup and Range Names.

VLOOKUP performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index_number position. VLookup is not only one of the most popular functions in Excel, but it is also one of the most valuable functions since it can be used almost daily in real life situations. When you are trying to match-up data in Excel, VLookup is typically the first function you use. But sometimes, VLookup isn’t right for your situation, that’s why Norman will also cover what to do when VLookup doesn’t work.

By the time this webinar ends you will feel like you have more than gotten your $49.00 worth of instruction because you will have learned so many new functions to help you reduce the time-consuming tasks you present perform in Excel you will think Norman is teaching ‘pure magic.’

By the way, Norman Axelman, the webinar instructor, is owner of Advantage Computer Solutions, he is also an adjunct profession at Miami Dade College – School of Continuing Education and is accredited by the State of Florida to teach Continuing Education computer classes. Norman has delivered numerous presentations and classes for such prestigious organizations as the City College of Miami, Florida International University, and the University of Miami. In addition, Norman has taught Excel to hundreds of QuickBooks ProAdvisors during conferences and monthly webinar appearances for the Woodard Group.

You really don't want to miss this opportunity to expand your skills and knowledge of Excel by learning Excel Super Functions.  Make certain to register for this $49.00 webinar, Getting to Really Know Excel Super Functions being held on WEDNESDAY, SEPTEMBER 30, 2020 at 2 PM Eastern (1 PM Central).  REGISTER HERE