Quick Tutorial On Using Excel

This tutorial gets you started with microsoft excel without going overboard with jargon and technical terms.

Quick tutorial on using excel. Step 3 search for microsoft office from the sub menu and click it. This course is for absolute beginners who would like to get the gist of excel and how its used to analyze data. 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. Rows are designated with numbers 1 2 3 etc shown along the left side of the spreadsheet while columns are designated with letters a b c etc shown along the top.

It begins with things like formatting cells locating ribbons and workbooks and using keyboard shortcuts to speed up the editing process. More tutorials to follow that will go into more detail on h. A workbook is another word for your excel filewhen you start excel click blank workbook to create an excel workbook from scratch. Use excel table functions to de duplicate data and make totals.

Create a simple sales analysis report. Step 2 click on all programs option from the menu. Httpbitlytech4excel learn the basics of using microsoft excel including the anato. When entering the data for this tutorial it is important to enter the data into the correct worksheet cells.

Excel selects the ribbons home tab when you open itlearn how to collapse and customize the ribbon. Assuming you have microsoft office 2010 installed in your pc start the excel application following the below mentioned steps in your pc. To follow this tutorial use the cell references of the data seen in the image above to enter all the data into a blank excel worksheet. A quick look at setting up a simple spreadsheet in excel complete with a chart.

A worksheet is a collection of cells where you keep and manipulate the dataeach excel workbook can contain multiple worksheets. The excel easy website. Formulas entered in subsequent steps make use of the cell references of the data entered now. If you like this video heres my entire playlist of excel tutorials.

To refer to a cell use the column letter and row number together such as a1 or w22 the column letter always comes first. Step 1 click on the start button. If you want to open a new spreadsheet click blank workbook.