The final adjustment you should make in the Table Design tab is to give your table a name. By default, Excel tables are called Table1, Table 2, Table3, and so on. However, changing the table name ...

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 ...

Show users how to create a quick table of contents in Excel using the power of hyperlinks.

Dana Miranda is a Certified Educator in Personal Finance, creator of the Healthy Rich newsletter and author of You Don't Need a Budget: Stop Worrying about Debt, Spend without Shame, and Manage Money ...

Step-by-step tutorial on creating an analytical dashboard in Excel that updates automatically using a pre-designed template or from scratch.

In Microsoft Excel 2010, you can create large tables in which to store your data and then use it in formulas and store the results in the same table. You can insert and calculate almost anything ...

Is your chart boring? Try Excel’s people chart to liven things up. Susan Harkins shows you how. A people chart is an infographic, which leads me to a second definition. An infographic tells a ...

Drop-down lists in Microsoft Excel (and Word and Access) allow you to create a list of valid choices that you or others can select for a given field. This is especially useful for fields that require ...