AMAZON

Friday, 9 December 2016

You Don't Know Formula In Excel Read This Article

Excel Formulas Free 

Finding The Right Excel Formulas For The Job
There are 316 built in functions in Excel. You’re not going to sit there and memorize what all of them do (or at least I hope not!). Luckily Excel has a built in wizard that helps you find the correct formula for what you’re looking to do (if there is one).

Click the “fx” next to the formula bar in Excel
See The Image Bellow

This brings up a menu and in there you can type in a description of what you are trying to do and it will bring up the correct excel formula:


I typed in “remove extra spaces” and it returned the TRIM formula that we went over earlier.

No comments:

Post a Comment