Learn Excel Formulas in Minutes

Master the Basic Structure:

All formulas start with =

Example: =SUM(A1:A10)

Learn These Essential Formulas First SUM() for Adding Adds numbers

AVERAGE() for Calculates mean

COUNT() to Counts numeric cells

IF() for Simple conditional logic

Formula:
for example:

=IF(B2 > 20000,”Cross”,””)

Count if()  to Counts numeric cells by conditions

Use Formula AutoComplete

Start typing =SU and Excel will suggest SUM

Just for example that how to implement sum formula:

Press Tab to accept the suggestion

Learn Common Operators

+ Addition

– Subtraction

* Multiplication

/ Division

& Text concatenation
Formula:
=A2 & ” – ” & B2
It will combine text by hyphen – as shown in image

Hope you liked it! Thanks for reading till the end. We’ll meet again in the next exciting topic.

For premium Excel services at affordable prices with guaranteed quality, visit our website:
www.irfanai.com

Leave a Reply

Your email address will not be published. Required fields are marked *