How To Use Excel Microsoft

Click the home tab at the top of the screen and select cell styles choose a cell color and font color from the options.

How to use excel microsoft. Combine cells using andpersand. This tells excel to select the entire row for you. To multiply use the sign. Use dollar signs to keep one cell s formula the same regardless of where it moves. To divide use the 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. However you cannot edit the data to change the source data through the excel user interface. From the spot where you are excel will insert the row above that. To start the process click on the row number that you want to be below the new row. Click or double click the excel app icon.

Use vlookup function pull data from one area of a sheet to another. This is a basic excel tu. Use if then excel formula to automate certain excel functions. For example consider how 10 10 10 is different than 10 10 10. 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.

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. Use index match formulas to pull data from horizontal columns. You do so by right clicking and choosing insert rows. In this video i am using the 2013 version but they are basically the same.

You can also save your document and email it or use any other cloud service to share it with others. To use exponents use the sign. Use countif function to make excel count words or numbers in any range of cells. You can use excel to connect to a wide variety of data sources including access sql server and analysis services databases text and xml files and odbc and ole db data sources. The easiest way to share your spreadsheets is via onedrive.