Chandoo.org Podcast - Become Awesome in Data Analytics

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 cyclical strange Doing trend analysis in Excel - the process How to use trend analysis results Conclusions The post CP036: How to do trend analysis using Excel? appeared first on Chandoo.org - Learn Ex...

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 be part of Chandoo.org podcast and he was kind enough to agree. So today let's take a trip down the memory line, hear him talk about some of the fascinating all the early development stories of Solve...

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, finally I met him at PASS BA conference at Santa Clara this week. He gave me a copy of his new book - Advanced Excel Essentials and I immediately asked him to do a podcast. So here we go. What is in th...

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 hidden in the podcast audio) Collection of Excel tips recorded & submitted by Chandoo.org readers Listen to this session Click here […] The post CP033: There is an Easter egg in this podcast!!! a...

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 beautiful & insightful column charts all the time. Do you know the simple rules that can help you create legendary column charts? That is our topic for this podcast session. In this podcast, you will...

In the 31st session of Chandoo.org podcast , let's disa ppea r . What is in this session? Spreadsheets are complex things. They have outputs, calculation tabs, inputs, VBA code, from controls, charts, pivot tables and occasional picture of hello kitty. But when it comes to making a workbook production ready, you may want to hide away few things so it looks tidy. That is our topic for this podcast...

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 constantly second guessing every source of data. So how do you answer a simple question like, "am I being lied to?" while looking at a set of numbers your supplier has sent you. That is our topic for...

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. They go to boss with  literally  flying colors. The boss frowns, they disappear in to recycle bin. Don't curse your Excel charts with short life span. Here is a 6 step road map to help you create awes...

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

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? We all get fresh dose of energy, enthusiasm & drive during new years. So we aim for bigger & more awesome things. But once the first few weeks are over, we just settle down to the normal rh...

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 filled with hope, energy and awesomeness. I want to tell you how thankful I am for all your support in this year. Every time you visit our website, read an article, leave a comment, enroll in a course...

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 operators? That is right. There are a variety of operators beyond the simple + - * and /. In this podcast, let's understand all about these operators and how to use them. You will learn, Why there is...

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 from it too. This happens because we spend all our attention creating that perfect workbook, report or model. And then, we forget about making the proper print settings. In this podcast, let's under...

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. That's not fair. Shouldn't the Excel of an accountant be different from Excel of a teacher? In this podcast, lets understand some of the powerful & useful ways to customize Excel so that we can do...

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 & aftermath of destructing Hudhud cyclone that recently (on 12th October) passed thru our city. Hopefully, you still find it interesting & inspiring. If you are expecting some Excel tips, chec...

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 it and get you started with the awesome world of automation. In this podcast, you will learn, What is a macro? What is VBA then? Reasons for using VBA Macros Automation Extending Excel's capabilities...

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 we waste hours. So in this episode, I share my top secret comparison techniques to save you time. Note: This is a short format podcast. That means you spend less time listening to it, while becomin...

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 can only get you so far. So what about the real productive strategies? That is what we address in this podcast. In this podcast, you will learn, Announcements 5 key areas of business analyst work -...

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-women - Danielle Stein Fairhurst for this session. I first met Danielle when I went to Sydney, Australia in April 2012. Our friendship & collaboration grew a lot in the last 2.5 years. She is a...

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 tables are a very powerful & quick way to analyze data and get reports from Excel. But surprisingly, not many use them. Today, lets bust your pivot table virginity and understand the concepts lik...

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 this podcast, you will learn, About Paul Ten tips for MS Office 1. Use Excel to communicate instead of just calculations 2. Paste Special 3. Double click trick! 4. Inserting screenshots 5. Turning o...

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 graduates are reporting to their first day of work as analysts. But to succeed as an analyst? By learning & practicing of course. And books play a vital role in opening new pathways for us. They c...

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 responded to this call and sent in their questions. Since answering all the questions is not possible, I handpicked roughly 10 questions to answer in this episode of Chandoo.org podcast. In this podcast, y...

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 Excel & growing pressure on costs. Now a days, analysts & managers are expected to quickly put together a dashboard using Excel. But how do you make a dashboard? What process you should follow?...

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 FIFA worldcup? " and used various charts & analysis techniques to answer the question. In podcast, lets tackle the same problem, understand various approaches to answer questions like these &#38...