Automation: Excel to PDF Converter
In this article you will learn how to convert multiple Excel files into PDF file using VBA. This is quite useful and easy macro. We have used File System Object
Blogs
Analog Clock in Excel (Pie Chart + Doughnut Chart)
Analog Clock in Excel (Pie Chart + Doughnut Chart) After creating the Digital Clock, we have created a beautiful Analog Clock. This stunning Analog Clock we have developed using Pie Chart
Innovation: Digital Clock in Excel
This time we have developed an innovative and stunning Digital Clock in Excel. We have created this using Excel auto shapes and VBA. Digital Clock in Excel [caption id="attachment_7136" align="aligncenter"
Stylish Butterfly Chart – Version 2
This is the version-2 of Stylish Butterfly Chart. In the “Stylish Butterfly Chart – Version 1”, we created it vertically. In this chart we will create the butterfly chart horizontally.
Stylish Butterfly Chart – Version 1
We are back with one more interesting chart that is Stylish Butterfly Chart (Version-1). This is useful for the comparison of two team on different KPIs. You can use this
Informative KPI Indicator Chart Version-2
This is the 2nd version of Informative KPI Indicator Chart. In this chart I have used a RAG color pallet in 10 slices (10% each). Here I have taken Service
Informative KPI Indicator Chart (Version-1)
I am back with one more stunning and Informative KPI Indicator Chart. In this chart I have used a RAG color pallet in 10 slices (10% each). Here I have
Innovation: Focus Chart in Excel
Focus chart has been created by my team to highlight the top performer on chart in Excel in very innovative way. Top performer will be focused with a hanging light.
VBA: Dynamic Chart on User Form
Creating the Chart on a VBA user form is quite interesting. We have created 4 KPI Charts – Battery Chart, Speedometer Chart, Moving Man Chart and Progress Circle Chart on
VBA: Web browser in the User Form
In this article you will learn how to use a web browser in the user form. You can search anything or open a website using the text box VBA: Web