Want to organize all the worksheets in your Excel workbook? Try creating a table of contents. It makes it easy to find specific sheets, especially if your Excel file contains hundreds of them.

To create a table in Excel, go to the Insert tab on Excel’s Ribbon toolbar and select Table. The Create Table pane will pop up asking you to select the data you want to include in the table.

When you have a massive Excel workbook overflowing with data, trying to make sense of it can feel like a tough task at times. Be it sales data, client names, product segments, dates, or geographical ...

To use the keyboard to select an entire table, click anywhere in the table and, with Num Lock off, press [Alt]5 on the numeric keyboard. Like Excel, Word XP and Word 2003 also let you press [Ctrl ...

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.

Select cells E3:L16. Go to Data, click the dropdown arrow next to What-if Analysis within the Forecast group, and choose Data Table. The Data Table window will open, asking for inputs into Row input ...