Friday, September 4, 2009


This is a good template for those who work particularly on account analysis. I considered here expense account for this purpose.

DSum function is very good for grouping data from ledger; someone uses Sumifs (only available in Office 2007), Sumif and Sum array function for achieving this objective.

You can also use DCount, DAverage, DCount, DGet and DProduct in place of DSUm, but should be careful in working.

Only thing which you have to learn in DSum is its criteria option, put focus on criteria go to internet and learn more. The function will make your routine work very simple.

The function of Database (DSum, DCount, DAverage, DCount, DGet and DProduct) will be suitable also for marketing professionals because they can analyze data on product wise, region wise, sales personnel wise and etc.

For more useful Template Click on Link shown Top of the page.

Download Dsum Template Link1

Download Dsum Template Link2

For more Useful Excel Templates & Analysis Tips, visit links Given national admission UK

No comments:

Post a Comment