How To Use Excel Easily

Click or double click the excel app icon.

How to use excel easily. Basic formulas in excel. Excel automatically recalculates the value of cell a3. Learn all about excel s lookup reference functions such as vlookup hlookup match index and choose. Excel has many functions to offer when it comes to manipulating text strings. How to use basic formulas in excel.

This process activates all the functions or formulas of excel. This is one of excel s most powerful features. Use dollar signs to keep one cell s formula the same regardless of where it moves. Type 3 in the cell then press enter on your keyboard. Use vlookup function pull data from one area of a sheet to another.

Cell c2 should be selected. A worksheet is a collection of cells where you keep and manipulate the data each excel workbook can contain multiple worksheets. Click the share button in the top right corner of the window and excel will walk you through sharing your document. 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.

Use index match formulas to pull data from horizontal columns. Use countif function to make excel count words or numbers in any range of cells. Excel selects the ribbon s home tab when you open it learn how to collapse and customize the ribbon. To enter a time use the colon. 4 date time.

Skip this step if you want to open a new document in excel step 3 open excel. First you must populate the spreadsheet with data. If we want to insert a formula in excel then we need to get into the edit mode of the cell where we want to apply and then type equal sign. To enter a date in excel use the or characters. Excel has a variety of formulas and functions.