In the 27th session of Chandoo.org podcast, let’s pave way for an awesome 2015.
We are going to talk about 15 proven strategies for making you awesome in Excel & Your work.
What is in this session?
We all get fresh dose of energy, enthusiasm & drive during new years. So we aim for bigger & more awesome things. But once the first few weeks are over, we just settle down to the normal rhythm and forget about these big, hairy & audacious goals.
Let’s make 2015 different. In this podcast, Let’s understand how you can become awesome in Excel & your work this year, with 15 proven strategies:
- Announcements – my new year & plans for next few months
- Becoming awesome – 3 important areas of focus
- Learning
- New formulas
- New features
- Different charts
- Macros
- Linkup Excel with other software
- Get a book
- Join a course
- Application
- Take up a work project
- Consulting
- Mimic a chart in Excel
- Beyond XL – Power Pivot etc.
- Sharing
- Forums
- Helping a colleague
- Comment on blogs
- Train your team
Listen to this session
Podcast: Play in new window | Download
Subscribe: RSS
Click here to download the MP3 file.
Links & Resources mentioned in this podcast
Upcoming live events:
- PASS Business Analytics Conference 2015
- Advanced Excel & Power Pivot Masterclass in Australia – 2015
Learning Excel:
- Advanced & Array formulas
- Solver
- What is a Macro?
- Excel VBA – Information, tutorials & examples
- Recommended Excel books
- Online classes from Chandoo.org
Applying Excel skills:
Sharing Excel Skills:
Transcript of this session:
Download this podcast transcript [PDF].
How are you planning to be awesome in 2015?
I am going to learn something new, apply & share more in 2015. I will also be meeting people thru live events (like conferences or masterclasses) and learning from them.
What about you? How are you planning to be awesome in 2015? Share your thoughts in the comments section.
Subscribe to Chandoo.org Podcast
5 Responses to “Preparing Profit / Loss Pivot Reports [Part 2 of 6]”
[...] Preparing Pivot Table P&L using Data sheet [...]
[...] Preparing Pivot Table P&L using Data sheet [...]
[...] Preparing Pivot Table P&L using Data sheet [...]
I am not getting sound from the videos. I have checked all the settings and spent several hours searching the Internet to no avail.
Has anyone else had this problem?
Is there anyway to get the Grand Total to be broken out in the same fashion as the items above it? For instance, if you have in column 1, widget a, widget b, and have their sales by month in column 2, I'd like to see the grand total also be by month, for widget a & b combined.
I can't get anything other than a single line for the grand total, rather than the same format as the data above.
Widget A Month Sales
Jan 100
Feb 200
Widget B
Jan 150
Feb 250
Grand total - here I would also like to have Jan, Feb.
Jan 250
Feb 450