Arrows Symbols (➷➹) with Custom Formatting in Excel
Custom formatting is very useful in Excel. You can display some Icon with colors with the numbers. Here we have taken an example wherein we have displayed designer up/down Arrows
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.
Highlight Unmatched Cells using Conditional Formatting in Excel
In this article you will learn how to Highlight Unmatched Cells Cells values from another range using Conditional formatting. For Example, we have Sales and Product Master worksheets. In the
Highlight the Consecutive Duplicates in Excel
In this article you will learn how to highlight the Consecutive Duplicates in Excel using Conditional Formatting. You will also learn how to highlight consecutive weekly off in an Attendance
Excel Tip: Checkbox in Excel Table
Checkbox in Excel Form Controls is very useful in Microsoft Excel. Here we have created a table in each row one check box is available. We have used conditional formatting
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.
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