How To Use Excel Beginners

Using cell references in formulas.

How to use excel beginners. This is a microsoft excel 2019 basic tutorial for beginners that includes excel office 365 skills. 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. This excel for beginners guide teaches you everything you need to know about excel spreadsheets and formulas to perform financial analysis. 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. Simple formulas can calculate by adding dividing multiplying or subtracting values from other cells.

Skip this step if you want to open a new document in excel step 3 open excel. 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. 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. 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.

Formulas in excel always begin with an equal sign. If you want to open a new spreadsheet click blank workbook. Click or double click the excel app icon. In this basic course excel video tutorial you ll get the. Type a plus sign then use your pointer to select c2 to enter the second cell reference into the formula.

This will bring up the document in an excel window. The formula is completed by pressing the enter key on the keyboard. Here s how to do it starting with the spreadsheet from the examples above. 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. 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.

Use your pointer to select cell c1 to enter the cell reference in the formula. Select cell e1 to make it the active cell and type in the equal sign.