VLOOKUP by cell background color
VLOOKUP is a popular function in Microsoft Excel. It helps users to find and retrieve specific data from a large table or range of data. However, there is a limitation
Blogs
Yesterday Vs Today Sales Chart
In this article you will learn how to create Yesterday Vs Today Sales Chart in Excel. In this chart we are displaying the green and red arrows. If Today's sale
3D Doughnut Chart for KPI Metrics
In this article you will learn how to create beautiful 3D Doughnut Chart for KPI Metrics like (Service Level, Quality Score, Sales Conversion etc.). 3D Doughnut chart is not default
Weekly Sales Chart in Excel
In today's business world, charts and graphs have become an essential part of data analysis. They help to present complex data in a clear and concise manner, allowing us to
Data Entry Form in Excel
This data entry form has been designed in VBA. You can enter the EMP ID, EMP Name, Gender, Designation and Salary. Since Excel sheet is protected so data can not