App Store

Google Play

SE - Details page - Device banner - 894x1036

Kliv in i en oändlig värld av stories

Lyssna när som helst, var som helst

Training & Data Analysis Specialist

Chandoo - Microsoft Excel MVP

Want to be an AWESOME DATA ANALYST? Chandoo.org Podcast is the place to go. Learn how to use popular Data Analytics software like Power BI, Excel, SQL and more with your host Chandoo – an award winning author, speaker and YouTuber.

Chandoo.org Podcast - Become Awesome in Data Analytics

Chandoo.org Podcast is here....

Friends, fans & supporters of Chandoo.org,

I am so happy to add another dimension to our website. Chandoo.org podcast is finally here. You can listen to the inaugural episode by using the audio player above.

The post CP 001: Chandoo.org Podcast First Episode – Introduction, What to expect, Show formalities & Special gift appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

CP 001: Chandoo.org Podcast First Episode – Introduction, What to expect, Show formalities & Special gift

In the second session of Chandoo.org Podcast, We will be learning how to use 5 Excel lookup functions. 

What is in this session?

In this session, we tackle one of the most important areas of Excel. The lookup functions.

You will learn,

 • Why lookup functions are necessary

 • 5 Important lookup functions in Excel - VLOOKUP, HLOOKUP, LOOKUP, MATCH & INDEX

 • When & how to use each of these 5 functions?

 • Extreme scenarios: 

 • What happens when the value you are looking up is not there?

 • What if too many items match the lookup value?

 • What if you have too many conditions in the lookup criteria?

 • 

 • Using IFERROR function

 • Re-cap of the new powers you acquired

 • 4 Resources for you to learn lookup functions better

The post CP002: VTALKUP – 5 Excel lookup functions demystified + 4 Resources for you appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

CP002: VTALKUP – 5 Excel lookup functions demystified + 4 Resources for you

In the third session of Chandoo.org podcast, we are going to get BI curious. ;)

Not that kind you silly, We are talking about Business Intelligence, Big Data, Power Pivot & other Power BI family members. In this session, I am happy to feature Mike Alexander - Microsoft MVP, Author, Blogger & a good friend. Mike talks about how Excel is shaping the BI (Business Intelligence) revolution with advent of Power BI functionality.

You will learn,

 • Introduction, what Mike is up to these days?

 • What is BI, what does it mean to an average Excel analyst?

 • What BI capabilities Excel has - brief intro to each of them 

 • Power Pivot & what it does

 • Power Query & why it is important

 • Power View & how it works (and where it sucks)

 • Power Maps

 • 

 • How to learn about these new technologies 

 • Recommended Books

 • Websites

 • Courses

 • Live classes

 • 

 • Special gift for our listeners

The post CP003: Business Intelligence for Masses – Interview with Mike Alexander appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

CP003: Business Intelligence for Masses – Interview with Mike Alexander

In the 4th session of Chandoo.org podcast, lets talk about Pie charts.

Pie charts evoke strong opinions among analysts & managers. Some people love them and can't have enough of them in reports. Others despise them and go to any lengths to avoid them. And that is why we are going to talk about them in this session.

You will learn,

 • Special, secret transmission from guest stars

 • What is a pie chart?

 • Why they work? 2 reasons

 • Why they don't work ? 4 reasons

 • Cousins & siblings of Pie charts 

 • Donut charts

 • Gauge charts (speedometer)

 • 3D pies

 • Area charts

 • Bubble charts

 • 

 • 4 Situations when making a pie chart is ok

 • Alternatives to Pie charts

 • Mistakes you should avoid

 • About the resources

 • Conclusions

The post CP004: Can I Pie Chart in Public? Discussion about Pie charts, their merits and drawbacks, when to use & when to avoid them appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

CP004: Can I Pie Chart in Public? Discussion about Pie charts, their merits and drawbacks, when to use & when to avoid them

In the 5th session of Chandoo.org podcast, we are going to demystify form controls.

I am very happy and excited to interview my good friend, fellow Excel MVP, author, blogger and virtual mentor - Debra Dalgleish about this topic.

In this podcast, you will learn,

 • What are form controls

 • When you would use them?

 • Example form control - Combo box

 • How form controls differ from active-x controls

 • How to enable form controls in your Excel?

 • Various important form controls

 • Special bonus & how to obtain it

The post CP005: Introduction to Form Controls – an interview with Debra Dalgleish appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

CP005: Introduction to Form Controls – an interview with Debra Dalgleish

In the 6th session of Chandoo.org podcast, we focus on making you a better analyst and propose a road map for getting better at data analysis & improving your career prospects.

In this podcast you will learn,

 • Why become a better analyst?

 • The road map for becoming a better analyst - BETTER framework

 • B for Business Knowledge

 • E for Examining user needs

 • T for Thinking about analysis

 • T for Tools of Trade 
ie • Excel

 • E for Expression

 • R for Refining yourself

 • Conclusions

The post CP006: How to be a better analyst? – Road map for getting better at Data Analysis & Improving your career prospects appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

CP006: How to be a better analyst? – Road map for getting better at Data Analysis & Improving your career prospects

In the 7th session of Chandoo.org podcast, lets make you aweSUM().

Imagine for a second that Excel cannot add up numbers. And no it cant subtract them either. What would that look like?

A glorified Notepad. That's right. Excel's ability to add up numbers, along with features like formulas, charts, pivot tables & BHATTEXT() are what make it such a lovely software. May be not the BHATTEXT(), but we all agree that Excel is so versatile and useful because it can add up numbers (and perform other calculations) with ease.

But how well do you know the SUM formulas of Excel?

In this podcast, you will learn,

 • Special personal fruit announcement :P

 • + operator

 • Status bar & total rows in tables

 • Auto Sum feature

 • SUM() function

 • SUMIFS function

 • Special cases of SUMIFS function

 • SUBTOTAL & AGGREGATE functions

 • Other summing functions - SUMPRODUCT etc.

The post CP007: aweSUM() – Overview of SUM functions in Excel appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

CP007: aweSUM() – Overview of SUM functions in Excel

Here is a problem we all face once in a while. We inherit this bulky, bloated, leaking at the edges workbook from a colleague. Now the onus of maintaining it is on us. The person who made this workbook is nowhere to be found. May be she is vacationing in Hawaii sipping pineapple juice. May be he became a vice president and roaming the country in your company's private jet.

So what do we do? How do we handle this inheritance? 

That is the topic of our podcast, episode 8.

In this podcast, you will learn,

 • An overview of the inheritance problem

 • 6 Tips to understand workbooks made by someone else

 • Tip 0: Talk to the creator

 • Tip 1: Model the workbook on paper

 • Tip 2: Locate the engine, 
ie the formulas
 • Tip 3: See what else is under the hood - hidden sheets, names, VBA code

 • Tip 4: Annotate (add comments) as you learn

 • Tip 5: Locate the controls - inputs, assumptions, scenarios

 • Tip 6: Re-construct from scratch

 • Deep dive in to understanding the formulas

 • Deep dive in to understanding VBA code

 • Conclusions

The post CP008: 6 Tips to handle workbooks made by someone else, #4 is something I struggle with too! appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

CP008: 6 Tips to handle workbooks made by someone else, #4 is something I struggle with too!

In the 9th session of Chandoo.org podcast, lets raise above AVERAGEs.

AVERAGEs are a very popular and universal way to summarize data. But do you know they are mean? Mean as in, AVERAGEs do not reveal much about your data or business. In episode 9 of Chandoo.org podcast, we tackle this problem and present solutions.

In this podcast, you will learn,

 • What is AVERAGE?

 • Pitfalls of averages

 • 5 statistic concepts you must understand 

 • Standard Deviation

 • Median

 • Quartiles

 • Outliers

 • Distribution of data

 • 

 • What next?

The post CP009: Averages are Mean – Know these things before you make any more AVERAGE()s appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

CP009: Averages are Mean – Know these things before you make any more AVERAGE()s

This is a continuation of Session 9 - Averages are mean

In the earlier episode, we talked about AVERAGE and why it should be avoided. In this session, learn about 8 power analysis techniques that will lift your work above averages.

In this podcast, you will learn,

 • Re-cap - Why avoid averages

 • 8 Techniques for better analysis

 • #1: Start with AVERAGE

 • #2: Moving Averages

 • #3: Weighted Averages

 • #4: Visualize the data

 • ...

 • Conclusions

The post CP010: Averages are Mean – 8 Techniques for making your analysis above average appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

CP010: Averages are Mean – 8 Techniques for making your analysis above average

In the 28th session of Chandoo.org podcast, let's figure out how to express business rules & logic to Excel.

What is in this session?

What good are spreadsheets if they can't solve business problems?

But we all struggle when it comes to modeling real world business conditions in Excel. For example, if you have below business rule to decide how much discount to offer a customer,

 • If the customer bought 3 or more times previously and offer 15% discount

 • If the customer bought 1 or 2 times previously AND customer's age is >40, offer 10% discount

 • If the customer visited our New York store between 6PM-9PM offer 5% discount

 • Else no discount

How would you go about modeling these in Excel?

That is our topic for this podcast session.

In this podcast, you will learn

 • The challenge of modeling business logic & rules in Excel

 • My struggles with such formulas in early days

 • 4 features of Excel that can help you with this.

 • Example business rules & how to write formulas

The post CP028: How to tell business logic & rules to Excel? appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

CP028: How to tell business logic & rules to Excel?

Lyssna när som helst, var som helst

Andra podcasts som du kanske gillar...