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/
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 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
Click here to download the MP3 file.
Links & Resources mentioned in this podcast
Books recommended / mentioned in this podcast
- Advanced Excel Essentials by Jordan Goldmeier
- Data Smart by John Foreman
- Professional XL Development by Rob, Dennis & Stephen
- Predictive Analytics by Conrad Carlberg
- Data Science for Business by Foster & Tom
User form examples:
- Creating a spreadsheet wizard to collect data
Resources on learning VBA & Advanced Excel
- Introduction to VBA
- Advanced Excel skills & resources
About Jordan & his work:
- Option Explicit VBA – Jordan’s blog
- Excel TV – where Jordan along with Rick & Oz share tips & interviews
Download this podcast transcript [PDF]
Have you read Advanced Excel Essentials book?I will be honest, I only thumbed thru a few chapters. But I plan to read the book on my flight back to India (I am typing this from my hotel room in Santa Clara).
What about you? Have you read Jordan’s book? If so how do you like it? Please share your feedback & book recommendations in the comments area.
Note: All the links to books mentioned in this page use my Amazon affiliate code. This means, when you buy the book from Amazon thru these links, I get a few cents commission. My motivation for recommending these books is very simple. They make you awesome, so I recommend them. I would have recommended them even when there is no commission involved. Thanks for supporting Chandoo.org & happy reading.
The post CP034: Advanced Excel Essentials book talk with Jordan Goldmeier appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.