The New Poor – Internet Penetration Rates by Country

Share

Facebook
Twitter
LinkedIn

Yesterday is Blog Action day and tons of bloggers posted about single topic – poverty. It is a topic very close to my heart for various reasons. It is a very sad thing not to have food or shelter or healthy living conditions. But man has thrived in all those situations just because he learned how to become better. In my opinion lack of knowledge is much more serious than lack of food. That is one reason why even the poorest parents in the world would love to see their kids going to school, so that they can learn and become better. I want to sensitize my readers about this issue: the new poor – people without information.. Internet penetration can be considered as one parameter to measure information hunger in the world. So I spent sometime yesterday gathering the data about this and created a heat map.

Mapping Internet Penetration Rates in World Countries

I took the data about internet penetration from Internet World Stats and used this in the World heat map excel that my friend Robert (of Excel Dashboards fame) once shared with me to create a map like this:

internet-penetration-by-country-heat map

Download the excel file with the map of world internet penetration rates

Darker countries have less internet penetration. Sadly this map correlates highly with a world poverty map. I guess attacking the information access issues can eventually solve the poverty.

Also checkout Nathan’s visualization on poverty rates in US

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

Overall I learned a lot and I thought you did a great job of explaining how to do things. This will definitely elevate my reporting in the future.
Rebekah S
Reporting Analyst
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.

6 Responses to “Using Lookup Formulas with Excel Tables [Video]”

  1. Damian says:

    H1 !
    this is my very first comment.
    Can you use same technique with Excel 2003 lists ?
    thanks 😀

  2. Tom says:

    Thanks, Chandoo! I like seeing the sneak peak of what's to come on Friday too 🙂

  3. Chandoo says:

    @Damian.. Welcome to chandoo.org. Thanks for the comments.

    Yes, you can use the same with Excel 2003 lists too.

    @Tom.. You have seen future and its awesome.. isnt it?

  4. Q.fg says:

    Hi, is there a vlookup formula for the second example (IDlist)? I used a similar formula to look up the ID for the person, but the reverse way (look up the person with the ID) comes up N/A.

Leave a Reply