Quick Data Formatting by Personal Macro
In this article you will learn how to create a Personal Macro in MS Excel. I have created this personal macro to format the data Quick Data Formatting. Any macros
Blogs
Employee Wise Deficit and Surplus Sales Chart
In this article you will learn how to create an Employee Wise Deficit and Surplus Sales Chart. This chart will give 2 types of analysis. This will give an employee
Conditional Formatting in Stylish Doughnut Chart
In my last post I have explained how to create stylish doughnut chart in Excel. I hope you has enjoyed that chart. Now in this article, you will learn how
Stylish Doughnut Charts in Excel
In this article you will learn how to create 4 stylish doughnut charts in Excel. These doughnut charts are used to display the KPI metrics or progress of a project.
Multilayered Doughnut Chart : Part-2
In this article you will learn how to create a beautiful Multilayered Doughnut Chart to display the team level performance. This chart can be used in business dashboard or presentation.
Multilayered Doughnut Chart : Part-1
In this article you will learn how to create a beautiful multilayered Doughnut Chart for KPI metrics. In this chart we can display 3 or 4 KPI metrics at a
Send Email with Snapshot in Excel VBA
In this article you will learn how to send an Outlook Email with mail body snapshot like Excel tables, Charts or images by using VBA. We will use "Mail Envelope" method
Dynamic Step Chart in Excel
In this article you will learn how to create a dynamic Step Chart in Excel. In this chart we can show the rolling 7 days price or sales. Let's say
Stunning Battery Chart
In this article you will learn how to create a stunning and beautiful battery chart in excel. You can use this battery chart in business dashboard or presentation to show
Searchable Excel Drop down list for Multiple Cells
In this article you will learn how to create a Searchable Excel Drop down list in excel. Just assume you have a lengthy list in excel data validation and if you