Advanced
Excel lms

Excel Advanced

Andries Andries
Overview
Curriculum
  • 8 Sections
  • 34 Lessons
  • 8h Duration
Collapse All
Section 1 – Excel Advanced Introduction
2 Lessons
  1. Excel Advanced Introduction
  2. Advanced Shortcut Keys
Section 2 - Working with Multiple Workbooks
4 Lessons
  1. Tracing Precedents
  2. Tracing Dependents
  3. Watch Window
  4. Show Formulas
Section 3 - Protecting Worksheets and Workbooks
3 Lessons
  1. Protecting Cells in a Worksheet
  2. Protecting the Workbook Structure
  3. Encryption with Passwords
Section 4 - Conditional Formulas
7 Lessons
  1. Name Ranges
  2. Simple IF Function
  3. IF, AND
  4. IF, OR
  5. Nested Formulas
  6. CountIF and CountIFs
  7. SumIF and SumIFs
Section 5 - Advanced Functions
8 Lessons
  1. Advanced VLoopkUp
  2. IF and IS Error - Part 1
  3. IF and IS Error - Part 2
  4. Advanced Index Match
  5. Dates - Part 1
  6. Dates - Part 2
  7. Replace and Substitute - Part 1
  8. Replace and Substitute - Part 2
Section 6 - Text Based Functions
5 Lessons
  1. Left, Right and Mid
  2. Search Function
  3. Concatenate and Search
  4. Indirect - Static
  5. Indirect - Dynamic
Section 7 - What IF Tools
4 Lessons
  1. Goal Seek
  2. Data Tables
  3. Scenarios
  4. Solver
Section 8 - Bonus
1 Lesson
  1. Advanced Pivot Tables

In the Excel Advanced course, participants will delve deeper into the powerful features of Microsoft Excel to enhance their data analysis and decision-making skills. This course covers advanced topics such as Solver, a tool used for optimization problems, allowing users to find the best solutions while adhering to specified constraints. Participants will also learn how to create and analyze What-If Scenarios, enabling them to explore different possibilities by adjusting input values and observing the resulting outcomes.

Furthermore, the course will focus on nesting formulas within structured tables, leveraging Excel's Table feature to organize data effectively and perform complex calculations efficiently. Additionally, participants will discover the benefits of using Name Ranges to assign meaningful labels to cells or ranges, improving the readability and manageability of formulas within their workbooks.
By the end of the Excel Advanced course, participants will have acquired the skills necessary to tackle real-world challenges, from optimizing business processes to performing sophisticated data analysis, using Excel's advanced functionalities effectively.

Deleting Course Review

Are you sure? You can't restore this back

Course Access

This course is password protected. To access it please enter your password below:

Related Courses

Expert
Excel lms

Excel VBA

Andries Andries

  • Automate repetitive tasks

    • Enhance Excel functionality

    Increase productivity

    16h
    53
    Buy Now
    Intermediate
    Excel lms

    Excel Intermediate

    Andries Andries

  • Conditional Formatting Mastery

    • Data Validation Techniques

    Advanced Formulas and Functions

    8h
    44
    Buy Now
    Intermediate
    Excel lms

    Excel Beginner

    Andries Andries

    User-Friendly Interface

  • Basic Formulas and Functions

    • Data Organization

    8h
    44
    Buy Now
    Scroll to Top