Dynamic Conditional Formatting in Power BI
In this article, we have created a Power BI dashboard with dynamic condition formatting. We have created to measure in Power BI using DAX to create the dynamic Conditional Formatting
Blogs
Smart Data Entry form with minimum VBA
In this article, we have a Smart data entry form for candidate information with minimum VBA. We have used Excel formulas, conditional formatting and Form Controls. You can replicate this
Profit Optimizer in Excel using Multiple Regression
In this article, we have explained how to predict a value using multiple regression Analysis in Microsoft Excel. What is Multiple Regression? Multiple regression is an extension of simple linear
Correlation Coefficient in Excel
In this article, we have explained how to calculate the Correlation Coefficient in Microsoft Excel. We have explained it using Excel Formula and Data Analysis Add-in. What is Correlation Coefficient?
Forecasting in Excel using Linear Regression
In this article, we have explained Excel formula and Linear Regress to forecast sales in upcoming month. We have used 1st Jan 2019 to 31st Mar’19 sales data to do
RandBetweenText Formula in Excel
In this article, we have created a user defined function RandBetweenText Formula in Excel. This function returns random text from the selected range. You can use this function to distribute
5 Layered Advanced Doughnut Chart
5 Layered Advanced Doughnut Chart In this article, we have created the 5 Layered Doughnut Chart to display the KPI value up to 500%. We have created two different version
VBA Application with MS Access Database
In this article, we have create a VBA application with MS Access database using ADODB connectivity. We have created the Rent Management System. We have used VBA user form with
RAG waffle Chart visualization with Slicer
In this article, we have create a RAG waffle Chart visualization with slicer to display the Red, Amber and Green percentage. We have used Conditional Formatting and linked picture feature
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