All articles with 'no ads' Tag

Merry Christmas and Happy New Year 2018 [Holiday Card]

Published on Dec 22, 2017 in personal
Merry Christmas and Happy New Year 2018 [Holiday Card]

Hellow there…

I wish you a merry Christmas & Happy New Year 2018. 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. Each time you click, visit, read, comment, share, view, listen, purchase, subscribe, follow, question, discuss or email, my heart is filled with gratitude and happiness. Thank you for all the love and support. 2017 has been another amazing year in Chandoo.org journey and I owe this to you.

Continue »

Merry Christmas & Happy New Year 2017 [Holiday Greeting]

Published on Dec 23, 2016 in personal
Merry Christmas & Happy New Year 2017 [Holiday Greeting]

A big, warm & pleasant hello to you.

I wish you a merry Christmas & Happy New Year 2017. 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. 2016 has been a remarkable year in our journey and I owe this to you and your support.

Continue »

Analyzing 300,000 calls for help [case study]

Published on Aug 24, 2016 in Analytics, Learn Excel, Pivot Tables & Charts, Power Pivot
Analyzing 300,000 calls for help [case study]

Over the weekend, I got an email from Mr. E, one of my students. Mr. E works at a police department in California and as part of his work, he was looking at calls received by police. Whenever police get a call for help, multiple teams can respond to the call and go to the location. All of these dispatches are recorded. So a single call can have several such dispatches. And Mr. E wanted to findout which team responded the first. The problem?

Finding the first responded team is tricky.

Today let’s take up this problem as a case study and understand various methods to solve it.  We are going to learn about writing better lookups, pivot tables, power pivot and optimization. Put on your helmets, cause this is going to be mind blowingly awesome.

Continue »

How to get Maps in to Excel charts & dashboards [Master Class]

Published on Jul 21, 2016 in 3D Maps (Power Maps), Charts and Graphs, Master Class
How to get Maps in to Excel charts & dashboards [Master Class]

This is third episode of our Monthly Master Class.

In this one, you will learn how to get maps in to your Excel workbooks. Understand 5 key techniques for making maps based visualizations in Excel – from regular charts to cell grids to VBA to Power Maps, everything is covered in this intense Master Class.

Continue »

SUMPRODUCT – Beginner to Advanced [Master Class]

Published on May 18, 2016 in Learn Excel, Master Class
SUMPRODUCT – Beginner to Advanced [Master Class]

This is second episode of our Monthly Master Class.

In this one, you will learn all about SUMPRODUCT. Know all about basics to advanced usage of this powerful & versatile formula in this 98 minute master class.

Continue »

Advanced Interactive Charts using Excel [Master Class]

As announced earlier, here is the first one of our Master Classes. In this one, you will learn how to create advanced interactive charts in Excel by blending pivot tables, slicers, timelines, VBA, conditional formatting and charts. The final outcome is BEAUTIFUL!!! Monthly Master Class – Episode 1 – Trailer Check out a quick trailer of the […]

Continue »

Introducing Chandoo.org Monthly Master Class

Published on Apr 11, 2016 in Training Programs
Introducing Chandoo.org Monthly Master Class

Hi folks,

I have an exciting announcement for you. Starting this month, I will be running a monthly master class on advanced Excel. This is a video class to help advanced users learn creative, powerful ways to use Excel in their day to day work.

What is this Master Class?

The idea is simple. Every month, I will create a lengthy video discussing one of the below topics, specifically targeted at advanced Excel users. As our blog grew, we have a lot of experienced, advanced users and I want to help you achieve more. You will learn,

  • Dashboards
  • Data Analytics
  • Visualizations
  • VBA / Macros
  • Business Modeling
  • Business Intelligence

Each class will be on an different topic with in-depth coverage, creative outputs and awesome techniques. You can sign up for the class that suits your needs.

Continue »

Analyzing half a million complaints – Customer Satisfaction Scorecard [Part 3 of 3]

Analyzing half a million complaints – Customer Satisfaction Scorecard [Part 3 of 3]

This is the final part of our series on how to analyze half a million customer complaints. Click below links to read part 1 & 2.

  1. Complaint reason analysis – Part 1
  2. Regional trends & analysis – Part 2

Customer satisfaction scorecard

In the previous parts of this case study, we understood what kind of complaints were made and where they came from (states). For the customer satisfaction scorecard, let’s focus on individual companies.

Continue »

Analyzing half a million customer complaints – Regional Trends [Part 2 of 3]

Analyzing half a million customer complaints – Regional Trends [Part 2 of 3]

This is part two of our three part series on how to analyze half a million customer complaints. Read part 1 here.

Analyzing Regional Trends

As introduced in part 1, our complaints dataset has geographical information too. We know the state & zip code for each complaint. Please note that zip codes are partial or missing for a 10% of the data.

In this article, let’s explore three ways to analyze regional trends.

  1. Regional trends by state, product & issue
  2. Complaints per million by state
  3. Complaints by zip code
Continue »

Analyzing half a million consumer complaints [Part 1 of 3]

Published on Feb 16, 2016 in Analytics, Charts and Graphs
Analyzing half a million consumer complaints [Part 1 of 3]

How would you analyze data when you have lots of it? That is the inspiration for this series.

Let’s meet our data – Finance Industry Consumer Complaints

As part of open data initiatives, US government & Consumer Financial Protection Bureau maintain a list of all consumer complaints made against financial institutions (banks, credit unions etc.) You can download this data from the catalog page here. I have obtained the data on 1st of February, 2016. The download has 513,824 records. Each row contains one complaint.

In this and next two parts of the series, we are going to analyze these half a million complaints to find insights.

Continue »

Merry Christmas & Happy New Year 2016 [Holiday Greeting]

Published on Dec 24, 2015 in personal
Merry Christmas & Happy New Year 2016 [Holiday Greeting]

A big, warm & pleasant hello to you.

I wish you a merry Christmas & Happy New Year 2016. 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. 2015 is the most successful year since starting Chandoo.org, all thanks to you. Heartfelt thanks to you, from my family, staff and volunteers.

Continue »

Book Announcement: Dashboards for Excel is launching on 15th September

Published on Sep 3, 2015 in Charts and Graphs, Learn Excel

I have an exciting announcement to share with you. My first ever print book – Dashboards for Excel, co-authored with Jordan Goldmeier is releasing on 15th September.

Dashboards for Excel – what is it?

As the name suggests this book is a handy guide for anyone preparing dashboards, management reports and business intelligence workbooks using Excel. The key benefits are,

  • Learn the visualization tools, charts, tables, and graphs important to management.
  • Understand what management doesn’t want to see in a report
  • Turn around dashboards faster and cheaper than ever before
  • Understand the key role dashboards play in an organization
  • Analyze real-world dashboards to apply important features to your own organization
  • Utilize understated, but powerful, Excel formulas and VBA code
  • Avoid common pitfalls in Excel development and dashboard creation
  • Get started with the Excel data model, PowerPivot, and Power Query

As you can see, this is an advanced Excel book with lots of examples, case studies and practical tips.

Continue »

Thank you for making Awesome August a success

Published on Sep 1, 2015 in personal

Wow, what a month it has been. In August 2015, I announced Awesome August, an Excel festival. I published 31 articles, one for each day of August to make you awesome in your work. We had  3 podcasts, 11 videos, 17 articles and 238 comments in August. This content is consumed by more than 50,000 people from all over the world (3% of site traffic visited Awesome August pages). There were lots of emails, tweets and facebook posts telling me how you are enjoying Awesome August.

Thank you so much for taking time to learn from Chandoo.org and making Awesome August a success.

I made a short (5 mins) video to share the journey and to say thanks to you personally. Please watch it below.

Continue »

Filter as you type [Quick VBA tutorial]

Published on Aug 22, 2015 in VBA Macros
Filter as you type [Quick VBA tutorial]

Filtering a list is a powerful & easy way to analyze data. But filtering requires a lot of clicks & typing. Wouldn’t it be cool if Excel can filter as you type, something like above.

Let’s figure out how to do this using some really simple VBA code.

Continue »

Are you an analyst? Use these 25 shortcuts & tricks to boost your productivity

Published on Jul 7, 2015 in Keyboard Shortcuts, Learn Excel
Are you an analyst? Use these 25 shortcuts & tricks to boost your productivity

Analyst’s life is busy. We have to gather data, clean it up, analyze it, dig the stories buried in it, present them, convince our bosses about the truth, gather more evidence, run tests, simulations or scenarios, share more insights, grab a cup of coffee and start all over again with a different problem.

So today let me share with you 25 shortcuts, productivity hacks and tricks to help you be even more awesome.

Continue »