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...
Free Excel Based Random Data 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
Watch Excel Tutorial Video - 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...
VBA Code to Sum Cells by Color
VBA code that will sum cells by its color through excel function. This code will really help in making the analysis and presentation better.
How to Insert Symbol in Excel Numbers?
Have you ever faced the challenge while using special character symbols in number formatting or any customized number formatting? It is an easy method to insert any symbol in numbers i.e Delta Symbol or Special…
Usage of Delta Symbol in Excel – Complete Guide
USAGE OF DELTA SYMBOL IN EXCEL – COMPLETE GUIDE The Greek Capital Alphabet letter Delta (▲) and is commonly discussed topic in Excel. This is being used for various purposes i.e. changes in quantity, insert...
How to Insert Symbol in Excel
I came across many queries regarding inserting special symbols in Excel. Here we are guiding how you may do this quickly in excel. Follow these steps and you may insert any kind of special characters…
Find Duplicates in Excel
Watch Excel Tutorial Video -Find Duplicates in Excel Hope you read the post “Remove Duplicates in Excel”. Now I am going to explain how you can find these duplicates. There are multiple methods available to...
VBA Code to Find Duplicate Files
Watch Excel Tutorial Video - VBA Code to Find Duplicate Files Yesterday I was working on my computer and cleaning the drives to make some more space. I was surprised to see so many files...
VBA Tool to Merge Excel Files from a Folder
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 VBA tool from...
VBA Code to Export Access Recordset to Excel
Creating a VBA tool in MS Access is always better as compare to MS Excel. MS Access provides better user interface and ability to handle multiple users. Still people prefer to pull and see the…
VBA Code to Send Outlook Emails
Sending bulk emails is very common activity, there are many office activities which needs a person to send bulk emails to a single or multiple recipients. You also may require to add attachments in the…
VBA Code to Browse a File
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 sample code where I have given a browse button…
How to Count Color Cells in Excel- Step by Step Tutorial
Have you ever got into situation in office where you need to count the cells in Excel sheet with specific color? If yes then you can use following code which counts the number of cells...