Here is a very quick, very short excel tip. Add the “select objects” tool to Quick Access Toolbar.
In excel 2003 and earlier, this button is available in the bottom left corner (on the drawing toolbar) so that whenever you are working with charts or drawing shapes, you could easily select multiple objects and drag, [...]

In this and next 3 posts, we will learn how to make a Dynamic Dashboard using Microsoft Excel.

At the end of this tutorial, you will learn how easy it is to set up a dynamic dashboard using excel formulas and simple VBA macros.

As some of you know almost 10 days back I left Denmark and came back to India. I had to come back because of visa and personal issues. For the next 6 months PHDs will be based out of India and working from home. While this gives me a lot more time, I will be [...]

In October 2008, I have started an ambitious series of posts on this blog called – Spreadcheats. These are little tricks, nuggets, tutorials on using Excel that would make anyone a spreadsheet guru.

The spreadcheats series has been wildly successful. I am compiling all this useful information and articles in to one big post so that anyone can follow the links and become good in Excel. Read on,

[Note: This is not for beginners. If you know what a formula is, you would enjoy this 31 articles]

I have a new community project for all the members of PHD. It is a simple yet intuitive challenge. Make your own country’s flag using Excel Charts. To start the project, I have made the Indian flag using a bar and pie chart. Go ahead and see the rest of this post to findout how this chart is made and then participate in the “flag project” by making your own country’s flag. All the best.

Some of you know that I sell a bundle of Project Management Excel Templates. The bundle includes 24 ready to use templates for Gantt Charts, Timesheets, Project Dashboards, Status Reports, Time Line Charts, Issue Logs, To do Lists and more.

Launching these templates is one of the best moves in my life. They have been very [...]

This is part 4 of 6 on Profit & Loss Reporting using Excel series, 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
Preparing Quarterly and Half yearly P&L using grouping option
Budget V/s Actual report using Pivot

This is [...]