Become Awesome in Excel by Chandoo.org - A podcast aimed to teach you data analysis, charting, visualization, dashboard reporting, big data analysis, Power Pivot, Self-service BI, Excel based spreadsheet-modeling, automation thru VBA, macros, project management, business analysis, interactive & dyanmic graphs, pivot tables, Excel formulas, functions, calculations, summarizing data, Excel formatting, shortcuts, productivity, application development, beginner to advanced Excel skills, excel tips, techniques, tutorials and templates. We do this by providing you with spreadsheet design strategies & tactics, Excel tips, keyboard shortcuts, productivity hacks, case studies, personal experiences, interviews with Excel authors & Microsoft MVPs, book & product reviews related to Excel and answering your Excel questions & doubts.
https://chandoo.org/wp/category/podcast/
Gesamtlänge aller Episoden: 1 day 12 hours 52 minutes
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, -
CP040: Intro. to Power Query – What is it and how to get started – with Miguel Escobar
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 a...
CP039: May the FOR Loop be with you – Introduction to For Loops in Excel VBA
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?
CP038: Data to Ink Ratio – What is it, How to optimize it, Techniques & Discussion
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
CP037: Error error on the wall, How do I fix you all? – Understanding & Fixing Excel Errors
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
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
CP035: on Solver, its story and future – Interview with Dan Fylstra
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.
CP034: Advanced Excel Essentials book talk with Jordan Goldmeier
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 thi...
CP033: There is an Easter egg in this podcast!!!
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 ...
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.