Learn basic Microsoft Office - Excel, World, Power Point, Outlook, One Drive, One Note
Educate yourself with our database tutorials which provide a step-by-step knowledge. The basic and advanced topics.
Currently we are learning about Excel in this Post - I know the Formulas is critical for beginners to become highly proficient in financial analysis.
What are Excel Formulas?
There exist 400+ functions in Excel, and the number is growing by version to version. Of course, it's next to impossible to memorize all of them, and you actually don't need to. The Function Wizard will help you find the function best suited for a particular task, while the Excel Formula Intelligence will prompt the function's syntax and arguments as soon as you type the function's name preceded by an equal sign in a cell:
Excel formulas help you to identify relationships between values in the cells or in a range of cells of your spreadsheet, perform mathematical calculations using cells and values entered in those cells, and return the resulting value in to the defined cell of your choice. You can automatically set the formula for perform result for any - sum, subtraction, percentage, division, average, and even dates/times.
There are 400+ functions available in Excel, and the number of functions is increasing day by day by new versions.
Yes, It's impossible to remember all the formulas, and you actually don't need to. The Function Wizard will help you to find the function and also guide you about the function below of Function Wizard.
We'll go to learn many more points in this blog post.
List of Formula is given below :-
1. SUM
Details related to formula - SUM are given in URL - https://free-tips-free-tricks.blogspot.com/2021/05/micro-soft-excel-formula-sum.html
Above mentioned URL - I have already mention the image with text & also attach a Video with all details in my Voice also.
2. IF
3. AVERAGE
4. COUNT
5. VLOOKUP
6. DATE
7. DAY
8. MONTH
9. YEAR
10. TODAY
3. AVERAGE
4. COUNT
5. VLOOKUP
6. DATE
7. DAY
8. MONTH
9. YEAR
10. TODAY
Don't worry, if you have any issue then please call me me or text me at whatsapp or at the comment box, I am always available at phone calls & through comments.
You can contact me through call at my mobile number - 9336493363 or through whatsapp / Twitter / Instagram.
I am always available for help.
It's a request to please sent me a comment with your valuable remarks in comment box, for improvement.


0 comments:
Post a Comment