Microsoft Excel: Advanced Training for Today’s Top Professionals
On-Demand Recording
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
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
- 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
- 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 is a Fellow of The Learning and Performance Institute and has worked with plus for a large number of global organizations.- Mike also designs and develops Microsoft Office-based solutions that automate key business processes.
- Mike will show you how to let Excel and other Microsoft programs solve your problems for you!
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.
$99.00
Guaranteed to be Good
All training experiences include a 7-day 100% money-back guarantee.
