How To Use Excel Easily

Basic formulas in excel.

How to use excel easily. First you must populate the spreadsheet with data. Type 3 in the cell then press enter on your keyboard. This will bring up the document in an excel window. Instead of typing a1 and a2 simply select cell a1 and cell a2. Skip this step if you want to open a new document in excel step 3 open excel.

How to easily include dynamic dates in a word doc using excel by susan harkins in software on december 1 2020 9 36 am pst microsoft word has a date field but it s not easy to use in an expression. Step 1 install microsoft office if you don t have it. 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. Click or double click the excel app icon.

You can also save your document and email it or use any other cloud service to share it with others. You ll notice several icons in the toolbar at the top of the application in the panel labeled function library once you know how the different functions work you can easily browse the library using those icons. 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. Learn all about excel s lookup reference functions such as vlookup hlookup match index and choose. For example type the formula a1 a2.

Click the share button in the top right corner of the window and excel will walk you through sharing your document. Use index match formulas to pull data from horizontal columns. 6 lookup reference. Excel selects the ribbon s home tab when you open it learn how to collapse and customize the ribbon. Click the formulas tab at the top of the screen.

Follow these steps to get an idea of the type of functions you can use in excel. 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 let excel know that you want to enter a formula type an equal sign. This process activates all the functions or formulas of excel. This is one of excel s most powerful features.