Advanced Excel

“Taking Excel to the Next Level” is an empowering and comprehensive program that takes participants beyond the basics and equips them with advanced Excel skills. Through hands-on exercises, attendees will delve into complex functions, data validation, and error handling. They will learn how to create dynamic range names, utilize the power of Advanced Filters and Quick Analysis, and master the art of consolidating data from multiple workbooks. The class will cover various text functions, intersection range names, and provide insights into formula auditing and scenario management. Participants will also gain proficiency in working with form controls, creating custom views, and incorporating hyperlinks for enhanced worksheet navigation.

Students will learn:

  • Real-Life Projects
  • Ranges and Range Names
  • Advanced Filter and Quick Analysis
  • Creating Charts and Data Consolidation
  • Complex Functions and Data Validation
  • Rounding and Error Handling
  • Boolean Formulas and Calculation Settings
  • Text Functions and Intersection Range Names
  • Formula Auditing and Scenario Manager
  • Form Controls and Custom Views
  • Hyperlinks and Quick Access Toolbar

In this advanced Excel course, students will embark on a journey of comprehensive learning, honing their skills in real-life projects and mastering advanced techniques. They will explore the power of ranges and range names, simplifying data navigation and organization. With advanced filtering and quick analysis tools, they will efficiently dissect complex datasets and create compelling charts. The course delves into complex functions and data validation, ensuring data accuracy and precision. Students will become adept at handling errors and optimizing calculations for enhanced performance. Boolean formulas and text functions will enable students to make data-driven decisions and manipulate text with ease. Formula auditing and scenario management ensure data integrity and streamlined analysis. The class also covers form controls and custom views, elevating worksheet interactivity and personalization. Hyperlinks and the Quick Access Toolbar will facilitate seamless navigation across workbooks and external resources. By the end of this course, students will be proficient in advanced Excel techniques, empowering them to tackle complex data challenges with confidence and efficiency.

Downloadable Flyer: Excel Classes Spring 2024

Cost

$225.00

Additional information

Class Dates

  • Tuesday, April 30, 2024
    • 8:00 am – 5:00 pm
    • Deadline to register: April 23, 2024

Cost

  • $40 ETP Price*
  • $225 Non-ETP price

* Most companies qualify for ETP funding! Click here for more ETP info.
Contact us for more info: [email protected] or 559.688.3130.

Click here to learn how to sign-up for ETP with us!

Want to earn a full/partial scholarship for this training? Click here to apply for the VEDC Scholarship! 


Instructor

Myke Munroe


Location

Online via Zoom


Employee Registration

Please click here to register your employees for this training.


Questions

Please contact us at 559.688.3130 or [email protected]

Please click here to view our cancellation and refund policy.