CP034: Advanced Excel Essentials book talk with Jordan Goldmeier
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
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
CP017: Top 10 non-Excel MS Office tips for you – Interview with Paul Woods – Office MVP & Blogger
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
In the 17th session of Chandoo.org podcast, lets leave Excel aside and talk about other MS Office apps.
Thats right. We will be learning 10 tips on how to use Word, Power Point, Outlook etc. Ready?
In this podcast, you will learn,
- About Paul
- Ten tips for MS Office
- 1. Use Excel to communicate instead of just calculations
- 2. Paste Special
- 3. Double click trick!
- 4. Inserting screenshots
- 5. Turning off notifications
- & more…
CP003: Business Intelligence for Masses – Interview with Mike Alexander
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
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, I am happy to feature Mike Alexander – Microsoft MVP, Author, Blogger & a good friend. Mike talks about how Excel is shaping the BI (Business Intelligence) revolution with advent of Power BI functionality.
You will learn,
- Introduction, what Mike is up to these days?
- What is BI, what does it mean to an average Excel analyst?
- What BI capabilities Excel has – brief intro to each of them
- Power Pivot & what it does
- Power Query & why it is important
- Power View & how it works (and where it sucks)
- Power Maps
- How to learn about these new technologies
- Recommended Books
- Websites
- Courses
- Live classes
- Special gift for our listeners
What are best Excel interview questions? [survey]
Hello folks…
Time for a fun & useful survey. This time lets talk about Excel Interview Questions.
Many of you are silently becoming awesome in Excel, data analysis, charting, dashboard reporting, VBA, Power Pivot and business skills, thanks to all the time you spend on Chandoo.org. I am sure there will be a day in near future, when you have to face another interview and be selected for a challenging, fun & high paying role.
Likewise, there is also a significant portion of you who are too good in your job that you will become a senior manager, VP or CXO, or better still start your own business. When the tables have turned, you will be the one looking for smart, dedicated, talented and fun individuals to join your team and make you look even more awesome.
So my question for both prospective interviewees and wannabe Excel pros,
According to you, what are the best Excel interview questions?
I am meeting Mr. Excel aka Bill Jelen tomorrow. What do you want to ask him? (book giveaway too)
One of the beautiful things about working on internet is you know so much about people even before you meet them first time. I think I first heard about Mr. Excel in 2006, when I started my career as business analyst. I landed on mrexcel.com while searching for something related to doing cluster analysis using Excel. In a way, mrexcel.com inspired me to share my thoughts and techniques on Chandoo.org.
So it wont be an understatement when I say, I feel like a kid in candy store knowing that Bill Jelen aka Mr. Excel is just a few miles away from where I live. Since Rob Collie and Bill are good friends, I asked Rob if we 3 can meet for dinner. And Bill said yes.
I am meeting Bill for dinner on Friday and Rob, Bill & I will be discussing spreadsheets, technology, share our experiences and bump ideas off each other.
How do Business Analysts use Excel [Guest Post from a Rock-star BA]
This is a guest article by Matt, who works as a Business Analyst with allrecipes.com. He shares with us how he is using Excel to become a rockstar business analyst. In his own words,
“At Allrecipes.com we use excel for a variety of purposes. Analyzing site trends, forecasting traffic, charts, dashboards, and slide shows; you name it, we use excel for it. That’s why Chandoo’s tips have been so helpful – because we use excel every day. Thanks to chandoo.org, I’ve developed a reputation as an “excel wizard” and even taught a 4 week excel training class!“
My First Podcast!!! – Listen to know some cool charting and dashboard stuff
Just weeks before Christmas, Ross McLean, who runs Methods in Excel (a very cool and useful Excel blog) asked me if I can join him for a small podcast interview on things we both love – excel, charts and talking. I couldn’t be more happier to accept his offer. We did the podcast and life kept busy both of us for a while. That is until yesterday, when Ross made the podcast available online for all of us.