All articles with 'podcasts' Tag

Podcast: Play in new window | Download

Subscribe: Apple Podcasts | Spotify | RSS

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 session?

In this podcast,

• Quick announcement about Awesome August
• 5 key finance concepts
  • Time value of money
  • Compound interest
  • Risk free rate of return
  • Net Present Value – NPV
  • Internal Rate of Return – IRR
• Case study – Uber vs. Your car
• Conclusions

Podcast: Play in new window | Download

Subscribe: Apple Podcasts | Spotify | RSS

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.

What is in this session?

In this podcast,

• Quick announcement about Awesome August
• 6 charts you should avoid
• 3D charts
• Pie / donut charts with too many slices
• Too much data
• Over formatting
• Complex charts
• Charts that don’t tell a story
• Conclusions

Podcast: Play in new window | Download

Subscribe: Apple Podcasts | Spotify | RSS

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 talk about this very exciting piece of technology and how it can make our life simpler.

What is in this session?

In this podcast,

• Welcome
• Miguel’s introduction, background and current projects
• What is Power Query
• How to install it
• Sample use cases of Power Query
• What is Power BI
• Resources for learning Power Query – Books & Courses

Podcast: Play in new window | Download

Subscribe: Apple Podcasts | Spotify | RSS

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

What is in this session?

In this podcast,

• Announcements
• What is a loop – plain English & technical definitions
• For Loop vs. other kind of loops (While & Until)
• For Next loops
• For Each loops
• Nested For loops
• Special tips on For loops
• Performance issues & infinite loops
• Conclusions & giveaway

Podcast: Play in new window | Download

Subscribe: Apple Podcasts | Spotify | RSS

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 optimize Data to Ink Ratio
• More ways to optimize Data to Ink ratio
• Highlighting what is important
• Conclusions

Podcast: Play in new window | Download

Subscribe: Apple Podcasts | Spotify | RSS

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 ones: # ERRORs
• Fixing errors – using IFERROR & ISERROR
• Error checking & debug options
• Using Errors deliberately – charts & data validation
• A challenge for you – produce #NULL error
• Conclusions

Podcast: Play in new window | Download

Subscribe: Apple Podcasts | Spotify | RSS

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 Solver, VisiCalc & Excel.

What is in this session?

In this podcast,

• Introduction
• Early days of Solver
• Working with VisiCalc, migration to Excel
• What keeps Dan busy these days
• Advice for anyone planning to learn Solver & business modelling

Podcast: Play in new window | Download

Subscribe: Apple Podcasts | Spotify | RSS

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 this session?

In this podcast,

• Introduction
• What is this book all about
• Sample chapter review – User forms
• Design principles for creating advanced user interactions
• How to become advanced Excel user – pathway recommended by Jordan
• More info about Jordan
• A secret for you

Podcast: Play in new window | Download

Subscribe: Apple Podcasts | Spotify | RSS

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

In this podcast, you will learn

• Quick announcements first anniversary of our podcast etc.
• Hiding cells, rows, columns & sheets
• Hiding chart data points
• On/off effect with form controls, conditional formatting
• Making objects, charts, pictures disappear
• Disabling grid-lines, formula bar & headings
• Hiding things in print

Podcast: Play in new window | Download

Subscribe: Apple Podcasts | Spotify | RSS

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 this podcast session.

In this podcast, you will learn

• Quick announcements about 50 ways & 200k BRM
• Introduction to fraud detection
• 5 techniques for detecting fraud
  • Benford’s law
  • Auto correlation
  • Discontinuity at zero
  • Analysis of distribution
  • Learning systems & decision trees
• Implementing these techniques in Excel
• A word of caution

Podcast: Play in new window | Download

Subscribe: Apple Podcasts | Spotify | RSS

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 awesome Excel charts, everytime.

That is our topic for this podcast session.

In this podcast, you will learn

• Quick announcements about 50 ways & Einstein
• 6 step road map for charting success
• ONE: Dig your data
• TWO: Validate insights
• THREE: Pick charts that go well
• FOUR: Add title & message
• FIVE: Remove clutter
• SIX: Prompt action
• A real life example with road map in action
• Resources for creating awesome charts

Podcast: Play in new window | Download

Subscribe: Apple Podcasts | Spotify | RSS

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

Podcast: Play in new window | Download

Subscribe: Apple Podcasts | Spotify | RSS

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, purchase a product, read one of my books, listen to a podcast episode, watch a video or tell your friends about Chandoo.org, I feel nothing but gratitude, thankfulness and amazement. 2014 is the most successful year since starting Chandoo.org, all thanks to you. Heartfelt thanks to you, from my family, staff and volunteers.

About this year’s holiday card

We took this picture recently when we went to Udaipur (a city in northern India). For a change, no one closed their eyes when the camera clicked.

A holiday gift for you…

Read on to download your special holiday gift.