LLearnCode
Academy/VBA & office automation

languages · 16 lessons

VBA & office automation

The existing workbook automation journey, preserved in full.

What you are working toward

Automate office tasks with explicit inputs and checks.

0 learning steps complete · View prerequisites and evidence →

The existing foundation

Start here, or use it to fill a gap.

Original lessons, practice, bosses, and progress are preserved. Completion from this journey is distinct from the new independent evidence model.

  1. 01Macro mental modelGuided foundationOpen →
  2. 02Recorder vs written VBAGuided foundationOpen →
  3. 03Cells & rangesGuided foundationOpen →
  4. 04VariablesGuided foundationOpen →
  5. 05ConditionsGuided foundationOpen →
  6. 06LoopsGuided foundationOpen →
  7. 07Worksheet objectsGuided foundationOpen →
  8. 08Workbook boundariesGuided foundationOpen →
  9. 09Worksheets & workbooksGuided foundationOpen →
  10. 10Reusable proceduresGuided foundationOpen →
  11. 11VBA FunctionsGuided foundationOpen →
  12. 12Last row & dynamic rangesGuided foundationOpen →
  13. 13Formatting & report generationGuided foundationOpen →
  14. 14Importing & consolidating dataGuided foundationOpen →
  15. 15Error handlingGuided foundationOpen →
  16. 16Safe macro habitsGuided foundationOpen →
Open interactive labs →Explore capstonesOriginal academy boss →