Excel 2026 – Advanced: Smarter Excel Formulas for Modern Work – Training Course on USB

$39.95

For experienced Excel users: build structured, scalable and reliable spreadsheet solutions with formula auditing, protection and encryption, conditional logic, advanced lookups, error handling, date and text functions, and What-If tools. 35 lessons in 8 sections, on a USB drive.

One-time purchase. No monthly fee. Yours to keep.

Description

What You Get

  • The complete Excel 2026 – Advanced course on one USB drive
  • 35 video lessons in 8 sections
  • Works on Windows PC and Mac
  • Plays offline: no internet needed to watch the lessons on the USB
  • Online access included
  • One-time purchase. No monthly fee. Yours to keep.
  • Ships within 1-2 business days. $8.95 flat-rate shipping in the US, $15.00 to Canada. Shipping details
  • 30-Day Money-Back Guarantee

Want all three levels? Get the Excel 2026 Complete 3-in-1 Bundle for $69.95 and save $34.90.

Trusted since 2005 · 9,000+ items sold · 100% positive eBay feedback · See our eBay reviews

Excel 2026 – Advanced: Smarter Excel Formulas for Modern Work, on USB

This Excel Advanced course is designed for experienced users who want to build structured, scalable and reliable spreadsheet solutions. It focuses on advanced workbook design, working across multiple files, auditing and tracing complex formulas, monitoring key values, and applying protection and encryption to secure business-critical data. You’ll master conditional logic, advanced lookup methods, error handling, date calculations and text-based functions, while using dynamic references and What-If tools such as Goal Seek, Data Tables, Scenarios and Solver. By the end of the course, you’ll be able to create Excel models that function like lightweight applications, reducing manual effort and supporting confident, data-driven decision-making.

Why You’ll Love It

  • One-time purchase. No monthly fee. No subscription. Yours to keep.
  • Build Excel models that work like lightweight applications
  • Reduce manual effort and support confident, data-driven decisions
  • 35 lessons in 8 sections, including a bonus Dashboard Preview
  • The complete course on a USB drive

What You’ll Learn

  • Designing structured, scalable and error-resistant workbooks
  • Auditing: tracing precedents and dependents, the Watch Window and Show Formulas
  • Protecting worksheets and workbooks with passwords and controlled access
  • Advanced conditional formulas: named ranges, IF, IF AND, IF OR, nested formulas, COUNTIF(S) and SUMIF(S)
  • Advanced lookup techniques: VLOOKUP, XLOOKUP and INDEX + MATCH
  • Handling errors with IFERROR and ISERROR
  • Working with dates, text functions (LEFT, RIGHT, MID, SEARCH, REPLACE, SUBSTITUTE) and dynamic references with INDIRECT
  • What-If tools: Goal Seek, Data Tables, Scenarios and Solver

What’s Inside

Section 1 – Getting Started

  • Lesson 1 – Introduction
  • Lesson 2 – Advanced Keyboard Shortcuts

Section 2 – Working With Multiple Workbooks

  • Lesson 3 – Tracing Precedents
  • Lesson 4 – Tracing Dependents
  • Lesson 5 – Watch Window
  • Lesson 6 – Show Formulas

Section 3 – Protecting Worksheets and Workbooks

  • Lesson 7 – Protecting Cells in a Worksheet
  • Lesson 8 – Protecting the Workbook Structure
  • Lesson 9 – Encryption with Passwords

Section 4 – Conditional Formulas

  • Lesson 10 – Name Ranges
  • Lesson 11 – Simple IF Function
  • Lesson 12 – IF AND
  • Lesson 13 – IF OR
  • Lesson 14 – Nested Formulas
  • Lesson 15 – CountIF and CountIFs
  • Lesson 16 – SumIF and SumIFs

Section 5 – Advanced Functions

  • Lesson 17 – Advanced VLookUp
  • Lesson 18 – Advanced XLookUp
  • Lesson 19 – Advanced Index and Match
  • Lesson 20 – IF and IS Error – Part 1
  • Lesson 21 – IF and IS Error – Part 2
  • Lesson 22 – Dates – Part 1
  • Lesson 23 – Dates – Part 2
  • Lesson 24 – Replace and Substitute – Part 1
  • Lesson 25 – Replace and Substitute – Part 2

Section 6 – Text Based Functions

  • Lesson 26 – Left, Right and Mid
  • Lesson 27 – Search Function
  • Lesson 28 – Concatenate and Search
  • Lesson 29 – Indirect – Static
  • Lesson 30 – Indirect – Dynamic

Section 7 – What IF Tools

  • Lesson 31 – Goal Seek
  • Lesson 32 – Data Tables
  • Lesson 33 – Scenarios
  • Lesson 34 – Solver

Section 8 – Bonus – Dashboard Preview

  • Lesson 35 – Dashboard Preview

Who It’s For

  • Experienced Excel users who want to build structured, scalable and reliable spreadsheet solutions
  • People who review inherited spreadsheets or work across multiple files
  • Anyone who builds models for targets, pricing or planning decisions

Frequently Asked Questions

Is this right for me?

It’s designed for experienced Excel users. If you’re still building your skills, start with Excel 2026 – Intermediate or get the Complete 3-in-1 Bundle.

Is there a monthly fee or subscription?

No. It’s a one-time purchase with no monthly fee. The USB is yours to keep.

Does it include Microsoft Excel?

No. This is a training course. Microsoft Excel (Microsoft 365) is sold separately by Microsoft.

Which level should I choose?

Beginner if you’re new to Excel. Intermediate if you already have the foundational skills and want to analyze data. Advanced if you’re an experienced user who builds structured, reliable workbooks. Want all three? The Complete 3-in-1 Bundle saves $34.90.

Additional information

Weight 0.1 oz

Reviews

There are no reviews yet.

Be the first to review “Excel 2026 – Advanced: Smarter Excel Formulas for Modern Work – Training Course on USB”

Your email address will not be published. Required fields are marked *

You may also like…