3D Filled Pyramids Chart in Excel
3D Filled Pyramids chart have been designed to display the KPI metrics like Sales Conversion, Service Level or any other KPI in percentage. You can display multiple categories on horizontal
Blogs
Dynamic Sales Funnel Chart with Slicers
In this article you will learn how to create dynamic Sales Funnel Chart with Slicers. This Chart can be used in your business dashboard or presentations. Below are the data
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
Drill through in Power BI
In this article you will learn how use Drill through in Power BI. You can create a page in your report that focuses on a specific entity such as Supervisor
Customized Tooltip in Power BI
In this article you will learn how to Customized Tooltip in Power BI and how to use a Report page as tooltip in Power BI, Tooltip is very useful feature
Fully Functional Dynamic Calendar Control in VBA
Ah, The complexities of automation! The versatile and multifaceted world of Excel VBA offers an array of tools and functionalities to streamline tasks and make life easier. Yet, despite its
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
UDF for Evaluate a Formula in Excel
In this article you will learn how to create a User Defined Function to evaluate a formula in Excel. You will also learn how to get text of formula using
VBA: Quickly merge cells with same value in Excel
In this article you will learn how to quickly merge same cells in Excel using VBA. Using this VBA code, you can merge multiple columns data together. This trick can