CP012: Top 10 Excel Keyboard Shortcuts for you
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
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). This short format sessions will run once a month (along with longer sessions that we publish almost every week) so that you have something light & easy to chew between heavy doses of Excel awesomeness.
I hope you like this new format. Do let me know what you think in comments.
And I really appreciate your reviews & comments on iTunes. Please click here and post your review.
Top 10 things we struggle to do in Excel & awesome remedies for them
Recently we asked you, what do you struggle doing in Excel? 170 people responded to this survey and shared their struggles. In this post, lets examine the top 10 struggles according to you and awesome remedies for them.
Excel for iPad – Demo & Introduction [video]
Recently Microsoft has launched Excel app for iPad. Being an Excel addict, I could hardly wait to test it. And this is what we get.
Excel App for iPad – What is it?
Several years after iPad launch, Microsoft finally created apps for Word, Power Point, One Note & Excel. The Excel app is a miniature version of Excel on your iPad. It is capable of displaying almost all Excel workbooks with ease. You can even create your own workbooks using the app.
CP004: Can I Pie Chart in Public? Discussion about Pie charts, their merits and drawbacks, when to use & when to avoid them
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
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 them. And that is why we are going to talk about them in this session.
You will learn,
- Special, secret transmission from guest stars
- What is a pie chart?
- Why they work? 2 reasons
- Why they don’t work ? 4 reasons
- Cousins & siblings of Pie charts
- Donut charts
- Gauge charts (speedometer)
- 3D pies
- Area charts
- Bubble charts
- 4 Situations when making a pie chart is ok
- Alternatives to Pie charts
- Mistakes you should avoid
- About the resources
- Conclusions
Right-click from the keyboard, not the mouse.
Well here’s something I never knew until today…I was watching one of Mike ExcelIsFun Girvin’s great YouTube videos from his great Slaying Excel Dragons series – the one on Excel 2010 Keyboard Shortcuts – when he showed how to do the equivalent of a mouse right click using a key on the keyboard that I’d […]
Find last day of any month with this simple trick [formulas]
Here is a handy trick to calculate last day of any month.
Assuming y and m contain the year & month for which you want to find the last day’s date, write
=DATE(y, m+1,0)
That is right, you can use ZERO (0) as the day.
When you do this, Excel tells us the last day of previous month.
42 tips for Excel time travelers
Today, let’s travel in time. Pack your photon ray guns, extra underwear, buckle your seat belts and open Excel!
Of course, we are not going to travel in time. (Come to think of it, we are going to travel in time. By the time you finish reading this, you would have traveled a few minutes)
We are going to learn how to travel in time when using Excel. In simple terms, you are going to learn how to move forward or backward in time using Excel formulas.
So are you ready to hit the warp speed? Let’s beam up our Excel time machine.