Bonus – Making an Excel Dashboard with just ONE Formula (LET function)

In this bonus dashboard tutorial, learn how to create an interactive and dynamic Excel dashboard with just one formula. We are going to get creative with the new LET function in Excel 365.

PS: This is originally published on my YouTube channel, but you can watch it here and download Continue reading “Bonus – Making an Excel Dashboard with just ONE Formula (LET function)”

Excel Dynamic Arrays – New Way to Write Formulas

Welcome to special bonus lesson(s) on Excel Dynamic Array functions. Using new functions like FILTER, SORT, XLOOKUP, SEQUENCE etc. we can save precious time and work in new & powerful ways with our data. In this page, find all the lessons that give you confidence to work with Dynamic Array Continue reading “Excel Dynamic Arrays – New Way to Write Formulas”

Bonus – Quick Dashboard with Pivot Tables Alone

In this bonus dashboard tutorial, learn how to create the below interactive, beautiful & dynamic dashboard using Microsoft Excel 365.

PS: This is originally published on my YouTube channel, but you can watch it here and download for free, as a member of Excel School + Dashboards program.

Lesson topics Continue reading “Bonus – Quick Dashboard with Pivot Tables Alone”

Bonus – Sales Dashboard with Excel (Must Watch)

In this bonus dashboard tutorial, learn how to create the below interactive, beautiful & dynamic dashboard using Microsoft Excel 365.

PS: This is originally published on my YouTube channel, but you can watch it here and download for free, as a member of Excel School + Dashboards program.

Lesson topics Continue reading “Bonus – Sales Dashboard with Excel (Must Watch)”

Welcome to Power BI Play Date

Hello and welcome to Power BI Play Date program. Thank you so much for enrolling.

I have two messages for you. Watch them below.

Welcome message & how to learn [8 mins]

Important Visual Changes to Power BI (March 2023) [6 minutes]

Important changes to Power BI (July 2020) [6 mins]

Thank you and welcome Continue reading “Welcome to Power BI Play Date”

How to create a quick Sales Dashboard in Power BI?

In this tutorial, let’s build an interactive, simple & elegant sales dashboard using Power BI. Use this lesson to understand the report building process and gain basics of Power BI.

This is what we are going to build:

Sample Data & Workbooks

[Dataset source]

Watch Continue reading “How to create a quick Sales Dashboard in Power BI?”

Trick – How to make variance charts in Power BI?

Power BI is great for visualizing and interacting with your data. In this article, let me share a technique for creating variance chart in Power BI. Variance charts are perfect for visualizing performance by comparing Plan vs. Actual or Budget vs. Actual data.

This is what we are going to Continue reading “Trick – How to make variance charts in Power BI?”

[Bonus] Split an Excel file to many sheets

Note: This is one of the many bonus lesson videos. You cannot download these videos, but you can view them anytime (they are all hosted on YouTube).

Not your usual VBA tutorial, this in-depth video shows you how to solve a practical automation problem using VBA.

Learn how to Continue reading “[Bonus] Split an Excel file to many sheets”

[Bonus] Web Analytics Dashboard with Excel

Note: This is one of the many bonus lesson videos. You cannot download these videos, but you can view them anytime (they are all hosted on YouTube).

Do you want to build a dashboard but don’t want to spend hours crafting it? You can use features like conditional formatting, Continue reading “[Bonus] Web Analytics Dashboard with Excel”