Tag: pivot tables power bi

Count Distinct Values In Excel: Classic To Modern Approaches

Count Distinct Values In Excel Classic To Modern Approaches

In this tutorial, I’m going to go through different approaches to how you can count distinct values in Excel from a more traditional way to a more modern technique. You can watch the full video of this tutorial at the bottom of this blog. I’ve got a list of names here, and I want to

Continue reading

Proportion And Frequency Tables In Excel

FREQUENCY & PROPORTION TABLES IN EXCEL

In this tutorial, we’re going to dive into frequency tables in Excel as well as proportion tables. We’ll look into what they are and when to use them. You can watch the full video of this tutorial at the bottom of this blog. Categorical variables measure “what kind of something,” whether it’s a customer’s buying

Continue reading