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...
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...
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…
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...
Excel VBA Tool to Get File Properties
Here is one more interesting VBA tool from ExcelSirJi team. File Properties Tool is an Excel VBA tool which gets the following properties of the file. File Name Date Created Date Last Accessed Date Last...