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
CP012: Top 10 Excel Keyboard Shortcuts for you
In the 12th session of Chandoo.org podcast, lets get productive fast. Announcement: Short format podcasts sessions once a month - Based on listener feedback, I am adding short format sessions (20 mins).
CP011: 5 Excel magic tricks to impress your boss
If you want to create magical effect with your Excel workbook (or report, dashboard, model), then hear no further. In this episode, we explore 5 very powerful magic tricks you can apply to get jaw dropping reactions from your bosses,
CP010: Averages are Mean – 8 Techniques for making your analysis above average
This is a continuation of Session 9 - Averages are mean - In the earlier episode, we talked about AVERAGE and why it should be avoided. In this session, learn about 8 power analysis techniques that will lift your work above averages. -
CP009: Averages are Mean – Know these things before you make any more AVERAGE()s
In the 9th session of Chandoo.org podcast, lets raise above AVERAGEs. - AVERAGEs are a very popular and universal way to summarize data. But do you know they are mean? Mean as in, AVERAGEs do not reveal much about your data or business.
CP008: 6 Tips to handle workbooks made by someone else, #4 is something I struggle with too!
Here is a problem we all face once in a while. We inherit this bulky, bloated, leaking at the edges workbook from a colleague. Now the onus of maintaining it is on us. The person who made this workbook is nowhere to be found.
CP007: aweSUM() – Overview of SUM functions in Excel
In the 7th session of Chandoo.org podcast, lets make you aweSUM(). - Imagine for a second that Excel cannot add up numbers. And no it cant subtract them either. What would that look like? - A glorified Notepad. That's right.
CP006: How to be a better analyst? – Road map for getting better at Data Analysis & Improving your career prospects
In the 6th session of Chandoo.org podcast, we focus on making you a better analyst and propose a road map for getting better at data analysis & improving your career prospects. - In this podcast you will learn, Why become a better analyst?
CP005: Introduction to Form Controls – an interview with Debra Dalgleish
In the 5th session of Chandoo.org podcast, we are going to demystify form controls. - I am very happy and excited to interview my good friend, fellow Excel MVP, author, blogger and virtual mentor - Debra Dalgleish about this topic. -
CP004: Can I Pie Chart in Public? Discussion about Pie charts, their merits and drawbacks, when to use & when to avoid them
In the 4th session of Chandoo.org podcast, lets talk about Pie charts. - Pie charts evoke strong opinions among analysts & managers. Some people love them and can't have enough of them in reports. Others despise them and go to any lengths to avoid the...
CP003: Business Intelligence for Masses – Interview with Mike Alexander
In the third session of Chandoo.org podcast, we are going to get BI curious. ;) - Not that kind you silly, We are talking about Business Intelligence, Big Data, Power Pivot & other Power BI family members. In this session,