Basics of Excel

• Excel is an incredibly powerful tool for getting meaning out of vast amounts of data.
• But it also works really well for simple calculations and tracking almost any kind of information.

How to Start the Excel

• To start Excel application, follow the following steps at your PC:
• Step 1: Click on start button.

• Step 2: Click on All apps.

• Step 3: Click on Microsoft Office 2013.

• Step 4: Select Excel 2013.

• Step 5: Click on Blank workbook.

• This will launch Microsoft Excel 2013 application and you will see the following Excel window.

Create a new workbook

• Excel documents are called workbooks. Each workbook has sheets, typically called spreadsheets.
• You can add as many sheets as you want to a workbook, or you can create new workbooks to keep your data separate.

• Click on FILE tab.

• Click New > Blank workbook.

Enter your data

• Click an empty cell. For example, cell A1 on a new sheet.
• Cells are referenced by their location in the row and column on the sheet, so cell A1 is in the first row of column A.
• Type text or a number in the cell.
• Press Enter or Tab to move to the next cell.

Use AutoSum to add your data

• When you’ve entered numbers in your sheet, you might want to add them up. A fast way to do that is by using AutoSum.
• Click FORMULAS > AutoSum or press Alt+=.

• Press Enter.

Edit your data

• Before editing the data select the data first, click on where you select the data and drag the cursor or press Ctrl+A.

• If you want change the font style click HOME see font group and select font style.

• If you want change the font size click HOME see font group and select font size.

• If you want change the font color click HOME see font group and select font color.

Save your workbook

• Click the Save button on the Quick Access Toolbar, or press Ctrl+S.

• Under Save As, pick where to save your workbook, and then click Browse.

• In the File name box, enter a name for your workbook. Click save to Finish.

Print

• Click FILE > Print, or press Ctrl+P.