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 the data. For example if you have month wise data points. Month name is in text format like Jan, Feb, Mar etc. If data is not sorted by month and we have to sort the data by month name. We would not be able
After creating the Digital Clock, we have created a beautiful Analog Clock. This stunning Analog Clock we have developed using Pie Chart and Doughnut Chart. To calculate the formula automatically, we have used below given code. Option Explicit Sub Start_Clock() Dim sh As Worksheet Set sh = ActiveSheet sh.Range("N1").Value = "Start" x: VBA.DoEvents If sh.Range("N1").Value = "Stop" Then Exit Sub Application.Calculate GoTo x End Sub Sub Stop_Clock() Dim sh As Worksheet
This time we have developed an innovative and stunning Digital Clock in Excel. We have created this using Excel auto shapes and VBA. Click here to download this Excel workbook. Watch the step by step video tutorial:
Many times we have zig-zag data which has to be formatted in proper manner to create some report or dashboard. In this article you will learn how we can fill the blanks in our data. Below is the data in which blanks cells have to be filled: [caption id="attachment_7049" align="aligncenter" width="507"] Data Sets[/caption] We can fill the blanks using 4 differed tricks. 1-Using Filter: We can fill the blanks using
In this article you will learn how to use Conditional Formatting to highlight the Top/bottom performer on the base of performance score. Top performer has been highlighted in green color and Bottom performer has been highlighted in red color. A drop-down of Top Performer and Bottom performer has been given on cell C1 using Data Validation list. In the below image, top performer has been highlighted. To highlight the top
One of our client asked us to create a template wherein data can entered only once. As soon as data is entered in the cell, it should be locked for editing. Only Admin (who has the protection password) should be able to edit this. Here we have given some solution: Below is the worksheet wherein data will be entered. [caption id="attachment_4021" align="aligncenter" width="720"] Excel sheet[/caption] We have put the
We often required an Excel Template to send some persons or teams so that they can enter the data in the template and can sent it to us and then we can consolidate the data from all the templates. But in this case only challenge is this if your template does not have proper protection and validation then people can enter the invalid data in the template. Here we have
If you don’t know the VBA and want to create a data entry form then don’t worry in this article you will learn how to create/open a data entry form without using of VBA. How to add Form Icon in Quick Access Toolbar? Go to File Tab>>Options (or press Alt+T+O). Excel Options window will be opened. Select Quick Access Toolbar in left hand side. Select Command Not in the Ribbon
In this article you will learn how to create a custom style for a Slicer. By using the custom style in Slicer you can make your slicer based dashboard or report more visually attractive and beautiful. How to create a custom style for a slicer? Let’s say we have a slicer for locations. [caption id="attachment_3695" align="aligncenter" width="231"] Slicer[/caption] Select the slicer. Go to Options>>Slicer Styles>>Click on New Slicer Style. [caption
In this article you will learn how to create a searchable drop-down list in excel. Just assume you have a long list of data validation and if you have to select any item then it will take some time because you have to scroll it to find your desired item in the data validation list. Here I have created a solution of this and that is Searchable Drop-Down List. Just
