Thursday, November 24, 2016

2016 Holiday Gift Guide for Excel Users

The 2016 holiday season is officially upon us here in the United States which means it’s time for my annual gift giving guide. I used to panic every year whenever my spouse, parents, and siblings asked me what I wanted for Christmas. I needed to give them an idea otherwise I’d end up with an ugly sweater or some random gadget I would never use. So to help alleviate some of my stress I started compiling my own holiday gift guide. It’s kind of like the big toy catalog you used to get as a kid, only this is for adults. I’ve made a list of items I think would be very useful or exciting for your fellow Excel users, sorted by different categories. Some of these items I already use on a daily basis and others are things that are on my own personal wish list. Enjoy!

MY GO TO EXCEL BOOKS


For just the second time ever, I am giving a discount on my paperback book, 76 Excel Tips to Improve Your Productivity and Efficiency. For 20% off, use discount code: 2F5RYRQC when purchasing directly from CreateSpace here: https://www.createspace.com/4754053. Or you can purchase from Amazon.com here.


Excel: QuickStart Guide - From Beginner to Expert by William Fischer. This Excel book covers everything you need to know about charts, pivot tables, data modeling as well as dashboard design. It is ripe with examples and real-world applications. For those starting in any kind of role in analysis, whether it be as a data scientist, financial analyst, research analyst, or just any type of analyst or manager in general, I would definitely recommend this book.



Excel 2013 Power Programming with VBA by John Walkenbach. This book covers all the methods and tools you need to know in order to program with Excel. Provides tips, tricks, and techniques for expanding Excel's capabilities with VBA that you wont find anywhere else

OTHER BOOKS WORTH READING


The Martian by Andy Weir. If you only read one (fiction) book this year, The Martian has to be the one. I absolutely love this book (and it’s even better than the movie). As soon as I finished it the first time, I immediately re-read it – something I’ve never done before. It’s about an astronaut (with a great sense of humor) who gets left behind on a mission to Mars and has to figure out how to survive. If you’re interested in space exploration, problem solving, engineering, chemistry, botany, or disco + 70s TV shows, I highly recommend you read The Martian. Maybe the best book I’ve read in the past five years.




Catalyst: A Rogue One Story by James Luceno. If you’re a Star Wars fan like I am you’re probably anxiously awaiting Rogue One: A Star Wars Story movie on December 16th. This book will wet your appetite before the new movie comes out. The story takes place during the Clone Wars and the initial formation of the Empire. Not required reading for the movie, but will give you some additional background information on the characters.



What If?: Serious Scientific Answers to Absurd Hypothetical Questions. This book contains hilarious and informative answers to important questions you probably never thought to ask, like: What if everyone on earth aimed a laser pointer at the moon at the same time? What if you could drain all the water from the oceans? What if all the lightning in the world struck the same place? Very fun and interesting read!




Will It Fly? How to Test Your Next Business Idea So You Don’t Waste Your Time and Money by Pat Flynn. I’ve been following Pat’s blog and podcast for a number of years, and you might have seen some of his tips at work on my site. If you’re new to the online business world, this book is fantastic. Lots of practical steps to take to prove whether your idea has validity or not.


Another quick, shameless self-plug. Where are the most terrifying roller coasters found? Who designs them? Which park builds the craziest rides? Find out by reading my book The 50 Most Terrifying Roller Coasters Ever Built! Another reason for including this book on this list is to show you a real life usage of Excel. How's that? Because this is one of the books I wrote using an Excel spreadsheet!




TOOLS FOR THE JOB


Laptop Privacy Screen Protector. Whenever I visit a customer I always take my privacy screen protector for my Dell laptop. It keeps your personal or confidential information safe from prying eyes as you’ll see the information on your display while people on either side only see a darkened screen. If you’re ever on an airplane or in a coffee shop and feel like your neighbor is constantly looking over your shoulder at your screen then you need to get one of these today!



Laser Pointer. This laser pointer always comes in handy when it’s time for a meeting or presentation. Plus, it doubles as a toy to keep your cats entertained.



Keyboard Case for Tablets. How do I get so much done, especially when I’m traveling on the road a lot? I use a combination of a Samsung Galaxy Tablet and my new Keyboard case. They’re small so I can take it almost anywhere and the keyboard allows me to do things like type out this blog post, reply to your email questions, and write Excel macro code.



Excel Quick Reference Sheet - Laminated quick reference showing step-by-step instructions and shortcuts for how to use Microsoft Office Excel 2013.

Microsoft Surface 2: There are newer, more powerful Surface tablets available but they're pretty expensive, running around $1000. The Surface 2 is now pretty affordable at around $250 and is still one of the best tablets for Excel and other Microsoft Office products. In fact, it comes with fully functional versions of Excel, Word, Outlook, Powerpoint, and Onenote for free. As far as I know, no other tablet has anything comparable. 32 and 64GB versions are available.

TECH, GADGETS, AND TOYS


Google Cardboard – Google Cardboard is described as Virtual Reality (VR) on a budget. Gives you a taste of the capabilities of the Oculus Rift at a fraction of the cost. Though be warned it may cause motion sickness if the app you’re looking at doesn’t perfectly track your head movement. It’s fun to assemble and play with. And cheap too.



Dash and Dot – programmable robots. If you’re into programming things like Excel  macros and you want to teach your kids the joys of programming then I’ve found the perfect gift for you. These cute robots are designed to help introduce children to the wonderful world of programming. Oh, and they’re fun for adults too! Can’t wait to use this with my son in a few years. For now he just likes watching me drive it around with my phone.



Solar Powered Christmas Lights. I love putting up Christmas lights and trying to out-do my neighbors, but I have to admit I feel a little guilty about using the additional electricity. Luckily I found these solar powered Christmas lights and they actually work very well! They’re environmentally friendly and they automatically turn on and off each night. They also don’t have to be attached to a power source so I can put them in areas I normally couldn’t string lights.



Fitbit Alta. Let’s face it – us engineers nowadays sit in front of a computer a lot. I didn’t realize how much I wasn’t moving until I started wearing a Fitbit. It now helps me to stay motivated by tracking all-day activity like steps, distance, calories burned and active minutes so I can stay healthy for my family. When I’m sick I can’t answer your emails and help you out, so I use Alta to help stay in shape and on top of my game!




Amazon Prime Membership. If you haven’t joined Amazon Prime yet, why not? I do almost all my shopping online and I get free two-day shipping on nearly everything. You can also borrow books, watch movies, and stream music. Click here to start your 30-day free Amazon Prime trial membership.



YOUR SUGGESTIONS?


Are you putting any of these items on your holiday wish list? If so, let me know which ones in the comments below. Do have anything you’d like to recommend to me?