Category Archives for "Pivot Table and PowerPivot"

Top 29 Pivot Table Tips

Excel , Pivot Table and PowerPivot , Top Tips

It is easy to say that Pivot Tables and Power Pivot are the two most powerful features in Excel. I don’t mean time saving as with Excel VBA macros, but rather they are powerful because the decisions made from Pivot Table (and Power Pivot) results drive key business decisions. I’ve built tons of Pivot Tables […]

Continue reading

PowerPivot and Power View for Excel 2013

Analysis , Charts , Dashboards , Excel , Pivot Table and PowerPivot

If you are using PowerPivot for Excel 2010, then click here. The following collections of links and resources will help you go from short video overviews of PowerPivot and Power View capability to being fairly proficient. Video Overview of Excel 2013 PowerPivot and Power View Here’s a collection of short videos from Microsoft on Excel […]

Continue reading

Excel 2010 PowerPivot

Analysis , Charts , Dashboards , Excel , Pivot Table and PowerPivot

To learn more about PowerPivot and PowerView for Excel 2013, click here. If you have Excel 2010 you have access to Power Pivot, but not Power View. Just the capabilities of Power Pivot make it an extremely powerful tool that any power Excel user has to be familiar with. The ribbon has slight differences from […]

Continue reading