TRAINING OVERVIEW
Do you need that extra boost to develop more complex functions and formulas? In this class, you will learn advanced Excel formulas and functions to bring your spreadsheets to the next level. Learn how to develop more complex formulas and learn the power of arrays. Learn formulas to help you automate your spreadsheets to simplify them for easier use for others, as well as yourself. Our instructors will be on hand to help you gain a mastery of these advanced functions and formulas of Excel, as well as answer any questions you may have.
LEADERSHIP COMPETENCIES:
- Business Acumen
- Job Knowledge
LEARNING OBJECTIVES:
- Understand advanced Excel formulas and functions that can help with their more complicated projects
- Learn complex formulas and how to nest several different functions
- Learn how to create dynamic drop-down lists to automate their spreadsheets for others to use
- Learn how to write formulas that create filtered columns that eliminate blanks
TRAINING DETAILS
Length:
8 Hours
Offered:
In-Person / Online
Training Fee:
$525/per person
**Group pricing available for teamsExplore More Business Acumen Trainings
- Project Management Lite
- Project Management: Agile/Scrum Basics
- Foundations of Project Management
- Project Management: Managing Your Day
- Project Management: Portfolio Management for Teams and Organizations
- Communications for Project Managers
- Soft Skills for Project Managers
- Using Customer Analytics
- Avoid Contract Pitfalls: What Project Managers Need to Know
- Microsoft Quick Tips Training
- Excel Basics
- Excel Intermediate
- Excel Advanced
- Excel Functions and Formulas
- Excel Pivot Tables and Charts
- PowerPoint Basics: The Building Blocks
- Powerpoint Intermediate: Designing for Presentation
- Time Management with Outlook
- Microsoft Word Intermediate Training
- Crisis and Reputation Management
- Developing a Media Channel Strategy
- Social Media Marketing 101
