SubscribePivot Table Tricks to Make You a Star
|
We, data junkies, love pivot tables. We think pivot tables are solution for everything (except for may be global warming and that broken espresso machine down stairs). Today, we are going... Continue » |
If excel school were to be a bar, this post is your last call. Come one, come all and order the course now.
Click here to sign-up for excel school
(on a lighter note, if excel school were to be a pie, we wouldn’t be having this conversation )
How many students have joined the school?
At the [...]
Save a ton of time by using Mouse scroll-wheel to Navigate Excel Ribbon
Today’s quick tip is by far the quickest and most profitable tip of all.
To switch between ribbon tabs or to change to a particular tab, you can use mouse scroll-wheel. Just place mouse pointer on a ribbon tab, and scroll-down or up using your mouse’s scroll-wheel and you can switch between tabs.
Learn more ribbon tips, [...]
Continue »Remember the Sales Visualization Challenge? We got 32 extremely good dashboards submitted and finally you voted Alex Kerin’s entry as the winner. So when I informed Alex that he is the winner, I also asked him to send me a pic of him with the iPod Touch that he won. Yesterday, he sent it to [...]
Continue »Hello dear reader, Welcome to Pointy Haired Dilbert.
Know a little about yourself. Read this,
You are awesome. You want to learn excel, become better at charting. You like to experiment with excel and see what more you can do with it. You want to be better at your work. Excel plays a major role in that [...]
A quick update on Excel School before you start your weekend. So far Excel School – online excel training program has been very well received by our members at PHD.
How are the registrations so far?
We have 44 students in the classroom. Every day I am hearing from people who are willing to join.
We have guest [...]
Continue »![What is the most useless feature in Excel? [poll]](http://chandoo.org/img/l/surface-charts-excel-whats-the-point.png)
What do you think is the most useless feature in MS Excel?
I know there are a ton of cool, extremely useful features in excel. But it also comes with a few really un-necessary features.
For me, the most useless feature seems to be a 3D surface chart. I have tried to figure why this is used, [...]
In Excel Gantt Charts part of our project management series, we have discussed about how using Conditional Formatting and Formulas we can make a gantt chart like this:
But when you have large project plans, gantt charts like above can get pretty intense and hard to read. So a better approach is to group various tasks [...]
Continue »
At Pointy Haired Dilbert, I have one goal, "to make you awesome in excel and charting". PHD is started in 2007 and today has 300+ articles and tutorials on using excel, making better charts. 
