Comprehensive List of Excel Keyboard Shortcuts

Comprehensive List of Excel Keyboard Shortcuts

Few weeks back I have invited all of you to share your excel keyboard shortcuts in a open thread. More than 50 people commented on that post and shared a hundred excel keyboard shortcuts with us. There were so many wonderful keyboard shortcuts and tricks buried in the comments section of that post. During the […]

Continue »

How do you consolidate data from multiple sheets in to one? [open thread]

How do you consolidate data from multiple sheets in to one? [open thread]

Long time PHD reader and mother of a lovely kid, Michelle, sent me a question in email that provoked me to write this post, I was wondering how to tabulate large amount of information gathered through surveys. Where I work customers are constantly handed survey sheets in order for us to measure how the service […]

Continue »

Excel School Last Call, Closing in Few Hours – Join Now!

Excel School Last Call, Closing in Few Hours – Join Now!

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 :P) How many students have joined the […]

Continue »

Save a ton of time by using Mouse scroll-wheel to Navigate Excel Ribbon

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 […]

Continue »

Excel Links – Winner Takes it all Edition

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 »

Welcome to Pointy Haired Dilbert – Know a Little About YOU

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 […]

Continue »

Only 5 days left, Sign-up for Excel School Today!

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. […]

Continue »