Similar Posts

VBA to Open Workbook in Excel
How to use VBA to open Workbook in Excel? There are few VBA codes which are commonly used by every developer. One of them is giving an option to user to browse a file. Below is a…

Audit Sampling Tool
Random Rows Selector is an MS Excel based tool which can be used to pick random or stratified samples from a set of records available in the Excel. The tool is fully dynamic, it can support any data format in Excel.

Create Pareto Chart In Excel
What is Pareto Chart? Pareto principle was introduced by Italian Economist Vilfredo Pareto. He stated that 80% of the effects are caused by 20% of the causes. So if we closely monitor and solve 20% of…

How Histogram Works in Excel? (Definitive Guide)
In layman language, this chart divides the data into multiple range groups with same interval i.e. 1-5, 5-10… and then plot the data into these groups to find the distribution among these group. So that you may understand, what are the major areas which has large impact or your major data fall. This helps the user to understand the nature of your data

VBA to Browse Outlook Folder
VBA to Browse Outlook Folder Outlook is most commonly used emailing application used in the world. Many people spend their entire day on Outlook applications to read and respond to emails. To automate certain rule-based…

EXCEL FUNCTION – DATEVALUE
How to Change TEXT into DATE Format Microsoft Excel “DATEVALUE” is the very useful where dates are available as TEXT and need to convert them to proper DATE format. DATEVALUE function helps to convert the…