Advanced Excel Techniques

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

Employee Database Tool

Advanced Excel Techniques

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.

Advance Filter in Excel – how to create and use

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.

Find Duplicate Files In Excel Using VBA

Productivity and Automation | Advanced Excel Techniques

Find Duplicate Files In Excel Using VBA

Byexcelsirji

How to Find Duplicate Files In excel using VBA? Yesterday I was working on my computer and cleaning the drives to make some more space. I was surprised to see so many files saved at…

Time Management Tools and Trackers

Advanced Excel Techniques

Time Management Tools and Trackers

ByPradeep Kumar

Time Management is very effective way of managing the available time. Current competitive world is making the time management crucial. There are various ways, tools and techniques by which time management can be done easily.

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…

Excel Nested IF statement: examples, best practices and alternatives

Excel Functions | Advanced Excel Techniques | Data Analysis

Excel Nested IF statement: examples, best practices and alternatives

BySumit Shrimal

This guide shows how to use the nested IF function in Excel to check several conditions. You will also learn about other functions that can be to use than a nested formula.
When you want to make decisions in Excel, you often use an IF formula. It checks if something is true, then gives one result if it is and another result if it isn’t. If you need to check more than one thing, you can put many IFs inside each other.
Although using multiple IFs is common, it’s not the only way to check several conditions in Excel. This guide will introduce you to some easier and useful alternatives.

Leave a Reply Cancel reply