Wildcard in Microsoft Excel
In this article, you will learn how to use Wildcard in Microsoft Excel. Wildcard is very useful in excel and can make your work very easy. What is Wildcard? Wildcards
Blogs
Universal Searchable Drop-down List in Excel
In this article, we have created a universal searchable drop-down list in Excel. It is useful when you have multiple items in your data validation drop-down list. You can use
Top/Bottom Analysis dashboard in Excel
In this article, we have created Top/Bottom Analysis dashboard using a sales dataset. This is a dynamic dashboard. We have used Slicers, Form control Option buttons and form control Scrollbar
Dynamic Dashboard with Tablet and Mobile shape in Excel
In this article, we have created an attractive and dynamic dashboard using Tablet and Mobile shape. We have created Tablet and Mobile shapes using Excel Shapes. We have made the
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. Click
Smart Chart with Laptop Shape in Excel
In this article, we have created a beautiful and smart chart with Conditional formatting in Microsoft Excel. We have create a laptop shape also using Excel shapes. We have placed
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
Dynamic Sales Score Meter Chart
In this article, we have created a dynamic sales score meter chart. In this chart we have displayed the sales core on a speedometer chart. We have displayed the sales
Fully Automated Excel dashboard with multiple source files
In this article, we have create a full automatic excel dashboard with multiple excel source files. Each source file can have multiple worksheets. For data consolidation we have used Power
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