Chandoo.org Podcast – Become Awesome in Data Analysis, Charting, Dashboards & VBA using Excel
Summary: 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.
- Visit Website
- RSS
- Artist: Chandoo - Microsoft Excel MVP, Training & Data Analysis Specialist
- Copyright: Chandoo.org
Podcasts:
In the second session of Chandoo.org Podcast, We will be learning how to use 5 Excel lookup functions. What is in this session? In this session, we tackle one of the most important areas of Excel. The lookup functions. You will learn, Why lookup functions are necessary 5 Important lookup functions in Excel - VLOOKUP, HLOOKUP, LOOKUP, MATCH & INDEX When & how to use each of these 5 functions? Extreme scenarios: What happens when the value you are looking up is not there? What if too many items match the lookup value? What if you have too many conditions in the lookup criteria? Using IFERROR function Re-cap of the new powers you acquired 4 Resources for you to learn lookup functions better
Chandoo.org Podcast is here.... Friends, fans & supporters of Chandoo.org, I am so happy to add another dimension to our website. Chandoo.org podcast is finally here. You can listen to the inaugural episode by using the audio player above.
