Best Seller New POPULAR

  • Student 117 Student
  • Last Update23 January 2024
Write your awesome label here.

Join Over 100 Students Who Have Enrolled

  • 78 Student

This Course Include

  • Expert-led lectures covering AI and ML essentials.
  • Practical projects for hands-on skill development.
  • Access to cutting-edge AI tools and software.
  • Engaging discussions and collaboration with peers.

Course Details 

Welcome to Syntax Academy's "Excel Advanced" course! This comprehensive program is designed to take your Excel skills to the next level, equipping you with advanced techniques and tools to excel in your data management tasks.

What you will learn

  • Master advanced shortcut keys for quicker navigation.
  • Understand how to trace precedents and use the watch window for better tracking.
  • Learn to protect cells and workbook structures for enhanced data security.
  • Explore encryption with passwords to safeguard sensitive information.
  • Utilize name ranges for efficient data management.
  • Master IF functions and their variations for logical data analysis.
  • Harness the power of advanced lookup techniques like VLOOKUP and INDEX MATCH.
  • Dive into working with dates effectively.
  • Manipulate text using functions like Replace, Substitute, Left, Right, and Mid.
  • Explore concatenation and search functions for text manipulation.
  • Learn to use dynamic and static indirect functions.
  • Discover advanced tools like Goal Seek, Scenario Manager, and Solver for complex problem-solving.
With a total of 35 engaging videos, this course covers a wide array of topics ranging from mastering advanced shortcut keys to building dynamic dashboards. Throughout the program, you'll dive into essential functionalities such as tracing precedents, protecting cells and workbook structures, and encryption with passwords. You'll also learn how to efficiently manage data with features like name ranges, IF functions, and advanced lookup techniques.
By the end of the course, you'll have gained a comprehensive understanding of Excel's advanced features and techniques, empowering you to tackle real-world challenges with confidence.

Course contents