You have successfully created a database and table in SQL Server, inserted sample data, and used Microsoft Excel to load, analyze, and visualize the data using a Pivot Table and Pivot Chart.

The Power of Multi-Sheet Pivot Tables Creating pivot tables from multiple sheets in Excel significantly enhances your data analysis capabilities.

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.

What is a Pivot table? A Pivot table is a data analysis tool that people can create in Excel. It is typically used to share information as it can sort, group, reorganize, count, summarize, average, or ...

When you work with spreadsheet data in a standard table or pivot table, you may want to view only particular data. You can use Excel’s built-in filter feature; however, the options can be limiting as ...

Confirm the range encompasses the data you want to use in your pivot table. Choose whether to insert the table on a new sheet or in the current one. Select New sheet to make a cleaner presentation.

Learn how to use Excel pivot tables to QA bulk sheets, plus some tips and shortcuts to enhance your pivot table skills.

Want to perform powerful data analysis and create complex data models in a spreadsheet? Learn how to use the Power Pivot feature in Excel.

Need to know your organization's YOY results? Susan Harkins will show you how to make a PivotChart in Microsoft Excel.