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.
Excel Tips and Tricks
This category offers a collection of tips and tricks to help you master Excel and work more efficiently. From keyboard shortcuts to advanced formulas and functions, our tutorials cover a range of topics to help you save time and simplify your work. Each tutorial comes with a free practice file for download and tutorial videos to help you understand the concepts better. Start exploring this category now and take your Excel skills to the next level. Impress your colleagues and boss with your proficiency in Excel by exploring this category today.
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"
Excel Tip : Fill the blanks cells in your data
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
Highlight Top and Bottom Performer using conditional formatting
In this article you will learn how to use Conditional Formatting to Highlight Top and Bottom performer on the base of performance score. Top performer has been highlighted in green
Lock Excel Cell after Updating
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
Excel Template with Protection and Validation
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
Quick Data Entry Form (Without VBA)
If you don’t know the VBA and want to create a Quick Data Entry then don’t worry in this article you will learn how to create/open a data entry form
Custom Style of a slicer in Excel
In this article you will learn how to create a Custom Style of a slicer in Excel. By using the custom style in Slicer you can make your slicer based
Change% in Pivot Table
In this article you will learn how to show Change% in a pivot table. For example, you have month wise sales and revenue in your pivot and you have to