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

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
Preparing Quarterly and Half yearly P&L using grouping option
Budget V/s Actual report using Pivot

In this post [...]

Today we will learn Excel SUBTOTAL formula and 5 beautiful reasons why you should give it a try.

SUBTOTAL formula is used to find out subtotal of a given range of cells. You give SUBTOTAL two things – (1) a range of data (2) type of subtotal. In return, SUBTOTAL will give you the subtotal for that data. Unlike SUM, AVERAGE, COUNT etc. which do one thing and only one thing, SUBTOTAL is versatile. You can use it to sum up, average, count a bunch of cells.

Dear Readers & Friends,
I am very happy to announce that Excel School online training program is now available for your consideration. Please read this short post to understand what you will get when you sign-up for this program and how you can join.
What will you get when you join?

Access to Private Member-only Classroom: Where you [...]

I have very exciting news for you. Finally, the excel school program is ready for your consideration. We are opening registration on 8th of Feb.
(if you don’t know what Excel school is… it is a 12 week online excel training program, conducted by me. You can find full details, get a free lesson here.)
Some details [...]

Let us take a minute and bask in some glory, for, our little community at PHD had the most fantastic month ever.
That is right, January 2010 is so far the best month since I started blogging. We have broken all sorts of previous records on content, conversations, connections, traffic and revenue.
In January, we had [...]

With this post we are starting a new series on how to do basic accounting in Microsoft Excel. In this and next 5 posts, we will aim to setup Profit & Loss account reporting for multi-location retail company.

During this series we will learn how to make P&L reports on various criteria with just few clicks.

Many users find it difficult to manage their P&L reporting for Multi Location organization.

We will be using Pivot Tables for our reporting purpose and will take example of a Retails chain with multiple locations divided into various regions.