Multicolor Filling Bars in Excel Cells Without using Chart
In the article, you will learn how to create Multicolor Filling Bars in Excel Cells without using Chart. You can use such visualization to display the project completion status with
Tag: Conditional Formatting
KPI in Power Pivot for dashboard and report
Key performance indicators (KPIs) are visual measures of performance. Based on a specific calculated field, a KPI in Power Pivot for dashboard is designed to help users quickly evaluate the
Fully Functional To-do List in Excel
In this article, we have created a fully functional To-Do list template in Microsoft Excel. We have used VBA to create this template. You can use this template in your
Daily Activity Tracker in Excel
In this article, we have created a simple Daily Activity Tracker in Excel. You can use this Activity tracker to track your daily activity and you can create a database
10 Useful Pivot Table Tips
Pivot Table is useful and power full feature available in Excel. Learn the below given 10 useful Pivot table tips in Excel- 10 Useful Pivot [caption id="" align="aligncenter" width="813"] 10
Data Driven 3D Table in Excel
In this article, we have designed a data driven 3D table in Excel. We have used Linked picture and excel shapes to create this table. You can use this in
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
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. chart will be filled according
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
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