Christmas Gifts for Excel Nerds

Well, it’s December. 2013 is almost at an end.

I’ll be off line for the rest of the year, working on finishing up a book and other projects.

But before I go, I’d like to offer my 12 fans a couple of Christmas gifts.


I’ve created two posters that are fun for the entire family.

These are PDFs that are set to print 18×24 posters.

Simply click on any one of the pictures below to download the PDF. Take the PDF file to your favorite printer (I used Kinkos), and you’ll have an attractive geek-worthy poster to hang on your wall. You can even give these away to your favorite Excel Nerd as Christmas gifts.


These PDFs will be free for a limited time (only until January 1), so get them while you can.


Periodic Table of Excel Keyboard Shortcuts

This poster lays out the most commonly used Excel Keyboard Shortcuts in a clever Periodic Table.

This poster is ideal for a loved one who has short-term memory loss.



A Visual Guide to Choosing Chart Types

Can’t seem to grasp which chart type to use? This poster is for you.

Hang this sexy poster on the wall, and you’ll look like a dashboard guru.



New Training in April 2014
Also, here’s a reminder that Bill Jelen (Mr. Excel) and I will be putting on a new Business Intelligence Boot Camp next April in Bentonville, Arkansas. We’ll have space for 75 registrants.


This boot camp will cover all things BI from the perspective of the business analyst. We’ll have details on the agenda and pricing in a couple of weeks.


In the past, Business Intelligence had a tangible line separating the departmental reporting performed by business analysts and the enterprise reporting managed by IT professionals.Β  That paradigm has shifted and latest versions of Excel have changed the Business Intelligence world. Tools like Power Pivot, Power View and Power Map blur the lines between what is a departmental Excel tool and what is an enterprise-level BI tool. It’s becoming increasingly important for business analysts to expand their skill-set from the one dimensional spreadsheet to new territory like relational databases, data integration, and multidimensional BI reporting.

This 3-day event is aimed squarely at business analysts and managers who find it increasingly necessary to become more efficient at working with “big data” tools traditionally reserved for IT professionals. Excel MVPs Bill Jelen (Mr. Excel) andΒ Mike Alexander (DataPig Technologies)Β guide you through the mysterious world of Microsoft’s new BI Tools from a business analyst’s point of view.Β  You will be introduced to the rich set of tools and reporting capabilities that can be leveraged to more effectively synthesize data into Business Intelligence Dashboards.

Click here to get more details


Well I’m signing off now.

I hope your December is a blast, and that you all have a wonderful holiday season.

I’ll be back next year to continue my legendary path to blogging glory.

22 thoughts on “Christmas Gifts for Excel Nerds

  1. Khushnood Viccaji (KV)

    Hi Mike,
    You might read this comment next year, but anyway, here goes πŸ™‚

    In version 2 of the periodic table of keyboard shortcuts, you might want to include these two shortcuts.

    – Shift F4 — Find next occurrence (of last searched value)
    – Ctrl Shift F4 — Find previous occurrence (of last searched value)

    Enjoy your holiday… Cheers!

  2. MT

    Cool! Thank you – I will be printing this and will be the envy of my office mates πŸ™‚ Merry Christmas and happy new year!

  3. Mark

    Thanks, Mike. I didn’t know about using Ctrl-F6 to move between open workbooks–I’ve always used Ctrl-TAB and Shift-Ctrl-TAB because it is much easier to do with one hand! Happy Holidays.

  4. dave

    Great Visuals, thanks Mike! Any chance you can update the DashBoard Tools Add In with these other DashBoard Mock Up Components shown on the Chart Types .pdf ?
    Also I know you used Wickenden Cafe for some of your fonts but what do you use for the title of the Visual Guide for Chart Types, I really liek the pastel chalk look but can;t find it anywhere?

  5. datapig


    I used these fonts:

    DK Crayon Crumble

    You can look download them free…just search Google.

    Be careful though. Fonts are tricky.

    When you install a custom font, each font will only work with the computer you’ve installed it on. Custom fonts that you’ve installed on your computer may not display the same way on a different computer. Text that is formatted in a font that is not installed on a computer will display in Times New Roman or the default font.

    Therefore, if you plan to share Microsoft Office Word, PowerPoint, or Excel files with other people, you’ll want to know which fonts are native to the version of Office that the recipient is using. If it isn’t native, you may have to embed or distribute the font along with the Word file, PowerPoint presentation, or Excel spreadsheet.

  6. rob

    Dude, I just found your blog, and I am loving you, my long lost Excel brother. Keep churning out the gems! This one is great. I am re-gifting the periodic table to some nerds for Valentine’s.

  7. Paul

    Hey, still awesome one Christmas on πŸ™‚
    One more that saves me a lot of mouse clicking:
    Alt + PgUp/PgDn to navigate horizontally!

  8. Carlos Barboza

    Maestro Mike!

    I think you need add Khushnood Viccaji’s .. i just tried them and they are fantastic!

    – Shift F4 β€” Find next occurrence (of last searched value)
    – Ctrl Shift F4 β€” Find previous occurrence (of last searched value)

    Also, what would be the Christmas presents for 2015’s?

    Cheers from Lima, Peru!

  9. Jie Zhang

    I think they are great, and I am a student who are interested in data visualisation and want translate them into Chinese, and then introduce them to more people. So could you authorise me to do that work?
    Thanks very much.

Leave a Reply

Your email address will not be published. Required fields are marked *