Download Excel Formulas 140 Excel Formulas and Functions with usage and examples by Vijay Kumar easily in PFF format for free.
Thanks for downloading this book. Excel is part of the Microsoft Office suite and the world’s most widely used spreadsheet application used by Millions. Compared to other Spreadsheet programs Excel is very feature rich and popular and incorporated with so many built in Formulas and Functions. Even if you don’t know the function name you can simply search the word you think related to a formula in the insert function box and you will get back the Formulas related to that word.
This book provides more than 140 Formulas and there use with examples for you to understand and use it in your day to day work. Please keep in mind some of the new functions will not work in your Computer if you are using previous versions of Excel. Formula can be entered in Excel by first entering the equal sign (=) followed by the formula name like this =SUM(A1:A100), opening and closing brackets are compulsory.
As in the above example if you rewrite the formula to =SUM($A$1+$B$1) and if you copy down the formula the cell reference will not change relatively it will always get the sum of A1 and B1 wherever you paste the formula in the sheet. By pressing the F4 key you can easily insert the dollar sign and if you keep on hitting the F4 key the reference will change to mixed and to relative. A mixed reference has either an absolute column and relative row, or absolute row and relative column in a formula.