EXC103 · Report Controls and Analysis

Categories: Data & BI
Wishlist Share

About Course

Reconcile balances, flag exceptions and summarize results with PivotTables and validation checks.

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

Lessons

  • Lesson 1 · Reconciling balances between sources
  • Lesson 2 · Flagging exceptions
  • Lesson 3 · PivotTables to summarize results
  • Lesson 4 · Validation checks and report presentation

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 EXC104 · Month-End Close Project · 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

EXC103 · Report Controls and Analysis (8 h)
Reconcile balances, flag exceptions and summarize results with PivotTables and validation checks.

  • Lesson 1 · Reconciling balances between sources
  • Lesson 2 · Flagging exceptions
  • Lesson 3 · PivotTables to summarize results
  • Lesson 4 · Validation checks and report presentation
  • EXC103 Assessment · Report Controls and Analysis
Scroll to Top