Conditional Formatting in a Lollipop Chart in Excel
Using the Conditional Formatting in a Lollipop Chart in Excel is very useful. It helps to audience to identify which category is meeting the target and which is not meeting.
Blogs
3D Glass Chart in Excel
I am back with a very innovative and Informative chart that is 3D Glass Chart in Excel. This chart can be used to display a KPI metrics like Service Level,
Info-graphics: Flag Chart in Excel
If you have a small data set and you want to create an attractive chart then Flag chart is very nice Idea. It is very eye catching and innovative Idea.
Create Multiple Folders from Excel Range
In the previous article you have learnt how to check the whether a folder exist or not. In this article you will learn we can create multiple folders on one
Check Folder Existence using VBA
During the automating some task in VBA, many times we need to check that a folder is exits or not. For example if you want to create or delete a
Excel Tips: Sort data by Custom List
Many times it happens when we are not able to sort our data as per our requirements. We have to take some support column to Sort data by Custom List.
Rename Multiple File on one click
In this article you will learn how to Rename Multiple File files available in a folder. In the previous post I have explained you how we can get the files
File System Object: Get Files information in Excel
In this article you will learn how to get the files information from a folder like File Name, File Type, File size, Last modify date etc. in excel sheet. We
Rating Meter Chart in Excel
Rating Meter Chart in Excel is very innovative and informative chart to show the Process or Portfolio level health in five buckets – Worst, Bed, Average, Good and Best. This
Automation: Word to PDF Converter
In the previous article you have learnt how to Excel to PDF converter using VBA. In this article you will learn how to convert multiple Word files into PDF file using