Advanced Formulas & Functions in Excel: Solve Your Data Challenges

Price: $

Summary

In this 90-minute training, discover advanced Excel formulas and functions to solve your Excel problems and finish your daily checklist faster. Our Excel expert, Mitzi Katz, will drastically impact your learning curve and retention.

Advanced Excel formula tips & shortcuts: Powerful solutions to save time
Excel power functions: Key techniques to tabulate information
Extend your formula capabilities with Arrays
Statistical functions: MEDIAN, RANK, COUNTBLANK
Information functions: IS, error-checking & getting data from remote cells

Program Highlights

Timesaving Excel Power Functions: Keys to Impress Your Colleagues

Vital functions & formulas: Advanced tips to help ease your day
How to Create 3D formulas to gather data from multiple sheets
Power functions to tabulate information on single & multiple criteria

Arrays, Statistical Formulas & More: Solutions to Work Better & Faster

Powerful statistical functions you MUST know: MEDIAN, RANK & more
Use Arrays to extend formula capabilities & build analysis
Information functions: IS, check errors, get data from remote cells

About The Speaker

Mitzi Gibson Katz has trained thousands of end users and developed curriculum for over twenty-five years.

As a consultant, she specializes in the Microsoft Office suite including Excel, Access, PowerPoint, Word, Outlook and much more.
After teaching a variety of special education classes in Kansas, Montana, and Alaska for the early part of her career, Mitzi became interested in technology as the first personal computers were introduced to the market. She made the change in careers from public school education to private computer training and has been teaching students how to use software applications ever since.
Mitzi helps students understand Excel by her passion: "It's the people part of the business that keeps me involved."

Program Benefits

Simplify your life and impress your colleagues with all the power of more advanced Excel's formulas & functions.

Credits

Credit Hours:

Field of Study:

Program Level:

Basic Knowledge

Prerequisites:

None

Advance Prep:

Delivery Method:

Group Internet Based

Progressive Business Conferences 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

Purchase This On-Demand Webinar