All articles with 'podcast' Tag

CP045: Introduction to Monte Carlo Simulations in Excel

Published on Sep 24, 2015 in Chandoo.org Podcast Sessions
CP045: Introduction to Monte Carlo Simulations in Excel

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 simulations
  • Monte Carlo simulations – an example
  • How to do simulations in Excel
    • Formulas
    • VBA
    • Data Tables
  • Using data tables to run simulations – case study – estimating Pi value
  • Things to keep in mind when setting up your simulation models
  • Resources on Monte Carlo simulations in Excel
  • Conclusions
Continue »

CP036: How to do trend analysis using Excel?

Published on Jun 11, 2015 in Chandoo.org Podcast Sessions, Charts and Graphs
CP036: How to do trend analysis using Excel?

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
Continue »

CP033: There is an Easter egg in this podcast!!!

Published on Apr 9, 2015 in Chandoo.org Podcast Sessions
CP033: There is an Easter egg in this podcast!!!

http://traffic.libsyn.com/chandoo/CP033.mp3Podcast: Play in new window | DownloadSubscribe: Apple Podcasts | Android | RSSIn 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 […]

Continue »

CP032: Rules for making legendary column charts

Published on Apr 2, 2015 in Chandoo.org Podcast Sessions, Charts and Graphs
CP032: Rules for making legendary column charts

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 learn

  • Few personal announcements
  • Rule 0: Start at zero
  • Rule 1: Sort the chart
  • Rule 2: Slap a title on it
  • Rule 3: Axis + grid-lines vs. Lables
  • Rule 4: Moderate formatting
  • Conclusions
Continue »

Share your favorite Excel tip & you could win Beats Headphones [Podcast Anniversary Celebrations]

Published on Mar 13, 2015 in Learn Excel

Yay, bring out the birthday hats, candles, cake & confetti. Chandoo.org podcast is 1 year old.

In this one year, we had 31 sessions, 4 guest appearances, 390,000 downloads & lots of 5 star reviews. Thank you so much for making it a grand success so far.

To celebrate the occasion, I want to reward 3 lucky listeners of our podcast.

How to participate in this contest?

  1. Simple. Figure out what your favorite Excel tip is.
  2. Open your smart phone’s voice recorder app
    1. on iPhone use the Voice Memos app
    2. on Andriod use sVoice or voice recorder widgets
    3. If you cant find these apps, just Google record audio <your phone name>
  3. Record the tip (less than 3 mins duration)
  4. Please say your name at the end of recording.
  5. Send the audio file by email to hello@chandoo.org
  6. Do so before end of day 16 March 2015 (Monday)

Once I collect all the tips, I will feature some of them in next episode of Chandoo.org podcast.

Continue »

CP027: 15 proven strategies to be awesome in 2015

Published on Jan 8, 2015 in Chandoo.org Podcast Sessions
CP027: 15 proven strategies to be awesome in 2015

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 rhythm and forget about these big, hairy & audacious goals.

Let’s make 2015 different. In this podcast, Let’s understand how you can become awesome in Excel & your work this year, with 15 proven strategies:

  • Announcements – my new year & plans for next few months
  • Becoming awesome – 3 important areas of focus
  • Learning
    • New formulas
    • New features
    • Different charts
    • Macros
    • Linkup Excel with other software
    • Get a book
    • Join a course
  • Application
    • Take up a work project
    • Consulting
    • Mimic a chart in Excel
    • Beyond XL – Power Pivot etc.
  • Sharing
    • Forums
    • Helping a colleague
    • Comment on blogs
    • Train your team
Continue »

CP026: All about Excel !@#$%^+/*(}][<

Published on Dec 4, 2014 in Chandoo.org Podcast Sessions
CP026: All about Excel !@#$%^+/*(}][<

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 a gap between last & this podcast session
  • About Excel operators
  • Arithmetic operators
  • Text operators
  • Reference operators
  • Comparison operators
  • Closing thoughts
Continue »

CP025: Sexy on spreadsheet, Ugly on Printout

Published on Nov 6, 2014 in Chandoo.org Podcast Sessions
CP025: Sexy on spreadsheet, Ugly on Printout

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 understand how to create awesome workbooks that look great and print great.

In this podcast, you will learn,

  • Frozen & Cars, where my free time goes
  • Primer on print settings
    • Width & height of printouts
    • Page breaks
    • Row & column repetitions on every page
    • Size & orientation of paper
  • Dealing with unprintables
  • Proofing your print settings
  • Printing whats not on screen
  • Closing thoughts
Continue »

CP024: Customize Excel to boost your productivity

Published on Oct 30, 2014 in Chandoo.org Podcast Sessions, Learn Excel
CP024: Customize Excel to boost your productivity

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 our work better. Tune in only if you are serious about productivity.

You can get Excel Customization Handbook free. Listen to the podcast for instructions.

In this podcast, you will learn,

  • Announcements
  • Why customize Excel?
  • Customization options:
    • Excel Options
    • Quick Access Toolbar
    • Excel Ribbon
    • File menu / back stage view
    • Themes, styles & templates
    • Personal Macros
  • Closing thoughts & Bonus give away instructions
Continue »

CP023: My experience with Hudhud Cyclone [personal story]

Published on Oct 16, 2014 in Chandoo.org Podcast Sessions, personal

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, check again next week.

 

What is in this session?

Growing up, I lived all my childhood in coastal cities. So cyclones & severe storms are not new to me. But first time, I have experienced anything as severe, destructive & long as Cyclone Hudhud. After the cyclone, we (our family and 1000s of other families in Vizag, our city) had to endure days with no power, water, cellular signals and access to essential supplies. Fortunately, great progress has been made in the last few days and things are restoring to normalcy. We (our locality) is expecting to have power & regular water supply by this Sunday (19th of October).

Continue »

CP022: What’s a Macro? Introduction to Excel VBA, Macros & Automation

Published on Oct 9, 2014 in Chandoo.org Podcast Sessions, VBA Macros
CP022: What’s a Macro? Introduction to Excel VBA, Macros & Automation

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
    • Efficiency
    • Applications
  • How to get started with VBA Macros?
  • Using Recorder
  • Example Macro
  • Going beyond recorder – Learning VBA
Continue »

CP021: How to quickly compare 2 lists in Excel

Published on Oct 2, 2014 in Chandoo.org Podcast Sessions, Excel Howtos
CP021: How to quickly compare 2 lists in Excel

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 becoming more awesome.

In this podcast, you will learn,

  • Why I sound like I am on a secret mission at a mafia hideout.
  • 5 ways to compare 2 lists
    • Manual method
    • Conditional Formatting
    • Row Differences
    • LOOKUP formulas
    • COUNTIF formulas
  • Bonus tip: Removing duplicates
  • Conclusions
Continue »

CP020: Top 10 time saving strategies for business analysts

Published on Sep 18, 2014 in Chandoo.org Podcast Sessions, Learn Excel
CP020: Top 10 time saving strategies for business analysts

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 – tracking, analysis, reporting, data management & modeling
  • Time saving strategies for tracking
  • for analysis
  • for reporting
  • for data management
  • for modeling
  • Conclusions
Continue »

CP019: 6 Tips for Best Practice Modeling – Interview with Danielle from Plum Solutions

Published on Sep 4, 2014 in Chandoo.org Podcast Sessions
CP019: 6 Tips for Best Practice Modeling – Interview with Danielle from Plum Solutions

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 great speaker & trainer. This episode is loaded with her trademark style commentary, explanation & tips for better modeling. I hope you will enjoy it.

In this podcast, you will learn,

  • Introduction to Danielle & her work
  • 6 Tips for Best Practice Modeling
    • Write consistent formulas
    • Avoid hard-coding
    • Smart referencing
    • Ditch the bad habits
    • Document assumptions
    • Format & label things
  • Resources for learning more
Continue »

CP018: Dont be a Pivot Table Virgin!

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.

CP018: Don't be a Pivot Table Virgin! - Introduction to Excel Pivot Tables - Chandoo.org Podcast

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 like pivoting, values, labels, filters, groups and more.

In this podcast, you will learn,

  • Announcements
  • What is a Pivot Table?
  • Example of business data & reporting needs
  • Key pivot table terms to understand
  • Creating your first pivot table
  • Learning more about pivot tables
Continue »