All articles with 'podcasts' Tag

CP056: So which formulas you should care to learn?

Published on Oct 27, 2016 in Chandoo.org Podcast Sessions
CP056: So which formulas you should care to learn?

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 personal updates
  • 3 legs of formula writing
    • Function knowledge
    • Operators
    • Referencing
  • 6 categories of must-know functions
    • Basic math
    • Conditions
    • Lookups
    • Text
    • Date & time
    • Work specific
  • Closing remarks & resources for you
Continue »

CP055: “Yes, I am back” edition (and a bonus Excel tip)

Published on Oct 13, 2016 in Chandoo.org Podcast Sessions
CP055: “Yes, I am back” edition (and a bonus Excel tip)

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 was such a long gap between episodes, my plans for reviving our podcast and more.

What is in this session?

In this podcast,

  • Why there was such a long gap between last and this episode
  • What next?
  • How to extract every 6th item from a list?
Continue »

CP054: Top 10 Pivot Table Tricks for YOU

CP054: Top 10 Pivot Table Tricks for YOU

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
    • Tabular layouts
    • GETPIVOTDATA & 2 bonus tricks
    • Relationships & data model
    • One slicer to rule them all
    • Show only top x values
    • Relative performance
    • Show unique count
    • Spruce up with conditional formats
    • Not so ugly pivot charts
  • Resources & Show notes for you
Continue »

CP053: Excel Data Validation for Dummies

Published on Mar 10, 2016 in Chandoo.org Podcast Sessions
CP053: Excel Data Validation for Dummies

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?
  • Types of data validation rules
  • List & custom rules explained
  • Input & error messages
  • Alternatives to data validation
  • Enhancing data validation
  • Removing data validation rules
  • Homework problem for you
  • Resources & show notes
Continue »

CP052: Book Review – M is for Data Monkey by Ken & Miguel

Published on Feb 11, 2016 in Chandoo.org Podcast Sessions, Power Query
CP052: Book Review – M is for Data Monkey by Ken & Miguel

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 much gap between episodes?
  • Quick introduction to Power Query
  • Why you should get this book?
  • What is in this book?
  • A very cool example of the techniques you will learn
  • Conclusions
Continue »

CP051: VLOOKUP FAQs – Most frequently asked questions about VLOOKUP – Answered

Published on Jan 7, 2016 in Chandoo.org Podcast Sessions
CP051: VLOOKUP FAQs – Most frequently asked questions about VLOOKUP – Answered

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 find the value?
  • Should my list be sorted?
  • Is VLOOKUP slower than INDEX + MATCH?
  • What if my list has multiple matches?
  • How to fetch 2nd / 3rd matching item?
  • How to fetch all matching items?
  • How to fetch items matching multiple conditions?
  • How to speed up VLOOKUP?
  • Why doesn’t my VLOOKUP work?
  • What to do in case of errors?
  • Resources for you
Continue »

CP050: Fifty Excel Tips to make you awesome

Published on Dec 3, 2015 in Chandoo.org Podcast Sessions
CP050: Fifty Excel Tips to make you awesome

This is going to be epic!!! In the 50th session of Chandoo.org podcastwe have 50 Excel tips to make you awesome.

What is in this session?

In this podcast,

  • Thank you message
  • Fifty tips in 5 buckets
    • Shortcuts & Productivity
    • Formulas
    • Managing Data
    • Charts
    • Using Excel better
Continue »

CP049: Don’t do data dumps!!!

Published on Nov 19, 2015 in Chandoo.org Podcast Sessions, Charts and Graphs
CP049: Don’t do data dumps!!!

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 for information dumps
    • Sort the dump
    • Filter the dump
    • Give a table
  • Resources for you
Continue »

CP048: How to create animated charts in Excel?

CP048: How to create animated charts in Excel?

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
    • Excel 2013’s built-in animation effects
    • Iterative formula approach
  • VBA based animation
    • Cartoon film analogy
    • Understanding the VBA part
  • Example animated chart – Sales of a new product
  • Resources and downloads for you
Continue »

CP047: Best Excel tools for Entrepreneurs

CP047: Best Excel tools for Entrepreneurs

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 owner’s work
    • Projects & to dos
    • Finances
    • Customers & marketing
    • Planning & strategy
    • Processes & workflows
  • 5 features of Excel that help
  • Conclusions
Continue »

CP046: Gantt charts & project planning using Excel

Published on Oct 8, 2015 in Chandoo.org Podcast Sessions, Charts and Graphs
CP046: Gantt charts & project planning using Excel

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 charts can help us?
  • How to create Gantt charts in Excel
    • Using bar charts with invisible series
    • Using conditional formatting and formulas
    • Using ready-made templates
  • Resources on Gantt charts & project planning
  • Conclusions
Continue »

CP044: My first dashboard was a failure!!!

Published on Sep 10, 2015 in Chandoo.org Podcast Sessions
CP044: My first dashboard was a failure!!!

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
  • Important lessons – Requirement Analysis for dashboards
  • Resources for creating awesome dashboards
    • Podcasts
    • Books
    • Courses
Continue »

CP043: My favorite time saving features of Excel, Revealed.

Published on Aug 27, 2015 in Chandoo.org Podcast Sessions
CP043: My favorite time saving features of Excel, Revealed.

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 saving features of Excel
  • Remove Duplicates
  • Tables
  • Pivot Tables
  • Auto fill
  • Format Painter
  • Find & Replace
  • VBA / Macro Recorder
  • Auto save
  • Auto complete / Intellisence
  • Recap & Conclusions
Continue »

CP042: Financial Analysis & Modeling concepts – 101

Published on Aug 13, 2015 in Chandoo.org Podcast Sessions, Financial Modeling
CP042: Financial Analysis & Modeling concepts – 101

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

CP041: 6 charts you’ll see in hell – v2.0

Published on Aug 6, 2015 in Chandoo.org Podcast Sessions, Charts and Graphs
CP041: 6 charts you’ll see in hell – v2.0

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