How To Use Excel Formulas Youtube

Some formulas of excel are so useful that almost every excel user should know them guruji makes a list of 10 most used excel formulas for you.

How to use excel formulas youtube. Excel formulas make calculating numbers and making sense of large amounts of data simple by knowing a few key formulas you can do a variety of actions in excel that will increase your productivity and decrease the risk of making calculation mistakes. You can read it as a1 through a4 you can also use this to include numbers in different columns. If you just want to open a new blank excel document click the blank option in the upper left side of the page and then skip the next step. In the formula above we used a1 a4 to tell excel to look at all the cells between a1 and a4 including both of those cells. Excel formulas can also be developed using cell references continuing with our example you would not enter the numbers 3 and 2 but instead would name cells where these numbers have been entered see using cell references below for more on cell naming when you write a formula this way the formula cell always shows the sum of the numbers in those cells.

There are a lot of complicated formulas out there but a great formula doesn t. If you want to use an excel template e g a budget planner template scroll down until you find the template you want to use and then click it once to open its window. A5 c7 includes a5 a6 a7 b5 b6 b7 c5 c6 and c7. Check below how to set up a very basic spread sheet if you re really new to excel you might want to check out my really basic video before this one it h. Improve formulas with cell references.

Then use the borders tool on the workbook s home tab looks like a square divided into four and choose all borders to make it even easier to read you can also shade a few areas. To make your excel budget look a little cleaner select the entire section.