Pivot Tables are a great tool for manipulating your data but when it comes to choosing which data source you want to manipulate the list is almost endless, especially with any flat text file, and yes, WITHOUT VBA! Here is a cheat sheet to get you started!
Coming from a SQL programming background you might find it difficult trying to adapt the AND / OR operators to your Excel formulas, so here is a method that I use to solve this problem.
Here is a quick tip on how to change the order of your series from an Excel chart.
After playing around with Excel and PowerPoint 2007, I was very impressed at the way you can format your objects to look very Web 2.0ish, but as I use 2003 at work a lot I wanted to see if I could replicate this.
Here is a quick tutorial on how to change your objects in an Excel 2003 worksheet or PowerPoint 2003 presentation into Web 2.0 style objects.
This is a quick tutorial on how you can populate the blank row area cells which are created by a Pivot Table.
Can’t perform any date formatting on a cell because Excel doesn’t recognise its contents as an ‘actual’ date? Using the DATE() formula can help you convert a text field to a date field!
Just like Access can create a linked Table to a text file, Excel can do the same using a very quick and simple method.
This tutorial will look at building an interactive (drag and drop, filter etc.) Pivot Chart into your PowerPoint presentation using Microsoft Office Web Components.
Related : Building a Pivot Table into your PowerPoint presentation
In this tutorial I will go through how you can link a Pivot Table in Excel to a PowerPoint presentation. I suggest you read a post I did earlier which is a good 101 on linking between Excel and PowerPoint.
Related Posts :
Ranking with Pivot Tables is a hidden feature and is a extremely helpful when performing ad hoc analysis, this tutorial goes through a step by step guide on how to rank with Pivot Tables.
Recent Comments