Waffle chart with Football Icon in Excel
Data visualization is important part of data analysis. It enables us to better understand the data, identify trends, and make informed decisions. There are several types of charts and graphs
Tag: Formula in conditional formatting
Highlight Row and Column of Active Cell in Data Automatically
Data analysis is an essential part of any business. Microsoft Excel is a great tool for organizing, analyzing, and visualizing data. It can be challenging to read through large tables
Multi-color Data bar with REPT function
In this article, we have created multi-color data bars in Excel cells using REPT function. We have used the conditional formatting to change the color based on certain criteria.
Dynamic Calendar with Single formula
In this article, we have created a dynamic calendar in Microsoft Excel. We have used a Single formula to create this Dynamic Calendar. We have displayed two form control Spin
Send WhatsApp and Email without VBA
In today's fast-paced world, communication has become an integral part of our lives. We need to stay connected with our colleagues, friends, and family. WhatsApp and Email are two of
Automated Attendance Sheet in Excel
Managing attendance can be a time-consuming and challenging task, especially for organizations with a large workforce. With the help of Microsoft Excel, we can create an Automated Attendance Sheet to
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
Smart Data Entry form with minimum VBA
In this article, we have a data entry form for candidate information with minimum VBA. We have used Excel formulas, conditional formatting and Form Controls. You can replicate this template
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
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