Excel Crash Course – Comprehensive Guide with Worked Examples, Complete Solutions, and Spreadsheet Skills

EXCEL CRASH COURSE
(ELABORATED) WITH
COMPLETE VERIFIED
SOLUTIONS GRADED A+ (2026
UPDATE)
Auto-width columns to fit the size - answer-Alt + H + O + I



Define width of columns - answer-Alt + H + O + W



Rename a worksheet - answer-ALT + H + O + R



Add worksheet - answer-Alt + H + I + S



Freeze and unfreeze panes - answer-Alt + W + F + F



Split pane - answer-Alt + W + S



Jump from split pane to split pane - answer-F6



To navigate outside the cell when in formula - answer-F2



Add comment - answer-Alt + N + C2



Delete Row/Column - answer-Ctrl -



Add row - answer-Ctrl + Shift + +

, Paste special - answer-Alt + E + S or Ctrl + Alt + V



Transpose - answer-Alt + E + S + E



How to get to date format "April-24" - answer-Go to Ctrl + 1, then Custom, then select
mm-yy



Remove all borders - answer-Ctrl + Shift + _



Trace precedents - answer-Alt + M + P



Trace dependents - answer-Alt + M + D



Remove arrows - answer-Alt + M + A



How to format inputs/hardcodes blue - answer-Go to special (Ctrl + G), then Custom,
select Constants and format text blue



Go to special - answer-Ctrl + G



Conditional formatting - answer-Alt + O + D or Alt + H + L



Custom formatting formula syntax - answer-[positive number format; negative number
format, 0 format]



How to out text after a number in custom formatting - answer-Use quote marks