Learn Excel Now

Conquer the Fear of Excel

Keep up to date on all the newest live trainings, events, and tutorials.

  • Home
  • Training
    • Live Training
    • eLearning
    • On-Demand Training
  • All-Access
  • Resources
  • Library
  • Contact

Advanced Formulas & Functions in Excel: Solve Your Data Challenges

November 1, 2016 by

Advanced Formulas & Functions in Excel: Solve Your Data Challenges

Price: $199 + applicable taxes
Share

Summary

In this 90-minute, interactive training, discover advanced Excel formulas and functions to solve your Excel problems and finish your daily checklist faster. Join Excel expert Mitzi Katz for a 45-minute training packed with live demonstrations, followed by 15-minute of assisted exercises and a 30-minute interactive Q&A session that will drastically impact your learning curve and retention. In this comprehensive event you will discover:

  • 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
The Learn Excel Now Advantage – Get these additional training tools for greater retention:
  • 15 minutes of assisted exercises to increase your performance right away
  • 30 minutes of interaction & live Q&A session!
  • Customized & graded final exam to affect your retention & test your knowledge

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

Additional Training Tools:

  • 15-minute exercises session designed to boost your skills right away
  • A 30-minute interactive Q&A session to have all your Excel questions answered!
  • Customized & graded final exam to boost your retention & test your knowledge

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. Join us for this comprehensive, 90-minute Excel Lab that brings you all the power of live demonstrations, assisted exercises and more interaction in a live and longer Q&A session.

Add to Cart
On-Demand Course, at Registration
Price: $199 + applicable taxes
Share
All Access Subscription
Our 1-year all-access subscription provides step-by-step guidance for mastering Microsoft Office applications, with workshops, exercises and quick reference eGuides. It's perfect for anyone that needs to brush up on certain skills or even folks who need to learn the programs - from a beginner’s level.
Excel Foundations
Take the fear out of Excel with this 20 module self-paced training course. You will cover the most essential topics to develop a solid foundation of Excel or a lifetime of mastery.

Learn Excel Now helps you conquer the fear of Excel. By providing self-paced and instructor-led training and free strategies and guides, we leave no Excel mystery unsolved.

Sitemap

  • Home
  • Training
    • Live Training
    • eLearning
    • On-Demand Training
  • All-Access
  • Resources
  • Library
  • Contact

Connect with Us

  • Facebook
  • Linkedin

Contact

Learn Excel Now
questions@learnexcelnow.com
1-800-964-6033
384 Technology Drive
Malvern, PA 19355

Microsoft® Office Excel® is a registered trademark of the Microsoft Corporation in the United States and other countries. All rights reserved.

Copyright © 2020 ­ Learn Excel Now

Copyright © 2021 · News Pro Theme on Genesis Framework · WordPress · Log in