2011 has been the most awesome year since we started Chandoo.org.
Without doubt, the credit goes to our community – that is you.
I feel very fortunate to have you in our community. You inspire me to learn & share. I know I said this several times, but everytime, I feel like I have not done enough. Thank you so very much.
Apart from our little community, I feel thankful to many others, who have helped me through out 2011 to make you awesome in Excel. In this post, I am highlighting them & expressing my gratitude.
People who helped me in 2011:
Teachers & Gurus:
Running a business, website & family requires a lot of motivation, fresh ideas & learning. Thanks to several wonderful teachers & inspiring individuals who gave me the strength I need this year.
Excel & Visualization Teachers:
Jon Peltier, Dick Kusleika, Debra Dalgleish, Mike Alexandar, Daniel Ferry, Stephen Few, Jorge Camoes, Robert Mundigl, Hui, Jimmy, Paresh, Gregory, Francis, Vijay and many more.
Business & Motivation
Pamela Slim, Andy Sernovitz, Seth Godin, Darren Rowse, Yaro Starak, JD Roth, Avinash, Brandon Pearce, Alok, Pat and many more.
Technology
Authors
This year, I had the fortune of reading several inspiring, life changing books. Thank you so much to these wonderful authors.
- Napolean Hill Think & Grow Rich
- Jim Collins Good to Great
- Tim Ferris 4 Hour Workweek
- Thomas Stanley & William Danko Millionaire Next Door
- Michael Gerber E-myth Revisited
- John Walkenbach Excel 2010 Power Programming & Excel 2010 Bible
- Barbara Demick Nothing to Envy
And many other…
Note: All the book links to Amazon are affiliate links. That means, if you purchase something after clicking on them, I get a few cents 🙂
Affiliates & Partners
To make Chandoo.org successful, I collaborate with many great minds in this industry. These are remarkable people who enjoy my success as much they enjoy theirs’. Some of these remarkable people are,
Dashboard Spy, Fabrice Rimlinger, Kevin Lehrbass, Hui, Paramdeep Singh, Danielle Stein Fairhurst, Jimmy Pena, Francis Hayes, Philip Pracht, Ken Puls, and many more.
Special thanks to Guru & IIPD team in Maldives, SHRI Academy in Singapore for helping me in my international workshops. Also, Thanks to Prof. Henrik from Aalborg University (Denmark) for having his entire class sign-up for Excel School. Thanks to ActiKnow consulting for helping me with some of the consulting work.
Customers & Readers
This year, more than 4,000 of you blessed me with your product purchases from Chandoo.org. More than 34,000 of you are now part of our RSS / Newsletter community. Many more continue to join us each day. Thank you so much for inviting me in to your life & taking time to learn from me.
I am also thankful to our Excel forum members. This year, many more of you have become regulars and shared your knowledge with all of us. Fred, Narayank, Hui, Vijay, Luke, asa, SirBJ, oldchippy, prasaddn, Indian & many others continue to be active and selfless. Thank you.
Our Staff
I could not have many of the things I did this year with out help of my lovely staff. Thanks to,
- Ravindra: for helping with various training enrollments, emails & customer service
- Vijay: for teaching VBA
- Sameer: for answering student doubts in training programs
- Chittibadrayya: for taking care of all the book-keeping & accounting aspect of our business
Websites & Companies that helped me in 2011
I am thankful to Microsoft for making Excel so awesome.
I am also thankful to,
Email & Productivity: Google, iPhone
Website, Hosting & E-commerce: WordPress, GoDaddy, Wishlist Member, Amazon, PayPal, E-Junkie, 2Checkout, EBS
Community & Connection: Twitter, Facebook, Skydrive
Software: Paint.NET, Mozy, Notepad ++, Camtasia, Skype
There are many other software, companies and websites that help me every day. I am really thankful to each and every one of these.
Last but not least…,
Many thanks to my lovely family. With out you, none of this matters. Your love, laughter, kindness & support is invaluable.
PS: Here is one last Excel tip for this year. Open Excel, go to A1 and type,
=UPPER( MID(ADDRESS(1,2^4*3*11),2,2) & BIN2HEX(1010) & CHAR(DEGREES(ASIN(1))+20) & MID(ADDRESS(1,BIN2DEC(100110111)),2,2) & CHAR(REPT("1",3)) & CHAR(6^2+9^2) )
and press enter to see what I mean 🙂
11 Responses
Ciao Hui,
Collecting Excel tricks under the title “Notable Excel Websites (Non-MVP) Edition” is a brilliant idea…
Thank you in the name of all The FrankensTeam.
On our site there is a box with a picture and text highlighting:
This is a no-MVP site
we think ourselves “bad boys” a bit 🙂
For those who would like to know why our site is a no-MVP site, enough to click on the link:
http://goo.gl/lxDszY
Thank you again!
Thanks a lot
I really enjoyed this (newsletter). I must admit that I rarely read an Excel newsletter (and I subscribe to quite a few) all the way though, but this grabbed my attention and before I realized it, I was engrossed in it. I must also admit that most of this I don’t understand, yet. But, it excites me when I do learn something new in Excel. I can’t wait to see how much of this I can implement into my (constantly-evolving) ‘House Budget’ & ‘Family Medical’ worksheets that I have developed over the past few years! I sure hope to see more of these type of newsletters in the future! Thanks!
Thanks for doing this Hui! I appreciate being included.
I like Tom’s tip a lot. I posted about a tool I wrote to automate this at http://yoursumbuddy.com/tables-edit-query-dialog/
EXCELLENT !
Hui, This post is Superb! More over I have always been a fan of Roberto’s work and have learnt a lot from him.
Here are some of my recent contributions
1. Customising markers in a chart – http://www.goodly.co.in/customize-markers-in-a-chart/
2. Charting Hacks to work faster – http://www.goodly.co.in/5-charting-hacks-to-help-you-work-faster/
3. 7 Date formulas to make life easy – http://www.goodly.co.in/date-formulas-in-excel/
4. Customised scrollbar using VBA – http://www.goodly.co.in/customized-scroll-bar-in-excel/
5. Adding Direct Legends – http://www.goodly.co.in/customized-scroll-bar-in-excel/
Hope everyone enjoys!
I like the Excel Ninja Menus.
1. Select a cell or range then move till the 4-way cross appears. Right-Click and drag the selection to another place in the worksheet then, like a ninja, a menu full of skills and throwing stars pops up allowing me to do all kinds of awesomeness.
2. When you click the fill box on a Date and right click and drag it down, a lot of amazing Date options pop up.
I also brand my Excel to remind myself that I’m awesome. In my personal macro workbook I place the following code.
Private Sub Workbook_Open()
Application.Caption = “SuperKrishna’s Awesomeness”
End Sub
My favorite tip goes along with #17. If you try to copy subtotaled data (and in earlier Excel versions filtered data),when you paste it all the data displays instead of just the summarized data.
To get around this, select your summarized data, click on Find and Select tab and then select Go to Special. Click Visible cells Only and click OK. Now paste and you will see that only the summarized data has been copied.
You can also go CTRL+G and then click the Special icon at the bottom of the dialog box.
What a great idea, Chandoo! I’d love to be included in your next edition:) Perhaps a VBA exclusive version?
@Ryan
I will review this concept about 6 months out from the original post and be sure to keep your site in mind
Hui…
That sounds great, Hui:) I just realized I gave credit to Chandoo for the idea and I should have attributed it to you.
Sorry about that!