Online Classroom – Chandoo.org
Excel | Power BI | SQL | Coding | VBA and More
Now that you have create a few measures in Power Pivot, let’s use them to tell the staffing story by department. In this lesson, we will focus on,
This is a continuation of our discussion about DAX. In this lesson, we will explore themes about,
We will continue using the Employee Data set from previous lesson to build DAX understanding. In this lesson, learn all about:
Duration:[28 mins]
In this lesson, we will understand the dynamic and powerful nature of Power Query, dabble a bit with Power Pivot data modeling and create simple visuals to analyze US population.
Hello and welcome to Power BI. This is our first play date. The goal is to become comfortable with Power BI Desktop software, understand how to navigate it and create something beautiful in minutes. This lesson has two parts. Before you begin, I suggest downloading the sample data so you Continue reading “Getting Started with Power BI”
So far you have learned many useful techniques and ideas in the program. In this top 10 list, let me share my favorite Excel features for saving time.
So far you’ve learned how to use Excel to do awesome things. In this lesson, let’s focus on how to customize Excel so that you can do what you want without wasting clicks or minutes.
You have learned how to create a drop-down box in Excel in the data validation lesson. In this lesson, let’s understand how to construct two level cascading drop-down. Something like this:
We all know VLOOKUP can match first result. But what if you want all the matching results in a cell? Simple, use this trick.
This is a follow-up lesson to Introduction to Conditional Formatting.