How To Use Excel Beginners

Type a plus sign then use your pointer to select c2 to enter the second cell reference into the formula.

How to use excel beginners. Using cell references in formulas. The formula is completed by pressing the enter key on the keyboard. This will bring up the document in an excel window. Click or double click the excel app icon. This excel for beginners guide teaches you everything you need to know about excel spreadsheets and formulas to perform financial analysis.

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. Formulas in excel always begin with an equal sign. Select cell e1 to make it the active cell and type in the equal sign. To learn how to use a simple keyboard shortcut to set the date and time see use shortcut keys to add the current date time in excel. If you want to open a new spreadsheet click blank workbook.

Use your pointer to select cell c1 to enter the cell reference in the formula. 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. Step 1 install microsoft office if you don t have it. 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. Skip this step if you want to open a new document in excel step 3 open excel.

If you like this video here s my entire playlist of excel tutorials. 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. If you want to open an existing excel document at any time simply double click the document in question. Simple formulas can calculate by adding dividing multiplying or subtracting values from other cells. Http bit ly tech4excel learn the basics of using microsoft excel including the anato.

The equal sign is always typed into the cell where you want the answer to appear. In this basic course excel video tutorial you ll get the.