From many years I have been working on VBA based automation projects using Excel, Outlook, Word, Access and other technologies. As a professional developer it was my responsibility to test the tools with all possible scenarios and data. Proper testing of the tools helps to deliver bug free and quality tools to clients.
If you are also a programmer and developing a tool or application. You should always test your tool with all possible scenarios that may come in production environment.
It is always good to test your tool or application with dummy data that is similar to production environment. Creating a dummy data is a big and time consuming task. You need to ensure that your dummy data contains variety of data types and available in massive quantity.
Step 1: Download and save the following attachment in you system
Step 2: Unzip the file and open
Step 3: As the file contains macros, you may be asked to enable the macros to use the tool
Step 4: Click on ‘Generate Dummy Data’ button
Step 5: The form gets loaded with default fields. You may want to add more fields or delete unwanted fields
Step 6: Once you are ready with the fields, click on ‘Generate Random Data’ button on the form
Step 7: Within few seconds, tool will generate the data in a new workbook
Step 8: Congratulations you are now ready to use the tool
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.
QR Code Generator Tool in Excel Hi Friends, today we are going to learn something which is more closure to many businesses. As the businesses going global and digital, there is a need to adopt…
Have you ever felt that Microsoft should have added a formula in Excel which can count the cells based on specific color? I have seen many code requests to share a VBA code that can count the cells by its color. To help our subscribers and developers, we are sharing 2 codes that be used to count the cells with specific color and returns the count of the matching color cells.
Merge Excel Files From last few months, we have been receiving frequent requests from users for a VBA tool which can consolidate Excel files from a folder. So here we come with one more free…
This article has Top Excel Interview Questions and Answers to test your Excel skills. It’s great for beginners who are just starting out, or even pros who want a refresher. The questions cover everything you might need for jobs like data analyst, business analyst, or accountant.
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), Boolean etc.