Data Segregation Tool in Excel VBA
In this article, we have created a Data Segregation Tool using Excel VBA. It is ready to use Tool to segregate your data into multiple sheets for Multiple files. Data
Tag: Excel Templates
Email Data Consolidation Tool in Excel
Now a days businesses rely more heavily on email communication. Managing data from multiple sources can become a real challenge. Fortunately, there is a solution: an email data consolidation tool
User level security in Excel Workbook for different worksheets
In this article, we have created User level security in Excel workbook. If you have multiple worksheets in your excel file and you want to protect/hide the data according to
Profit Optimizer in Excel using Multiple Regression
In this article, we have explained how to predict a value using multiple regression Analysis in Microsoft Excel. What is Multiple Regression? Multiple regression is an extension of simple linear
Fully Functional To-do List in Excel
In this article, we have created a fully functional To-Do list template in Microsoft Excel. We have used VBA to create this template. You can use this template in your
Daily Activity Tracker in Excel
In this article, we have created a simple Daily Activity Tracker in Excel. You can use this Activity tracker to track your daily activity and you can create a database
Employee Rating Table in Excel
An Employee Rating Table in Excel can be a powerful template to visualize and track employee performance across various parameters. So, instead of displaying simple numerical ratings, you can use
Quality Check List in Excel
The template of Quality Check List in Excel has been designed to use for quality team. It can be use for other purposes also. Here we have taken the drop-down as