Getting Started with Chandoo.org
Thank you so much for taking time to visit us.
If this is your first few times here, please read this page to get most out of my little website.
What is Chandoo.org?
At Chandoo.org, my goal is simple. I want you to become awesome in Excel & Power BI. The emphasis is on YOU part, because that is what this is all about. You & making you awesome.
How does Chandoo.org make you awesome?
Simple. I do this using 5 methods.
1. Share awesome tips, tutorials, examples & downloads
Once or twice every week, I write about various creative & productive ways in which you can use Excel (and or Power Query, Power Pivot and Power BI) to become awesome at what you do.
You can get these articles right in to your inbox by joining our free e-mail newsletter. Or you can subscribe to our RSS feed & read the articles in your favorite news reader.
When you join our newsletter, you also get a free e-book with 95 Excel tips.
Don't want any email business?
Cool, just learn from these links.
Pages for advanced users
Advanced Excel Topics
Array Formulas
Advanced Charting
Power Query
Excel Dashboards
VBA & Macros
Pages for intermediate users
Top 10 Formulas
Keyboard Shortcuts
Conditional formatting
Combination charts
Multi-table pivots
Pages for power hungry...
What is Power BI & more?
Power Query
Introduction to Power BI
Power BI Examples
2. Make Excel, Power BI, VBA & Data Videos
Twice a week, I create and post videos on topics related to data analysis, reporting, automation or productivity. I usually publish these videos on Chandoo.org YouTube Channel. Please subscribe to it if you want to learn by video.
My latest goal is to make 50 new videos in 2021.
3. Run online classes to make you awesome
I run a few online courses. These highly popular courses have helped 10,000+ professionals all over the world learn & use Excel / Power BI at pro level. If you are looking for an Excel course, please consider mine. They are well designed & highly rated.
- For Excel – Excel School program
- Dashboards – Excel School Dashboards
- VBA & Macros – VBA Classes
- Analytics – 50 ways to analyze data
- Power BI – Power BI Play Date
4. Write books & create templates
As part of my mission, I write books and provide ready to use software templates. I have published three books and two sets of templates so far. You can check them out below.
Books:
Templates:
5. Speak at user groups & conferences
I regularly speak at Wellington Power BI / Excel user group. I also speak once a year at an Excel / Data / Power BI conferece somewhere in the world.
My recent appearance is at Amsterdam Excel Summit in 2019.
Who runs Chandoo.org?
This is run by Chandoo & a small army of freelancers and volunteers. Although started as a personal website back in 2004, after 3 years, I changed the direction of site from personal rants to data. Today, after 17 years, Chandoo.org is a thriving community of passionate learners and sharers.
About Chandoo
My name is Purna Duggirala. Chandoo is my nickname. I have used the same for registering this website in 2004.
After working for a few years as a business analyst with India’s leading IT company, I quit in April 2010 to make this website my full time work. You can read the back story here.
I am happily married to Jo, my college sweetheart and love of life. In September 2009, we became parents to twins – a boy and a girl. Nishanth (boy) & Nakshatra are as naughty, hilarious & lovable as they come. And our life is even more beautiful ever since.
We live in Wellington, New Zealand, a coastal town in the Southern Hemisphere. [more…]
Connecting with Chandoo.org
While I am not as social as Selena Gomez, I do have a sizable presence on latest web fads. Click on below links to connect with us on your favorite social media platform.
- Chandoo.org on Twitter
- Our Facebook Fanpage
- Chandoo.org on Pinterest
- Chandoo.org on Linkedin
- Our YouTube Channel, has over 180 videos
- Our RSS Feed – add this to your Google home page or Flipboard etc.
Once again, welcome
Thank you so much for visiting my website. I wish you become awesome in not just Excel, but everything else you do.
28 Responses
I am new to this and really bad at excel.but I got to know about this site and wish to be an expert in excel .
Very nice site to study
pls send me the admission process and fees details
Hi chandoo,
I am new to this blog. Refered by one my close friend. He is from Melbourne.
I have read your welcome blogs. It’s interesting and eager to learn more about Excel advance tools.
I hope it will definitely help me lot.
Thank you so much.
Hallo Chandoo Team!
I’m Naseer, writting you from Vienna, Austria!!!
I’ve a bit problem with Excel counting days. I’m designing a simple monthly Roster! but can’t! i don’t think, if it’s a big deal, but the problem is, i have not enough Knowledge of Excel.
Would you mind help me, perhaps??
Hope to hear something from you soon.
Sincerly
Naseer
I took Chandoo’s course two years ago for some summer learning. I love it. I’m a social studies teacher in middle school and I wanted to learn ways I could make the student data more visual and interactive. If your company of school is still using Microsoft like it is 1999, then you will love this site and course. Unfortunately, my district switch to Google with little to no warning and now the teachers are retooling. As painful as that is, many of the formulas and general approaches are similar. VBA, however, no longer applies, which is a drag. Enjoy this site, because you’ll learn a ton.
Hi Chandoo,
I have used your site numerous times to answer questions. But how do I post a question? I have one that may not be possible without VBA or macros, and it’s interesting because Word has a field for it.
It is how to place a date that indicates the last date changed or edited. I know the 2 easy ones NOW & TODAY but I’ve scoured everywhere for a non-VBA solution with none to be found as of yet.
If you can please provide a section and category that would be suitable for this question I would appreciate it.
Thanks keep writing this type of articles
Hello sir, I really like your article I am your biggest fan.
Iam a begginer and I don’t have knowledge about excel ,very useful for me your articles
Very Nice information sir g
thx you for new Information and support for begginner.
I can’t see full page from my mobile. It’s not mobile responsive. Please check.
Great service
Will VBA dies soon? Please have this answered because there is no proper answer found anywhere online or book or personal/commercial blogs.
New to the site here from Kenya, referred by a friend. Definitely looking forward to a great experience and learnings.
Indeed formula , i have to prepare report for retail..how to fine size wise set and sale
Ex i have m l XL xxl 3xl = indeed need fine one l xl 2xl is one set , i need track set wise sale
New to the site, love excel,looking forward to learn more.