Basic Excel Formulas → The Only Guide You Need to Start New to Excel or just want to refresh your memory? These formulas are the building blocks of every spreadsheet. → SUM Add values easily: =SUM(A1:A5) Or manually: =(A1+A2+A3...) → PRODUCT Multiply numbers fast: =PRODUCT(B1:B3) Or =(B1*B2*B3) → SUBTRACT / DIVIDE / PERCENTAGE Quick math on cells: =(E3-E4) → Subtract =(F3/F4) → Divide =(G3/G4*100) → Percentage → MAX / MIN / AVERAGE Get insights instantly: =MAX(H3:M3) → Highest value =MIN(H3:M3) → Lowest value =AVERAGE(C3:C14) → Mean value → COUNTING FUNCTIONS =COUNT(C4:P4) → Count filled cells =COUNTBLANK(C3:C16) → Count blanks =COUNTIF(D4:Z4, "P") → Count conditions → DATE & TIME =NOW() → Date + Time =TODAY() → Today’s date =DAY(NOW()) → Day of the month =MONTH(NOW()) → Current month =YEAR(NOW()) → Current year → EXTRAS =POWER(2,4) → 2⁴ = 16 =SQRT(25) → Square root = 5 ⤷ Save this post ⤷ Practice in real sheets ⤷ Build better dashboards faster Image from: Pinterest ______________ Discover the best @Office Productivity Hacks right here. Follow for the tips and tricks you need. | 40 comments on LinkedIn