CourseExcelBackExcel Formulas & Functions
0 / 5 modules doneQuiz: 0 / 15
Browser syncAll CoursesDashboard
MODULE 01 / 0512 min lesson + drill

Formula Anatomy & Mixed Cell Locking ($A$1)

Write readable multi-cell formulas using relative vs absolute ($A$1) and mixed ($A2 / B$1) references for rate tables.

ChandooYouTube ↗ (opens in a new tab)

Key takeaways while you watch

  • Lock the tax or FX assumption cell with $B$1 before dragging down rows.
  • Use F4 to cycle through $B$1 -> B$1 -> $B1 -> B1 quickly.
  • Keep rates and percentages in dedicated input cells instead of hardcoding numbers inside formulas.
COURSE CERTIFICATE · IN PROGRESSCourse Finisher (=COMPLETE())

Excel Formulas & Functions | 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

Excel Formulas & Functions — Certificate of Completion

ExcelBack Certificate Preview

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