CourseExcelBackVBA & Macros
0 / 5 modules doneQuiz: 0 / 15
Browser syncAll CoursesDashboard
MODULE 01 / 0513 min lesson + drill

Recording Clean Macros & Saving as .xlsm

Enable the Developer tab, record clean repeatable formatting macros, and preserve VBA code safely in macro-enabled workbooks.

Leila GharaniYouTube ↗ (opens in a new tab)

Key takeaways while you watch

  • Standard .xlsx workbooks strip all VBA modules on save—save macro workbooks as .xlsm.
  • Plan clicks before hitting Record Macro so the generated VBA isn't cluttered with wasted scrolls.
  • Store personal cross-file formatting helpers inside PERSONAL.XLSB (Personal Macro Workbook).
COURSE CERTIFICATE · IN PROGRESSCourse Finisher (=COMPLETE())

VBA & Macros | Certificate of Completion

Complete all 5 modules to unlock your personalized 1200×630 PNG certificate and LinkedIn credential link.

Finish 5 modules to unlockScore 100% quizzes toward Quiz Ace (=EXACT())Complete 3 full courses for Path Champion (=EXCEL())
My Badges & Certificates
EXCELBACK CREDENTIAL PREVIEW

VBA & Macros — Certificate of Completion

ExcelBack Certificate Preview

Sample preview shown. Complete all 5 modules to personalize with your account name and download PNG.