NB: There are Video Tutorials supporting this eBook. Links to video tutorials are there inside this eBook!

In Excel 2007: Pivot Tables for Data Analysis, Microsoft Most Valuable Professional Cortés Farey helps dispel the common fear of the Pivot Table feature, by demonstrating how to use this powerful tool to discover valuable business intelligence. Cortés shows how to create Pivot Table reports from internal Excel data and outside data sources, use filters to focus on the most important data in the sheet, and make visual presentations of data using Pivot Chart reports. Exercise files accompany this course.

Topics include:

This course will show you how to use pivot tables to make sense of your organization's data. I will begin by showing you how to create a pivot table from data already in your Excel workbooks. Then, using that knowledge as a base, I will demonstrate how to create pivot tables using data from an external source. We will enhance your ability to analyse your data by showing how to reorganize or pivot a pivot table.

After you have organized your pivot table's data you can sort the data to show relative importance and relevance or create filters that enable you to focus on that data you need to develop useful insights into your business. This course will show you how to create conditional formats that highlight subsets of your data and to visualize your data using dynamic charts called pivot charts that are based on your pivot table data. In short, I will show you how to summarize and analyse data using one Excel's most powerful and overlooked features.

The skills acquired from this version are mostly applicable to newer versions of Excel.

If you think that Microsoft Excel is only for business purposes, you are wrong. Many use it for various personal needs at home too. Some of the features that you should understand about Microsoft Excel to unlock the potentiality of this application are working with spreadsheets, cell formatting, various menus and toolbars, entering of data and editing the same, navigating between various spreadsheets, formula calculation, inserting various functions like date/time, mathematical functions, using of various charts that are available, inserting, editing and deleting comments on cells, etc.

Computer Based Training (CBT) is a way to master MS Excel. This is where you take your own time to master the application. With the help of CBT, you get realistic, interactive and complete training. You get to learn right from what a beginner should learn to advanced level. Once the training is over, you would have mastered Microsoft Excel. You get to see simulations of Microsoft Excel application software. Some CBT also offer review quiz questions to gauge your understanding. CBT generally offer interactive, complete and comprehensive training. As it offers practice questions, you will be able to understand better and gain confidence in using the application. According to me, this is one of the best ways to learn Microsoft Excel.

The concept of spreadsheeting has been around for hundreds of years. The process can be described as the ability to arrange numbers, characters and other objects into rows and columns. It is most...