Sat 26 Aug 2017

Downloads 18 - Sample CSV Files / Data Sets for Testing (till 1.5 Million Records) - Sales

By |Saturday, August 26th, 2017|Categories: Downloads, VBA|Tags: , , , , , , , , , , , , , , , , , , , , , |0 Comments

Disclaimer - The datasets are generated through random logic in VBA. These are not real sales data and should not be used for any other purpose other than testing.

You can download sample csv files ranging from 100 records to 1500000 records. 1.5 Million records will cross 1 million limit of Excel. But 1.5 Million Records are useful for Power Query / Power Pivot. These csv files contain data in various formats like Text and Numbers which should satisfy your need for testing.

This data set can be categorized under "Sales" category.

Below are the fields which appear as part of these csv files as first line.

(more…)

Sat 19 Aug 2017

Downloads 17 - Sample CSV Files / Data Sets for Testing (till 1.5 Million Records) - Credit Card

By |Saturday, August 19th, 2017|Categories: Downloads, VBA|Tags: , , , , , , , , , , , , , , , , , |0 Comments

Disclaimer - The datasets are generated through random logic in VBA. These are not real credit card data and should not be used for any other purpose other than testing.

You can download sample csv files ranging from 100 records to 1500000 records. 1.5 Million records will cross 1 million limit of Excel. But 1.5 Million Records are useful for Power Query / Power Pivot. These csv files contain data in various formats like Text and Numbers which should satisfy your need for testing.

This data set can be categorized under "Credit Card" category.

The data generated follow all known rules for credit cards.

Below are the fields which appear as part of these csv files as first line.

(more…)

Sat 12 Aug 2017

Downloads 16 - Sample CSV Files / Data Sets for Testing - Human Resources

By |Saturday, August 12th, 2017|Categories: Downloads, VBA|Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , |0 Comments

Disclaimer - The datasets are generated through random logic in VBA. These are not real human resource data and should not be used for any other purpose other than testing.

You can download sample csv files ranging from 100 records to 500000 records. These csv files contain data in various formats like Text, Numbers, Date, Time, Percentages which should satisfy your need for testing.

This data set can be categorized under "Human Resources" category.

Below are the fields which appear as part of these csv files as first line.

(more…)

Sat 06 May 2017

Downloads 15 - Excel Formulas Bible

By |Saturday, May 06th, 2017|Categories: Downloads|Tags: , , , , , , , , , , , , |0 Comments

This is one single document which contains close to 100 formulas dealing with various situations. Useful for Intermediate and Advanced users.

Download it from Excel - Formulas Bible

Sat 15 Apr 2017

Downloads 14 - Excel Shortcuts Bible

By |Saturday, April 15th, 2017|Categories: Downloads|Tags: , , , , , , , |0 Comments

This is a mammoth work. Contains all short cut keys published by Microsoft and also all ALT keys which are not published by Microsoft.

Download it from Excel - Shortcuts Bible

Sat 18 Mar 2017

Downloads 13 - Template 11 - Invoice Template

By |Saturday, March 18th, 2017|Categories: Downloads|Tags: , , , , , , , , , , |0 Comments

The invoice template is specifically designed for Service Invoices in India but this can be used anywhere in the world with little customization.

There are two templates, one which populates the amount in words in Rupees and Paise and one which populates in Dollar and Cents. If you need to change these currencies, you can write to me to change them.

(more…)

Sat 11 Feb 2017

Downloads 12 - Template 10 - A Flexible Amortization Schedule Generator

By |Saturday, February 11th, 2017|Categories: Downloads|Tags: , , , , , , , , , , , , , , , , |0 Comments

This flexible Amortization Schedule Generator can be downloaded from Amortization Schedule Template

1. You can specify Interest Rate not only annually but also weekly, monthly, quarterly and half yearly. Default is Yearly if nothing is specified.

2. You can specify Loan Period in weeks, months, quarters, half years and years. Default is Years if nothing is specified.

3. You can specify payment frequency not only monthly but also in weekly, quarterly, half yearly and annually also. Default is Months if nothing is specified.

4. You can also specify the decimal places to be shown in your figures.

5. PMT and few other financial functions have a parameter called TYPE which can also be specified. Default value is End.

6. It will automatically put the border around the data.

7. The schedule is valid for a period of 50 years.

8. If you are printing it, choose FROM and To pages otherwise it will print many pages which are not needed as formulas are contained in cells beyond visible data also.

1

Sat 21 Jan 2017

Downloads 11 - Printable & Pin-up Sheet for Excel Functions

By |Saturday, January 21st, 2017|Categories: Downloads|Tags: , , , , , , |0 Comments

You can download this one page pin-up sheet and take the printout and pin up to your desk for quick reference - Excel Functions Quick Reference

(more…)

Sat 24 Dec 2016

Downloads 10 - Printable & Pin-up Sheet for Excel Shortcuts

By |Saturday, December 24th, 2016|Categories: Downloads|Tags: , , , , , , , |0 Comments

You can download this one page pin-up sheet and take the printout and pin up to your desk for quick reference. - Excel Shortcuts Quick Reference

(more…)

Sat 19 Nov 2016

Downloads 09 - Template 09 - Stakeholder Register

By |Saturday, November 19th, 2016|Categories: Downloads|Tags: , , , , , , , , , , , , , , |0 Comments

< The template can be downloaded from Template 09 - Stakeholder Register >

This is a fairly detailed template which you can shorten if you wish. But the recommendation is to use the full template to get complete benefit from Stakeholder Analysis.

1