TRAINING OVERVIEW
This Advanced Excel class is designed for everyday users of Excel, who want to take their skills to the next level. Advanced Excel training covers more intricate formulas, creating validations, writing macros, embedding other documents, and protecting your data in Excel. The class includes useful functions for various business applications, as well as how to combine these with other functions. Our instructors will be on hand to answer any questions you have and lead you to a thorough understanding of Excel at an advanced level.
Students should have a firm understanding of Excel fundamentals, including formatting, navigation, basic formulas, and basic functions. Students should be comfortable with basic IF statements. This Advanced Excel class builds upon knowledge gained in the Intermediate Excel course. Students should have a reasonable comfort level working in Excel at an intermediate proficiency before taking this course.
Topics Covered
-
Advanced Formulas
-
Look Ups and Other Functions
-
Data Views, Layouts and Rules
-
Introduction to Macros
-
Additional Tools in Advanced Excel
Advanced Excel training helps students learn new functions to enhance their spreadsheets, as well as tools to make their spreadsheets easier to share, with added automation.
Your instructor for this course will be from AdvantEdge Training & Consulting.
LEADERSHIP COMPETENCIES:
- Business Acumen
- Job Knowledge
LEARNING OBJECTIVES:
- Learn new functions to enhance spreadsheets, as well as tools to make spreadsheets easier to share, with added automation
TRAINING DETAILS
Length:
4 Hours
Offered:
In-Person / Online
Training Fee:
$275/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
