Chandoo.org Podcast - Become Awesome in Data Analytics

Bill Jelen is one of my most favorite people on earth. That is why I wanted to have him as my first guest when I restarted the podcast. Even though I recorded this few weeks ago, only now I got around...

On the left side, we have a veteran warrior with 37 years of data battle scars and redundant six pack. They call him SQL. On the right side, there is a young challenger with transformative powers and...

Power BI is one of the most prominent data analytics technology out there. Power BI is also one of the most marketed and hyped technology out there. Unfortunately, both of these statements are true. I...

So you want a 6 figure data job? In this podcast episode, I am going to share 6 strategies and tactics to land a $100k+ data job. The post CP02: Six Tips to get a Six Figure ($100,000+) Data Job appe...

Ladies & gentlemen... I have an exciting announcement. I am relaunching my podcast!!! It only took me 7 years, but Chandoo.org podcast is now BACK! I am planning to make regular episodes on Excel...

In the 56th episode of Chandoo.org podcast, let me answer the chicken and egg question of Excel users. How many formulas should you care to learn? What is in this session? In this podcast, Two person...

Ladies & gentlemen, its time we revived the much loved Chandoo.org podcast. In the 55th episode, I do a lousy imitation of Arnold Schwarzenegger's famous "I will be back" and tell you why there wa...

In the 54th session of Chandoo.org podcast, let's make you awesome in Pivot Tables. What is in this session? In this podcast, Quick updates Top 10 pivot table tricks Adding same value field twice Ta...

In the 53rd session of Chandoo.org podcast, let's talk about data validation. What is in this session? In this podcast, What is data validation How Excel DV compares with database & software DV? ...

In the 52nd session of Chandoo.org podcast, let's discuss monkeys, Ok, I am kidding. We are going to talk about M is for Data Monkey book. What is in this session? In this podcast, Updates: Why so mu...

In the 51st session of Chandoo.org podcast, let's discuss most frequently asked questions about VLOOKUP. What is in this session? In this podcast, What is VLOOKUP? What happens when VLOOKUP can't fin...

This is going to be epic!!! In the 50th session of Chandoo.org podcast, we have 50 Excel tips to make you awesome. What is in this session? In this podcast, Thank you message Fifty tips in 5 buckets ...

In the 49th session of Chandoo.org podcast, let's talk about data dumps! What is in this session? In this podcast, What is a data dump Examples of data dump Why we dump Ways to avoid data dumps Go f...

In the 48th session of Chandoo.org podcast, let's make some animated charts!!! What is in this session? In this podcast, Announcements Why animate your charts? Non-VBA methods to animate charts Exce...

In the 47th session of Chandoo.org podcast, let's see how Excel can make you an awesome entrepreneur. What is in this session? In this podcast, Why Excel for entrepreneurs Key areas of a business own...

In the 46th session of Chandoo.org podcast, let's talk about gantt charts and project plans. What is in this session? In this podcast, A brief intro to Excel 2016 What is a Gantt chart? How Gantt cha...

In the 45th session of Chandoo.org podcast, let's get in to Monte Carlo simulations. What is in this session? In this podcast, Quick personal updates - 200km BRM and book delay History of Monte Carlo...

In the 44th session of Chandoo.org podcast, let's talk about failures. What is in this session? In this podcast, Book announcement about Dashboards for Excel Story of my first ever dashboard Importan...

In the 43rd session of Chandoo.org podcast, let's talk about top time saving features of Excel. What is in this session? In this podcast, Quick announcement about Awesome August My 9 favorite time sa...

In the 42nd session of Chandoo.org podcast, Let's talk about money. We are going to learn about various concepts that are vital for doing financial analysis and building models. What is in this sessio...

In the 41st session of Chandoo.org podcast, Let's take a trip to data hell and meet 6 ugly, clumsy, confusing charts. I am revisiting a classic Chandoo.org article - 6 Charts you will see in hell. Wha...

In the 40th session of Chandoo.org podcast, Let's talk about Power Query. I have the pleasure and fortune to catch up with Miguel Escobar (who along with Ken Puls runs PowerQuery.Training website) and...

In the 39th session of Chandoo.org podcast, Let's learn about FOR loops. There is a special giveaway in this podcast. It is a workbook with several FOR loop VBA code examples. Listen to the episode fo...

In the 38th session of Chandoo.org podcast, Let's optimize data to ink ratio of your charts. What is in this session? In this podcast, Announcements What is Data to Ink Ratio? Obvious ways to optimiz...

In the 37th session of Chandoo.org podcast, Let's debug 'em #VALUEs & #N/As. What is in this session? In this podcast, Introduction to Excel formula errors The easy kind: syntax errors The triky ...

In the 36th session of Chandoo.org podcast, Let's follow the trend. What is in this session? In this podcast, A quick trip to down under What is trend analysis 4 types of common trends linear curve ...

In the 35th session of Chandoo.org podcast, Let's hear from Dan Fylstra, the creator of Excel Solver. I had the fortune of meeting Dan when I was in Santa Clara last month. I immediately asked him to ...

In the 34th session of Chandoo.org podcast, Let's hear from Jordan Goldmeier - my friend, fellow blogger, Excel blogger & author. After many years of interaction thru email, blogs, Skype calls, fi...

In the 33rd session of Chandoo.org podcast, let’s turn the mic to our listeners and hear their tips. What is in this session? This session has 2 things. A surprise Easter egg (an Excel tip hidde...

In the 32nd session of Chandoo.org podcast, let's make legendary column charts. What is in this session? Column charts are everywhere. As analysts, we are expected to create flawless, strikingly beaut...

In the 31st session of Chandoo.org podcast, let's disappear. What is in this session? Spreadsheets are complex things. They have outputs, calculation tabs, inputs, VBA code, from controls, charts, piv...

In the 30th session of Chandoo.org podcast, let's learn how to uncover fraud in data. What is in this session? In the wake of hedge fund scams, accounting frauds and globalization, We, analysts are c...

In the 29th session of Chandoo.org podcast, let's impress the boss with Excel charts. What is in this session? Many Excel charts live a short life. They spawn in an ambitious analyst's spreadsheet. Th...

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

In the 27th session of Chandoo.org podcast, let's pave way for an awesome 2015. We are going to talk about 15 proven strategies for making you awesome in Excel & Your work. What is in this session...

A big, warm & pleasant hello to you. I wish you a merry Christmas & Happy New Year 2015. May your holidays be filled with joy, togetherness, celebrations and fulfillment. May your new year be ...

In the 26th session of Chandoo.org podcast, let's learn all about Excel !@#$%^+/*(}][<. I am talking about Excel operators, you silly. What is in this session? Do you know Excel has more than 25 o...

In the 25th session of Chandoo.org podcast, let's learn how to avoid SSUP syndrome. What is in this session? Most of us suffer from Sexy on the Spreadsheet, Ugly on Printout syndrome. I used to suffer...

In the 24th session of Chandoo.org podcast, let's customize Excel so we become productive. What is in this session? Each of us use Excel in our own way. And yet, we all end up using the same Excel. Th...

In the 23rd session of Chandoo.org podcast, lets talk about my experience with Hudhud cyclone. Note: This podcast session has no Excel tips. It is a story of how our family is surviving the effects ...

In the 22nd session of Chandoo.org podcast, lets do some macros. What is in this session? VBA (or macros, automation) is a mystery for many of us. So in this podcast, lets unravel the mystery behind...

In the 21st session of Chandoo.org podcast, lets compare lists. Quickly What is in this session? Comparing things is a favorite pastime for analysts all over the world. Sadly, it is also an area where...

In the 20th session of Chandoo.org podcast, lets save some time. What is in this session? We all want to save time and stay productive. The obvious answer seems like using keyboard shortcuts. But they...

In the 19th session of Chandoo.org podcast, lets talk about modeling best practices. What is in this session? I am very happy to interview my good friend, blogger, author, excel trainer & business...

In the 18th session of Chandoo.org podcast, lets loose your Pivot table virginity. Note: This is a short format episode. Less time to listen, but just as much awesome. What is in this session? Pivot ...

In the 17th session of Chandoo.org podcast, lets leave Excel aside and talk about other MS Office apps. Thats right. We will be learning 10 tips on how to use Word, Power Point, Outlook etc. Ready? In...

In the 16th session of Chandoo.org podcast, lets review 3 very useful books for aspiring analysts. What is in this session? Analytics is an increasingly popular area now. Every day, scores of fresh gr...

In the 15th session of Chandoo.org podcast, lets answer some of your burning Excel questions. What is in this session? Around last week, I invited you to ask me anything. More than 150 people respond...

In the 14th session of Chandoo.org podcast, lets figure out how to make awesome dashboards. What is in this session? Excel based dashboards are much in demand these days, thanks to advancements in Exc...

In the 13th session of Chandoo.org podcast, lets turn our attention to on-going FIFA worldcup and ask an important question. What is in this session? A week ago, we discussed "Has it been a late goal...