How To Use Excel Easily

First you must populate the spreadsheet with data.

How to use excel easily. Change the value of cell a1 to 3. Basic formulas in excel. Click the share button in the top right corner of the window and excel will walk you through sharing your document. Step 1 install microsoft office if you don t have it. Type 3 in the cell then press enter on your keyboard.

Open a new excel file and select cell c1 to make it the active cell. For example type the formula a1 a2. A worksheet is a collection of cells where you keep and manipulate the data each excel workbook can contain multiple worksheets. Use vlookup function pull data from one area of a sheet to another. Use index match formulas to pull data from horizontal columns.

Basic formulas in excel. Click the formulas tab at the top of the screen. Use countif function to make excel count words or numbers in any range of cells. This will bring up the document in an excel window. This is one of excel s most powerful features.

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. Excel has a variety of formulas and functions. A workbook is another word for your excel file when you start excel click blank workbook to create an excel workbook from scratch. This process activates all the functions or formulas of excel. To enter a time use the colon.

Cell c2 should be selected. Instead of typing a1 and a2 simply select cell a1 and cell a2. Excel automatically recalculates the value of cell a3. Learn all about excel s lookup reference functions such as vlookup hlookup match index and choose. You can also save your document and email it or use any other cloud service to share it with others.