Microsoft Excel is a spreadsheet application that you can use to record data, make calculations and create charts. In this article I’ll introduce you to the basics of working in Excel. We’ll look at ...

Excel displays the location of your cursor each time you place it in a cell: Columns are identified by letters, and rows by numbers. Create labels that help you identify the data in your worksheet.

Creating a Pie Chart Launch Excel and open a new worksheet. Create a basic spreadsheet with text labels in the first row and/or first column of the worksheet.

Worksheet Data Areas Creating a data area for a worksheet is a simple and very effective way of tracing the data that you’re using. To do this, take out all the known constant values such as tax rate, ...

If you want to create multiple worksheets in multiple Excel workbooks, you can set the default number of worksheets when you open Excel.

Excel macros increase productivity and save time when creating a complex workbook or worksheet. Even if you start with some of the best Microsoft Excel templates, adding macros simplifies using ...

If you have a number of Microsoft Excel worksheets that contain related data, you'll likely need to create a report that consolidates and summarizes the data. If those worksheets are laid out ...

Whichever method you use to create the table, Excel will open a new worksheet with the table in it. If you like, you can copy it into the original data sheet as I did in the screenshot.

With the help of a simple function, Excel's Conditional Formatting feature can save you time and effort. Here's an easy way to flag formulas in your worksheets.