In this article we are going to discuss about Charting and Dashboard in Excel. Why this is necessary and what are the types of data that can be represented in Dashboard style. What is a Dashboard in Excel? A chart …
Lesson#188: Overview about Dashboard in Excel and its necessity Read more »
Here is an example of a VBA program that you can use to shut down a Windows PC when a button is clicked: This program uses the Shell function to execute the shutdown command with the -s and -t 0 …
Data analysis in Excel is the process of using Excel’s built-in tools and formulas to extract insights and trends from data. This can involve a wide range of activities, such as organizing and cleaning data, creating charts and graphs to …
Lesson#186: 10 formulas to learn for data analysis in Excel Read more »
In this post, we shall learn a simple to make a digital clock with VBA on your excel sheet. Now paste this VBA macro that you can use to create a digital clock on your worksheet, To use this macro, …
Lesson#185: How to make a digital clock with VBA Read more »
Here I shall show how entered value can be divided by 100 with a button in VBA. Here is the VBA macro that will automatically divide the value of the active cell by 100 when a command button is clicked: …
Lesson#184: Entered value divided by 100 with a button in VBA Read more »
Here we are going to learn a VBA code to insert zeroes in all empty cells in a selected range. Here is your VBA macro code: To use this macro, select the range that you want to check for empty …
Lesson#183: Insert zeroes in all empty cells in a selected range with VBA Read more »
Here I shall show you a VBA code that colors all empty cells in red in a selected range. Here is a VBA macro that you can use to insert zeroes in all empty cells in a selected range: To …
Lesson#182: Color all empty cells in red in a selected range with VBA Read more »
Here is a VBA macro that you can use to add a prefix to the selected cells: To use this macro, select the cells to that you want to add the prefix and run the macro. It will prompt you …
Lesson#181: VBA To Add A Prefix to Selected Cells Read more »
Here we shall learn a code that will copy a color from one cell to another using VBA. Here is a function in VBA that you can use to copy the interior color of a target cell to the active …
Lesson#180: How do you copy a color from one cell to another? Read more »
Here I shall make a VBA code to Count cells by color in Excel from a reference cell color. Here is a function in VBA that you can use to count the number of cells in a specified range that …
Lesson#179: Count cells by color in Excel from a reference cell color with VBA Read more »