Tutorial by Examples

By selecting a matrix and choosing "Insert Table" from the menu, you create a table which allows you to pull and insert data in a structured way. Let's say you have named the table "SalesEvents" and given that the first (header) row reads "Salesperson" "Date" ...

When you have an Excel Table, and not only then, it is easy to use data as input in a PivotTable which will provide most of the analysis you would need on it. Learn to use it you won't regret it! It could replaces tons of user designed cell Formulas and it is fast and much easier to document.

Sometimes it is hard to make all the data of your Pivot Table confirm to the reporting format you have to present your crunched data into. Then use GetPivotData! It has an automatic fill in of arguments that you easy can learn from and it lets you through its parameters flexibly choose and pick from...

Here are some basic best practices for Excel: Flat File Database - Excel IS a Flat File application and should be treated as such Less Worksheet/Workbooks is more. Analyzing will be much faster with fewer worksheets/workbooks to go through. Try to ensure that all raw data is on one workshe...