Advanced Excel Techniques Excel VBA and Macros

Dummy Data Generator Tool

Table of Content

About the tool

Dummy Data Generator is an MS Excel based tool which has capability of generating 45 types of data which includes numbers, text, date, time, Memo (long text), Booleans etc.

Tool Features

Generate unlimited dummy records on one click
Supports 45 types of data points
Capability to generate Numbers, Text, Date, Time, Long Text, Boolean and many more data types

Benefits

No additional software / investment required, works with commonly available Office Applications
Helps in tool testing
Helps in identifying bugs and deliver high quality tools

System Requirements

You need to have installed version of MS Excel 2010 or above

Tool Limitations

As the number of records increases, tool may take more time to generate random data

How to use this tool

Follow the below video which details out how to use this tool.

Open the tool and you will see below screen
As the file contains macros, you may be asked to enable the macros to use the tool
Click on ‘Generate Dummy Data’ button
The form gets loaded with default fields. You may want to add more fields or delete unwanted fields
Following are the datatype which are available in the tool for selection

Once you are ready with the fields, click on ‘Generate Random Data’ button on the form

Within few seconds, tool will generate the data in a new workbook

Congratulations you are now ready to use the tool

Recommended Articles

Advance filter in excel

Excel Basics | Advanced Excel Techniques | Data Analysis | Excel Functions

Advance Filter in Excel – how to create and use

BySumit Shrimal

This guide explains the basics of Excel’s Advanced Filter and shows you how to use it to find records that match one or more complicated conditions.
If you’ve read our previous guide, you know that Excel’s regular filter offers different options for filtering text, numbers, and dates. These options work well for many situations, but not all. When the regular filter isn’t enough, you can use the Advanced Filter to set up custom criteria that fit your exact needs.
Excel’s Advanced Filter is especially useful for finding data based on two or more complex conditions. For example, you can use it to find matches and differences between two columns, filter rows that match another list, or find exact matches with the same uppercase and lowercase letters.
Advanced Filter is available in all Excel versions from 365 to 2003. Click the links below to learn more.

Dummy Data Generator Tool

Advanced Excel Techniques

Dummy Data Generator Tool

Byexcelsirji

Table of Content How does testing help? How should I test my tool or application? How does Dummy Data Generator tool helps in testing? How do I use this tool? From many years I have…

VBA Code to Add New Sheet at Beginning or End of Excel File

Excel VBA and Macros | Productivity and Automation

VBA Code to Add New Sheet at Beginning or End of Excel File

Byexcelsirji

VBA Code To Add New Sheet In VBA, it is sometime important to add a worksheet at the right place in the Excel. Here is a simple an effective code that adds a new worksheet…

Employee Database Tool

Advanced Excel Techniques | Excel VBA and Macros | Productivity and Automation

Employee Database Tool

Byexcelsirji

Employee Database is an MS Access based tool to manage employee details. The tool supports upto 78 demographics for each employee such as Name, Location, Phone, Email, Address etc. The tool also comes with inbuilt attendance tracker to track daily attendance of employees. Over and above this, you can also design your own trackers and start using it.

Streamlining Work Allocation with an Outlook-Based Excel Tool

Advanced Excel Techniques

Streamlining Work Allocation with an Outlook-Based Excel Tool

Byexcelsirji

Table of Content Introduction Benefits of Using Outlook and Excel for Work Allocation Setting Up Your Outlook-Based Excel Tool Managing Work Allocation Conclusion Download Free Excel Template Introduction Efficient work allocation is crucial for organizations…

Why use dollar sign ($) in Excel formulas

Excel Basics | Advanced Excel Techniques | Excel Functions

Why use dollar sign ($) in Excel formulas – absolute and relative cell references

BySumit Shrimal

When creating a formula in Excel, many people get confused by the $ symbol in cell references. But it’s actually very simple. The dollar sign in an Excel cell reference tells Excel whether to keep the reference the same or allow it to change when you copy the formula to other cells. This guide will explain how it works and why it’s helpful.
Understanding Excel cell references is really important. Knowing the difference between absolute, relative, and mixed references will help you get the most out of Excel formulas and functions.

Leave a Reply Cancel reply

Excel VBA Master Tool Kit