Chandoo.org - Learn Excel, Power BI, Charting, Dashboards and VBA online

Latest Tips & Tutorials

CP027: 15 proven strategies to be awesome in 2015

Subscribe: Apple Podcasts | Spotify | RSS

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

Read This »

January 8, 2015

Write faster formulas with Auto-correct

Want to write formulas faster? Here is a quick tip.

Use Auto-correct!

That is right. Excel’s auto-correct feature can be setup to help you write formulas faster. See above demo. Read on for details.

Read This »

January 6, 2015

Free 2015 Calendar, daily planner templates [download]

Here is a New year gift to all our readers – free 2015 Excel Calendar & daily planner Template.

This calender has,

One page full calendar with notes, in 4 different color schemes
Daily event planner & tracker
1 Mini calendar
Monthly calendar (prints to 12 pages)
Works for any year, just change year in Full tab.

Read This »

January 2, 2015

Best of Chandoo.org – 2014

2014 has been the busiest year since starting Chandoo.org. Wow, that is 11 years of breaking previous records. Thank you. In 2014, we published 128 posts (up 27%

Read This »

December 31, 2014

People & websites that helped me in 2014 [thank you message]

2014 has been the most awesome year since starting Chandoo.org

Thank you so much for making it happen. This year, more than 10 million people visited our site, learned something and took first step to become awesome in their work. Each & every day of 2014 felt invigorating, exciting & blessed. I could meet 100s of you face to face during my travels to Houston & Dallas in September this year.

A big thanks to you, my reader, for supporting me and choosing chandoo.org as partner in your journey to awesomeness.

Apart from our readers, there are also countless people, websites, books, companies which helped me have a fantastic year. This message is my way of saying thanks to them.

Read This »

December 29, 2014

Merry Christmas & Happy New Year 2015 [Holiday Gift Inside]

Podcast: Play in new window | Download

Subscribe: Apple Podcasts | Spotify | RSS

A big, warm & pleasant hello to you.

I wish you a merry Christmas & Happy New Year 2015. May your holidays be filled with joy, togetherness, celebrations and fulfillment. May your new year be filled with hope, energy and awesomeness.

I want to tell you how thankful I am for all your support in this year. Every time you visit our website, read an article, leave a comment, enroll in a course, purchase a product, read one of my books, listen to a podcast episode, watch a video or tell your friends about Chandoo.org, I feel nothing but gratitude, thankfulness and amazement. 2014 is the most successful year since starting Chandoo.org, all thanks to you. Heartfelt thanks to you, from my family, staff and volunteers.

About this year’s holiday card

We took this picture recently when we went to Udaipur (a city in northern India). For a change, no one closed their eyes when the camera clicked.

A holiday gift for you…

Read on to download your special holiday gift.

Read This »

December 23, 2014

Compare 2 sets of data by letter or word & highlight mismatches [vba]

We analysts like to compare. If you ever want to keep an analyst busy, just give her 2-3 options. She won’t return to your desk until the cows come home. My wife uses this trick all the time. Picture this:

[In late 2013]
Me: I want to buy a new phone
She: Do you want Nexus 5 or Galaxy S5 or iPhone 5s?

Its late 2014 and I am not done comparing.

So today, let’s talk about an interesting comparison scenario.

Comparing by letter or word

See above demo to understand the concept. Read more to learn how to do this.

Read This »

December 15, 2014

Excel to the Next Level by Mastering Multiple Occurrences

This is a guest post by Sohail Anwar.

August 29, 1994. A day that changed my life forever. Football World Cup? Russia and China de-targeting nuclear weapons against each other? Anniversary of the Woodstock festival?

No, much bigger: Two Undertakers show up at WWE Summerslam for an epic battle. Needless to say: MIND() = BLOWN().

And thus begun one boy’s journey into understanding the phenomenon of Multiple Occurrences.

My journey continued, when just a few years later my grandfather handed me down a precious family heirloom: A few columns of meaningless data that I could take away and analyze in Excel. You may laugh but in the 90’s, every boy only wanted two things 1) Lists of pointless data and …

Read This »

December 9, 2014