FormulaCamp
Completed
← Full curriculum
Track 16 · Expert

Professional Excel Engineering

Workbook architecture, protection, formula auditing, collaboration, and optimization.

2 free lessons

0 of 7 completed · about 2.7 h

Start

7 lessons left until your certificate

Introduction

  1. 1Professional Workbooks: Architecture and AuditingFreetheory and quiz15 min

Architecture and Auditing

  1. 2Separating Inputs from CalculationsFreelesson20 min
  2. 3Dependency Auditing and Check Totalslesson25 min
  3. 4Protecting Sheets and Workbookstheory and quiz15 min

Performance and Integration

  1. 5Optimizing Recalculationlesson20 min
  2. 6Excel, Power BI, and SQLlesson25 min

Project

  1. 7Project: Auditing Someone Else's Modelproject40 min