Below you will find many Excel formula examples for key functions like VLOOKUP, INDEX, MATCH, IF, SUMPRODUCT, AVERAGE, SUBTOTAL, OFFSET, LOOKUP, ROUND, COUNT, SUMIFS, ARRAY, FIND, TEXT, and many more.

 
 
 
 
 
Click on any Excel formula link below and it will take you to the free example tutorial & downloadable Excel workbook for you to practice!

3D 

And

Array 

Array, Lookup 

Average 

Between 

Chart 

Clean 

Concatenate 

Convert, Values 

Count 

Data Cleansing, Trim 

DateDif 

EndOfMonth 

Evaluate 

Extract, Find, Left 

Filter

FV 

Find & Select 

Hlookup 

If 

If, And 

Iferror 

Iferror, Vlookup 

Index 

Index, Match 

Indirect 

Left 

Len, Length 

Match 

Mathematical Formulas 

Mod 

Multiple Criteria, Vlookup 

Offset 

Percentage 

Pivot Table, GetPivotData 

Proper 

Rand 

Randbetween 

Reference 

Sort 

Sortby 

Substitute 

Substitute, Trim 

Subtotal 

Sum, Lookup 

Sumifs 

Sumproduct 

Text 

Time 

Transpose

Type

Upper

Unique

Value

Vlookup 

Weekday 

Weeknum

Workday 

Year

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Related Excel Tutorials

Leave a Comment

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

  • Thanks. I just found all the solutions to my practical assignment on excel from your website.It’s just a perfect one,……..

    • Hi Frederick,

      I’m sure you’ll do great on your exam! Just keep on rocking with Excel formulas!

      Regards,
      Bryan

  • Hi. I have a formula I’m trying to phrase in an Excel format. Solving for X: On paper, it should look like

    2145000000=”X”*(500+(“X”/2))

    The result will return as 65000

    • Hi Jay,

      That’s going to result in a quadratic equation. Your answers should be X = 65000 and X = -66000

      Regards,
      Bryan

    • Hi Dhitosh, could you explain more what kind of grading sheet do you want to create? I can help sort out which Formulas you can use.

    • You are welcome Merzouk and feel free to share this comprehensive formula post with your friends & colleagues!

      Cheers,
      John

    • You are welcome Pradeep! Feel free to share this great resource with your friends & colleagues.

      Cheers,
      john

    • Hey Judicaél,

      This training will make you an Excel expert in a very short time 🙂

      Let me know if you have any questions, I’m here to help ?

      Cheers,
      John

    • Hey Bidhan,

      Yes this free Excel formula guide is a must for anyone starting to learn Excel formulas!

      Thanks,
      John

    • You are welcome Josefina!

      Feel free to share this post with your friends & colleagues 🙂

      Thanks,
      John

    • You are welcome Rafat and I hope you enjoy all these great Excel formulas!

      Cheers,
      John

    • Glad you liked these free Excel Formula Examples! Keep on EXCELling Bhaashyyam 🙂

      Cheers,
      John