Want to know how to use the 5 Most Used Excel Formulas and Functions?
*** Watch our video and step by step guide below with free downloadable Excel workbook to practice ***
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.
DATE & TIME
DateDif
EndOfMonth
Time
Weekday
Weeknum
Workday
Year
LOGICAL
And
If
If, And
Iferror
LOOKUP
Array, Lookup
Hlookup
Iferror, Vlookup
Index
Index, Match
Indirect
Match
Multiple Criteria, Vlookup
Offset
Pivot Table, GetPivotData
Sum, Lookup
Vlookup
MATH
Average
Count
CountA
CountBlank
CountIf
CountIfs
Mathematical Formulas
Mod
Percentage
Rand
Randbetween
Round
Subtotal
Sumifs
Sumproduct
OTHER
3D
Array
Chart
Convert, Values
Evaluate
Find & Select
FV
Reference
Show, Hide
Transpose
Type
Value
TEXT
Between
Clean
Concatenate
Data Cleansing, Trim
Extract, Find, Left
Left
Len, Length
Proper
Remove
Remove, Substitute
Replace
Replace, Cleanup
Right
Substitute
Substitute, Trim
Text
Upper
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
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
Thanks. I just found all the solutions to my practical assignment on excel from your website.It’s just a perfect one,……..

Hi Lanford,
Keep on Excelling!
Kind Regards,
Bryan
Well done, great job.

Hi Farhan,
Keep on Excelling! Thanks for dropping by.
Regards,
Bryan
its very helpful in my CA training period thanks for provide such worksheet

Hi Abhishek,
Glad it’s helpful to you! Keep on rocking with Excel Formulas!
Regards,
Bryan
helps me a lot. improve my excel. one of the reason i’m fail in exam from the job i applied. i got lucky that i found this things. thank you so much.
god bless you and more power.

Hi Frederick,
I’m sure you’ll do great on your exam! Just keep on rocking with Excel formulas!
Regards,
Bryan
Very helpfull article bro thx for a giving this type of informative information.

Hi Subhendu,
You’re more than welcome, and keep on Excelling with Excel!
Kind Regards,
Bryan
It’s very helpful.

Hi Marek,
Thanks for your kind words. Keep on Excelling!
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
i wants to learn.

Hi Shivaraj, you can learn more about Excel formulas here: https://www.myexcelonline.com/category/formulas/
We will help you become a master of Excel in no time!
Very nice

Hi Subhash, thank you for dropping by! Hope you have learned more about Excel Formulas.
Excellent very easy to understand

Hi Aseena, agreed, Excel formulas are easy to understand and very useful in your professional career!
Advance excel

Hi Sanjay, we have a lot more Advanced Excel formula tutorials here: https://www.myexcelonline.com/category/formulas/
Looking forward to do it.

Hi Samrat, let us know how it goes for you!
Superb

Hi Baldev, I agree, Excel Formulas are definitely superb!
Awesome its very simple to learn

Hi Somasekhar, glad the formulas were helpful to you! Keep on getting better in Excel!
Sir I want to learn financial formulas in excel how we use in excel

Hi Narasimhareddy, we have a lot of financial formulas post. Here is one of them that can help you: https://www.myexcelonline.com/blog/calculatemonthlyinvestmentexcelsfvformula/
Very useful!

Hi Mahesh, you’ll find a lot more useful Excel formulas here. Thank you!
Excel formulas mark sheet grade code

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.
Excellent, and amazing excel and very easy to understand.

Thanks for your feedback Jaya, I appreciate it 🙂
Cheers,
John
Excellent, and amazing excel and very easy to understand.
very very big Thanks to u DEAR.

You are welcome Jaya, keep on EXCELling!
Cheers,
John
Thanks so much

You are welcome Merzouk and feel free to share this comprehensive formula post with your friends & colleagues!
Cheers,
John
Thanks

You are welcome Pradeep! Feel free to share this great resource with your friends & colleagues.
Cheers,
john
Thank you

You are welcome and I hope that you learn lots of new Excel formulas here!
Cheers,
John
I need This training

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
this program is very useful to excel learners

Hey Bidhan,
Yes this free Excel formula guide is a must for anyone starting to learn Excel formulas!
Thanks,
John
thanks

You are welcome Josefina!
Feel free to share this post with your friends & colleagues 🙂
Thanks,
John
thanks

You are welcome Rafat and I hope you enjoy all these great Excel formulas!
Cheers,
John
Nice

Glad you liked these free Excel Formula Examples! Keep on EXCELling Bhaashyyam 🙂
Cheers,
John