Basic tasks in Excel 2013

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. The key for unlocking all that potential is the grid of cells. Cells can contain numbers, text or formulas. You put data in your cells and group them in rows and columns. That allows you to add up your data, sort and filter it, put it in tables, and build great-looking charts. Let’s go through the basic steps to get you started.

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.

Create a simple formula

Adding numbers is just one of the things you can do, but Excel can do other math too. Try some simple formulas to add, subtract, multiply or divide your numbers.

Pick a cell and type an equal sign (=). That tells Excel that this cell will contain a formula.

Type a combination of numbers and calculation operators, like the plus sign (+) for addition, the minus sign (-) for subtraction, the asterisk (*) for multiplication, or the forward slash (/) for division.

For example, enter =2+4, =4-2, =2*4, or =4/2.

Press Enter. That runs the calculation.

You can also press Ctrl+Enter if you want the cursor to stay on the active cell.