3D Table in Excel
Charts and Visualization

Data Driven 3D Table in Excel

In this article, we have designed a data driven 3D table. We have used Linked picture and excel shapes to create this table. You can use this in your business presentation or business dashboard. We have used Conditional Formatting to display the icon set. Below is the snapshot of 3D Table- [caption id="attachment_19434" align="aligncenter" width="1365"] 3D Table in Excel[/caption] Click here to download this practice file.   Watch the step
Dynamic Conditional Formatting
Charts and Visualization

Dynamic Conditional Formatting in Excel

In this article, we have created Dynamic Conditional Formatting in Excel using Form Control Option Buttons. Conditional Formatting is changed in Heat Map (Color Scale), Data Bar and Traffic Lights according to the selection of Option button. While selecting the Heat Map option button- [caption id="attachment_19032" align="aligncenter" width="776"] Heat Map Conditional Formatting[/caption] While selecting the Data Bar option button- [caption id="attachment_19033" align="aligncenter" width="774"] Data Bar Conditional Formatting[/caption] While selecting the
Progress Bar in Excel cell
Excel Tips and Tricks

Progress Bar in Excel Cells using Conditional Formatting

In this article, you will learn how to display the Progress Bar in Excel Cells. We have used Conditional Formatting Data Bar to create this. Progress Bar will be filled according to the value entered in the cell. Below are the steps to create Progress Bar in Excel Cells- Select the range for your completion percentage. Go to Home >> Conditional Formatting >> New Rule Select Format all cells based
Advanced Condtional Formatting
Excel Tips and Tricks

Search Text from Specific or all columns in Excel

In this article, you will learn how to use Advanced Conditional Formatting to search text in data. Here we have taken the example for employee Performance rating data. We two type of search –Search in specific column and Search in all columns. Note: This trick is useful only for small data set. Search in specific Column: To search in specific column, just select the column name form the drop down
Birthday Count
Excel Tips and Tricks

Highlight and get birthdays count from Date of Birth

In this article, you will learn how to get count of persons from a Date of Birth data whose birthdays are in the specific month. You will also learn how to highlight the data using Conditional Formatting whose birthdays are in This Month, Last Month and Next Month. We have below given Date of Birth data for Employees- [caption id="attachment_14951" align="aligncenter" width="435"] Date of Birth data[/caption] We have created a
Stylish Traffic Lights
Charts and Visualization

Stylish Traffic Lights in Excel

You can create very attracting info-graphics with the help of Auto shapes. Here we are giving an example of this. We have created stylish and beautiful Traffic lights info-graphics using Auto Shapes and Conditional Formatting in Excel. You can use these traffic lights in your Business Dashboard or Project Management Dashboard to display project health. Below is the data set which we have used to create these Stylish Traffic Lights-
Custom Formatting
Excel Tips and Tricks

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 arrow (➷➹) for Variance %. We have a table for Market wise sales for Current Year and Previous Year. We have displayed Variance % here with designer arrows. [caption id="attachment_12838" align="aligncenter" width="617"] Market Wise Data[/caption] In the Variance % column we
Highlight Unmatched Cells
Excel Tips and Tricks

Highlight Unmatched Cells using Conditional Formatting in Excel

In this article you will learn how to highlight the Unmatched Cells values from another range using Conditional formatting. For Example, we have Sales and Product Master worksheets. In the Sales worksheet we need to highlight the Products which are not available in Product Master. [caption id="attachment_12307" align="aligncenter" width="1496"] Sales Data and Product Master Worksheets[/caption] Below are the steps to put the Conditional Formatting to highlight Product Name in Sales
Highlight Consecutive Duplicates
Excel Tips and Tricks

Highlight the Consecutive Duplicates in Excel using Conditional Formatting

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 Sheet. Let’s say we have month wise sales wherein we have month name duplicate. We want to highlight the consecutive duplicate month as given in below image [caption id="attachment_12290" align="aligncenter" width="282"] Consecutive duplicate month[/caption] Below are the steps to put
Emp Rating Table
Charts and Visualization

Employee Rating Table in Excel

Rather than showing the simple numbers , you can display some symbols in your Excel table. Here we have taken an example of Employee Rating Table for 1 to 5. We have used Conditional Formatting with Icon set to create this Employee rating table. You will select the rating using drop-down and it will be changed in symbol automatically. [caption id="attachment_10772" align="aligncenter" width="783"] Employee Rating Table[/caption]   Click here to