EXC101 · Reliable Spreadsheet Fundamentals

Categories: Data & BI
Wishlist Share

About Course

Structure tables, validate inputs and apply formulas to repeatable business calculations.

Explore · 8 hours · Part of the Program in Excel and Power Query for Productivity

Lessons

  • Lesson 1 · Table structure and data best practices
  • Lesson 2 · Data validation and input control
  • Lesson 3 · Formulas for business calculations
  • Lesson 4 · Robust formulas, XLOOKUP and auditing

Self-paced, 12-month access. Questions are answered in writing through the student panel. A completion record is issued when you finish the course.

Next step

Continue with EXC102 · Power Query and Consolidation · 8 hours · $56.00

Continue to the next course

Prefer the whole program? Program in Excel and Power Query for Productivity · $202.00 (10% less than buying the courses separately)

Course Content

EXC101 · Reliable Spreadsheet Fundamentals (8 h)
Structure tables, validate inputs and apply formulas to repeatable business calculations.

  • Lesson 1 · Table structure and data best practices
  • Lesson 2 · Data validation and input control
  • Lesson 3 · Formulas for business calculations
  • Lesson 4 · Robust formulas, XLOOKUP and auditing
  • EXC101 Assessment · Reliable Spreadsheet Fundamentals
Scroll to Top