Microsoft Excel: Advanced Training for Today's Top Professionals

Summary

In this 90-minute, instructor-led training, you will learn how to leverage all that Excel has to offer, by mastering its most advanced formulas, functions, shortcuts, and features. We’ll provide step-by-step guidance, plus powerful techniques for automating your data analysis and reporting processes.

Gain must-have skills and join us for this hands-on training to discover:

  • Ways to combine data from multiple worksheets & quickly create a linked summary
  • Next level filtering techniques, customization options & automation strategies
  • How to create a macro, macro shortcuts, buttons, settings & more
  • Advanced solutions for preparing, managing & analyzing reports

Practice while you learn: Each session includes a file that contains instructor-assisted exercises to boost your performance right away.

Can't make this date? Don't worry! Every registrant receives the recording, so you can watch it on your own time and then submit your questions.

Program Highlights

Expert Level Formulas, Functions & Data Tools - You’ll Wish You Knew Sooner

  • 3D formulas & Consolidate: Combine data from multiple worksheets & feed a linked summary
  • What-if scenarios: record projections based on variables in a variety of fields, automatically
  • Macros: Automate advanced filtering techniques & enable them for future use & sharing
  • Build One and Two-Input tables & test how changes in two variables impact formulas
  • Set objectives & targets: Produce results using Goal Seek and Solver
  • Advanced dashboards for reporting, analysis & presenting data
  • View live data on separate tabs with the Excel camera

Additional tools:

  • Question, Answer, Review & Wrap-up Session
  • Have your questions answered & gain solutions for specific challenges/use cases
  • Interactive Lab
  • You will practice what you've just learned with the expert
  • The exercise file can also be used for post-event practice

Additional Materials

  • A PowerPoint presentation
  • An exercise file

Program Benefits

In this webinar, you will discover how to automate and streamline your work, making Excel your most powerful productivity tool ever!

If you'd like this program customized for your organization, call us at 1-800-964-6033.
We're certain we can fulfill your training needs, while making it fit in your budget!

About The Speaker

Mike Thomas

"Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies including Microsoft Office and Apple Mac. Mike has produced nearly 200 written and video-based Excel tutorials, and... hundreds of courses and webinars on a wide variety of technology-related topics. Mike is a Fellow of The Learning and Performance Institute and has worked with and for a large number of global and UK-based companies and organizations across a diverse range of sectors. In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes."