Want to organize all the worksheets in your Excel workbook? Try creating a table of contents. It makes it easy to find ...

Table names must start with a letter, underscore, or backslash, with the remaining characters being letters, numbers, periods ...

How to Make a Regression Table in Excel. Microsoft Excel 2010 comes with an expansion pack called the Analysis ToolPak that includes a number of analylitical tools, like the ability to create a ...

Drop-down lists in Excel let you create a list of valid choices that you can select for a given field. We'll show you how to use tables, named ranges, formulas, data validation, and table styles.

Drop-down lists in an Excel sheet can greatly facilitate data entry. Here's a look at how to use Microsoft Excel's data validation feature to create handy lists within your worksheets.

How to create the PivotChart in Excel At this point, you have a PivotTable that counts the number of invoices per month and by the year. From here, creating the year-over-year PivotChart is easy: ...

Double-click the Excel file containing the data for which you want to create a cumulative chart. Click your mouse cursor on the uppermost cell in one of the columns, and then drag the mouse until ...

Follow these steps to make a Gantt chart in Excel from scratch. Step 1: Create a Project Table Start by entering your project information into the spreadsheet, like you would for more basic ...

As well, you can simply create a chart from an existing pivot table (as you would with any data table in Excel). Quick Tip: Select any cell in a pivot table and click F11.