Chandoo.org Podcast - Become Awesome in Data Analytics

In the 12th session of Chandoo.org podcast , lets get productive fast. Announcement: Short format podcasts sessions once a month Based on listener feedback, I am adding short format sessions (20 mins). This short format sessions will run once a month (along with longer sessions that we publish almost every week) so that you have something light & easy to chew between heavy doses of Excel aweso...

If you want to create magical effect with your Excel workbook (or report, dashboard, model), then hear no further. In this episode, we explore 5 very powerful magic tricks you can apply to get jaw dropping reactions from your bosses, clients & colleagues. In this podcast, you will learn, Annoucements Why magic 5 Excel Magic Tricks 1: Conditional formatting 2: Form controls + Charts 3: Pivot t...

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: Visu...

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 statist...

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...

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(), bu...

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 o...

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...

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 ch...

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...

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 function...

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...