How To Use Excel Beginners

Using cell references in formulas.

How to use excel beginners. The formula is completed by pressing the enter key on the keyboard. This excel for beginners guide teaches you everything you need to know about excel spreadsheets and formulas to perform financial analysis. In this basic course excel video tutorial you ll get the. If you prefer to have the date automatically update every time the worksheet is opened see use today s date within worksheet calculations in excel. Excel formulas can be used to either calculate the value of a single cell or multiple cells as well as use functions to calculate values or retrieve data.

Simple formulas can calculate by adding dividing multiplying or subtracting values from other cells. Watch the video and learn everything a beginner needs to know from what is excel to why do we use and what are the most important keyboard shortcuts functions and formulas. The equal sign is always typed into the cell where you want the answer to appear. If you want to open an existing excel document at any time simply double click the document in question. Step 1 install microsoft office if you don t have it.

Formulas in excel always begin with an equal sign. Here s how to do it starting with the spreadsheet from the examples above. This will bring up the document in an excel window. Microsoft excel isn t available as a standalone program but it is included in a microsoft office package or subscription step 2 open an existing excel document. Type a plus sign then use your pointer to select c2 to enter the second cell reference into the formula.

Skip this step if you want to open a new document in excel step 3 open excel. Select cell e1 to make it the active cell and type in the equal sign. If you want to open a new spreadsheet click blank workbook. Http bit ly tech4excel learn the basics of using microsoft excel including the anato. If you like this video here s my entire playlist of excel tutorials.

Opening a spreadsheet when you first open excel by double clicking the icon or selecting it from the start menu the application will ask what you want to do. Click or double click the excel app icon.