How To Use Excel Formulas Youtube

Learn to create simple formulas and functions in an excel worksheet to download the course materials sample excel files used in the videos and the handouts.

How to use excel formulas youtube. 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. 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. 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. Add formulas to automate.

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. A5 c7 includes a5 a6 a7 b5 b6 b7 c5 c6 and c7. 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. 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.

We ve put together 10 excel formulas you need to get started. You can read it as a1 through a4 you can also use this to include numbers in different columns.