fbpx
Search
Close this search box.

5 Things you probably dont know about this site

Share

Facebook
Twitter
LinkedIn

Hi there,

Pointy Haired Dilbert - Chandoo.orgWelcome to Pointy Haired Dilbert. Over the last few weeks, we have seen huge influx of new members in our little community. So I am writing this to welcome you.

This is a site for people who want to tell stories using charts and data. Although we focus more on learning Microsoft Excel, we have hundreds of useful resources on data visualization, dashboards, charting best practices and data analytics.

My name is Chandoo, I am from India, but I travel around the globe frequently and have worked in 7 countries in last 3 years. I have started writing PHD in 2004, mostly to tell my friends and family about my b-school life. The blog became an excel and charting community in 2007 and has been growing strongly ever since. In year 2009, I have received the MVP award from Microsoft. Just few days back I have become a dad too…

If you are a subscriber to this blog, you should be getting fresh excel and charting tips through e-mail / RSS. But, there is more to Pointy Haired Dilbert than just a regular update.

Here is a list of 5 things about PHD that you probably don’t know,

Comprehesive resources to help you make an excel dashboard

That is right. We have a good selection of articles, tutorials and free downloadable templates to help you with your excel dashboards. There is a 6 part tutorial on making KPI dashboards using excel guest authored by Robert from Clearly and Simply.

Click here to see the excel dashboard section of the site.

Learn 51 Everyday Excel formulas in plain English

You can learn almost all the eveeryday excel formulas using the learn excel formulas section of the site. You can even buy the e-book version of it, which has 75 formulas in a much more learner friendly format.

Click here to see the excel formulas page.

Free Excel Downloads & Templates

We have a huge collection of free, downloadable excel templates, chart templates, excel utilities, excel games and much more in the free excel downloads section of the site.

Click here to see the downloads section.

Free Excel E-books

We have 2 free excel e-books on the site.

(1) 95 Excel & Charting Tips to make your 9 to 5 better

(2) Excel Ribbon Learning Guide

These books present great content in a fun & easy to learn way.

Ask an Excel question in our Discussion Forums

Recently we have added a discussion forum to PHD. In the discussion forum you can ask any excel or charting related question and get help from other members.

Click here to access our discussion forums.

Welcome once again. I hope you are learning and enjoying this place as much as we like to learn and share. Have a fun week ahead.

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Excel School made me great at work.
5/5

– Brenda

Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

Weighted Average in Excel with Percentage Weights

Weighted Average in Excel [Formulas]

Learn how to calculate weighted averages in excel using formulas. In this article we will learn what a weighted average is and how to Excel’s SUMPRODUCT formula to calculate weighted average / weighted mean.

What is weighted average?

Wikipedia defines weighted average as, “The weighted mean is similar to an arithmetic mean …, where instead of each of the data points contributing equally to the final average, some data points contribute more than others.”

Calculating weighted averages in excel is not straight forward as there is no built-in formula. But we can use SUMPRODUCT formula to easily calculate them. Read on to find out how.

6 Responses to “5 Things you probably dont know about this site”

  1. Murtaza says:

    I couldn't find you on Microsoft MVP Awardees List.

  2. Jeff Weir says:

    MVP of course stands for Most Virile Parent!

    Personally I don't care whether people are MVPs or not (the Microsoft kind). What gives people kudos to me is what they do, not what recognition they get from Microsoft. Chandoo does a lot of excellent Excel stuff to help people for free...he's a VIP in my mind.

  3. Hey! I can say your blog it was very good blog for people who wanna bee in advance at the excel format. I can say it was great thing for people to check it out. Please try to update it again and again ok? then we can find some tip it's might help us to be successful in excel program. Thanks again for a good articles. Best!

  4. Muhammad Farooq e Azam says:

    Dear Chandoo,
    Its awesome, what u have done.
    I am looking to use Excel for Forecasting/Demand Planing for a Retail Store with number of products and and product range.
    Kindly help me out finding some excel templates for Forecasting/Demand Planning.
    Thanking you in advance.

    Regards,
    Muhammad Farooq e Azam

Leave a Reply