Log in
Business Courses

Excel 2026 Advanced: Smarter Excel Formulas for Modern Work

See licenses and prices Sign in
  1. Excel – Advanced2 lessons
    1. Introduction
    2. Advanced Keyboard Shortcuts
  2. Working with Multiple Workbooks4 lessons
    1. Tracing Precedents
    2. Tracing Dependents
    3. Watch Window
    4. Show Formulas
  3. Protecting Worksheets and Workbooks3 lessons
    1. Protecting Cells In A Worksheet
    2. Protecting The Workbook Structure
    3. Encryption With Passwords
  4. Conditional Formulas7 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
  5. Advanced Functions9 lessons
    1. Advanced Vlookup
    2. Advanced Xlookup
    3. Advanced Index And Match
    4. If And Is Error – Part 1
    5. If And Is Error – Part 2-1
    6. Dates – Part 1
    7. Dates – Part 2
    8. Replace And Substitute – Part 1
    9. Replace And Substitute – Part 2
  6. Text Based Functions5 lessons
    1. Left, Right And Mid
    2. Search Function
    3. Concatenate And Search
    4. Indirect – Static
    5. Indirect – Dynamic
  7. What IF Tools4 lessons
    1. Goal Seek
    2. Data Tables
    3. Scenarios
    4. Solver
  8. Bonus – Dashboard Preview1 lesson
    1. Bonus – Dashboard Preview
  9. Excel Advanced Resources3 lessons
    1. Resources
    2. Resources 2
    3. Resources 3
  10. Marketing Videos2 lessons
    1. Advanced
    2. In Todays Modern World

The Excel 2026 Advanced course is designed for experienced Excel users who want to build structured, scalable, and reliable spreadsheet solutions that go far beyond basic formulas and reporting.

At this level, Excel becomes a decision-support tool. You will learn how to design workbooks that behave like lightweight applications—connecting data across multiple files, applying advanced logic, auditing complex calculations, and protecting business-critical information. The course focuses heavily on formula intelligence, error handling, dynamic references, and scenario-based analysis, enabling you to reduce manual work and increase confidence in your results.

What you’ll learn

  • Design structured, scalable workbooks suitable for professional and business use
  • Work efficiently across multiple worksheets and workbooks
  • Trace precedents and dependents to audit and validate complex models
  • Monitor critical values using the Watch Window
  • Secure worksheets and workbooks with controlled protection and encryption
  • Use named ranges to improve formula readability and maintenance
  • Build advanced conditional logic using IF, AND, OR, and nested formulas
  • Apply conditional aggregation with COUNTIF(S) and SUMIF(S)
  • Master advanced lookup techniques with VLOOKUP, XLOOKUP, and INDEX + MATCH
  • Handle formula errors cleanly using IFERROR and ISERROR
  • Perform accurate date-based calculations and time analysis
  • Clean, extract, and restructure text using advanced text functions
  • Create static and dynamic references with INDIRECT
  • Use What-If tools such as Goal Seek, Data Tables, Scenario Manager, and Solver
  • Understand how dashboards summarise data and support faster decision-making

Who this course is for

  • Advanced Excel users who already work confidently with formulas and functions
  • Professionals building reports, models, or templates used by others
  • Analysts, finance professionals, and operations teams working with complex data
  • Anyone who wants to reduce spreadsheet errors and manual maintenance
  • Learners preparing for advanced reporting, dashboards, or automation workflows

Outcome

By the end of this course, you will be able to design Excel models that are robust, auditable, and secure. You’ll understand not just how advanced formulas work, but how to structure them properly for long-term use. This course prepares you to use Excel as a serious analytical and decision-support tool in modern professional environments.