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 […]
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 […]
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 […]
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. […]
What is the most useless feature in Excel? [poll]
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 […]
Group Project Activities to Make Readable Gantt Charts
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 […]
Preparing Profit / Loss Pivot Reports [Part 2 of 6]
This is part 2 of 6 on Profit & Loss Reporting using Excel, written by Yogesh Data sheet structure for Preparing P&L using Pivot Tables Preparing Pivot Table P&L using Data sheet Adding Calculated Fields to Pivot Table P&L Exploring Pivot Table P&L Reports Quarterly and Half yearly Profit Loss Reports in Excel Budget V/s […]