fbpx
Search
Close this search box.

Excel Links – Bacon bits are good edition

Share

Facebook
Twitter
LinkedIn

Ok, here is a brand new excel blog in the town, from Mike Alexandar, a Microsoft Excel MVP. The blog is called bacon bits. Wonder what bacon has got to do with spreadsheets, well, you will do well to know that his company is called datapig technologies. Mike has written some really cool excel books like Excel 2007 Dashboards & Reports For Dummies, Excel 2007 VBA Programmer’s Reference and Microsoft Excel and Access Integration. The blog looks promising with very cool excel and vba tricks. Add it to your reader or daily stop list and I am sure you will agree with me.

Let us talk about the excel links I have come across recently.

Using XY Charts to draw state maps

Dick Kusleika provides a neat technique for creating US State Maps using XY Charts. Using XY Charts for maps is somewhat cumbersome. I have stopped trying that route after crashing excel fewtimes. Instead, I use Tushar’s method of shapes to construct maps. You can learn more about that here

Generating TinyURLs using Excel

Jimmy provides a simple VBA macro that can generate tinyurls from any given URL. This can be handy if you are planning use run a twitter campaign from excel sheet.

The sad state of Infographics

This is a classic Stephen Few article where he disapproves 2 inforgraphic visualizations and highlights all the mistakes in them. He asks “Is this the best infographics has to offer?” I echo with his opinions. That is one reason why I have stopped posting the cool infographics of the week series.

Help Jorge finish his data visualization e-book

If you have sometime, head over to Jorge’s Junk Charts blog and help him write his e-book on 101 Data Visualization Questions You Were Afraid to Ask. You can win a free copy if your question is selected.

How to design a filter for your dashboards / reports

Juice analytics highlights five features of effective filters. This is a very good lesson if you design dashboards and complex TPS reports where filtering is necessary. I thin the aspects of Selections and Impact are very relevant when designing spreadsheet based filters.

Do you want to share a useful excel or charting related link?

Send me an e-mail or drop a comment. I like to learn and share new stuff about excel, spreadsheets and charting. More so, I like to read emails from *you*. So go 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.

letter grades from test scores in Excel

How to convert test scores to letter grades in Excel?

We can use Excel’s LOOKUP function to quickly convert exam or test scores to letter grades like A+ or F. In this article, let me explain the process and necessary formulas. I will also share a technique to calculate letter grades from test scores using percentiles.

7 Responses to “Excel Links – Bacon bits are good edition”

  1. Jorge Camoes says:

    Thanks for the link, Chandoo. Let me just say that I'll have 101 free copies and I'm taking the readers' questions until June 30. The e-book will be available after the Summer.

  2. Thanks for mentioning the blog Chandoo. I would say the check is in the mail, but everyone knows I'm a cheap bastard.

  3. JP says:

    Thanks for mentioning my post. My site is acting up (I think it's WP 2.8) but if you go to the home page for the blog, you can read the full post there.

  4. Chandoo says:

    @Jorge.. you are welcome.
    @Mike.. Ouch.. that hurts, I was actually starting at the post box every other minute...
    @JP... I am tired of WP upgrading their versions so rapidly.. I guess I will skip 2.8 and 2.9 and upgrade to 3 when it is ready...

  5. JP says:

    The link works now. Turns out it was my fault, not WP. Although the new "codebox" feature in the post editor is a bit annoying (thankfully you can turn it off).

  6. Cheryl says:

    Thanks for the heads up on bacon bits.. I've learned a bunch of stuff from the DataPig website so I'm sure that this will be educational as well.

  7. mitch13 says:

    Hi

    Have large number of spreadsheets that link to a weekly and also an annual summary. After many years these spreadsheets are getting very large and ugly.

    Is there any way to replace linked data with the actual data set as a value. If there is it means that I could archive off ancient parts of these spreadsheets and work only with say the current year.

    Looking forward to hearing

Leave a Reply