I'm giving away 4 copies of Bill Jelen's newest book, MrExcel XL: The 40 Greatest Excel Tips of All Time.

Note: The contest is now over, but checkout my review of this great book below.  There is also a video at the end of the page with a tutorial on the winning tips.

Win a Copy of the Mr Excel 40 Greatest Tips Book

My Review of this Awesome New Book

Not all Excel books are created equal.  My friend Bill Jelen (aka Mr. Excel) released a new book last month titled, MrExcel XL: The 40 Greatest Excel Tips of All Time.

This is Bill's 40th Excel book, and I have to say it is probably my favorite Excel book of all time.

MrExcel XL The 40 Greatest Excel Tips of All Time - Book Cover

This book is not only packed with Excel tips and tricks, it is also very entertaining and sure to provide some laughs.

Bill has put together the 40 Greatest Excel Tips Of All Time for this book, and it is packed with awesome time saving tips and techniques.  If you have ever been to one of Bill's live seminars or read one of his other 39 books, then you've probably found yourself saying, “Wow!  I never knew Excel could do that!”  This new book is no exception.

Mr Excel 40 Greatest Tips of All Time - Sample Pages

The image above is an example of one of the tutorials in this book.  I'm a visual learner and really appreciate all the screenshots.

30 Additional Excel Tutorials

Szilvia Juhasz (my friend and co-host of Excel TV) co-authored this book with Bill and added 30 additional Excel tips and tricks.  This was in honor of Excel's 30th birthday this year, and this section of the book is packed with some fantastic tips.

Szilvia was also kind enough to mention my name in reference to my explanation of VLOOKUP with the Starbucks menu.  Checkout page 194 for that one.  Thank you Szilvia! 🙂

Mr Excel 40 Greatest Tips of All Time - VLOOKUP Example

So that's 70 Excel tips and tutorials that are clearly explained with nice screenshots and images, all on glossy pages.  It's an awesome book and I have picked up some great tips from it.  No matter how long you have been using Excel, there is always something new to learn.

Have You Ever Had an Excel Cocktail?

But it doesn't stop there.  This book is not only a great learning reference, it is also very entertaining.

Part 3 of the book includes Szilvia's new book called, The Excel Lover's Guide to Cocktails.

The Excel Lover's Guide to Cocktails - Mr Excel Book

This is an Excel inspired cocktail recipe book.  You will learn how to make some great drinks like the Power Pivotini (think Martini), Stacked Column Shot, Ctrl+B (think Bloody Mary), Broken Link (think Old Fashion), and many more.

The cocktail book is included as a section inside the book and contains some great pictures of each drink.

The Excel Lover's Guide to Cocktails - Sample Pages

These would be a lot of fun to make for any office party, and I advise consuming after you have finished working with Excel for the day. 🙂

Get Ready to Laugh!

After you make yourself an Excel cocktail you can flip through part 4 of the book – Excel Fun.

Mr Excel 40 Greatest Tips of All Time - Excel Jokes

This last section of the book includes an Excel Joke Book by Jordan Goldmeier, a collection of hilarious Excel Tweets collected by Debra Dalgleish, Excel Art by the Frankens Team, and a collection of True and Almost True Stories from Mr. Excel himself.

If you work with Excel a lot then you have experienced your fair share of ups and downs.  Happy dances when things go right, and head pounding frustration when things break.  This section of the book makes light of a lot of those challenges, and let's you know that you are not alone… 🙂

The inside back cover also includes the Periodic Table of Excel Keyboard Shortcuts by Mike Alexander.  I love keyboard shortcuts and this is a really cool visual reference using the periodic table.

There is a ton of content packed into this 277 page book.  I love to just flip through it and learn something new every time I pick it up.  All the pages are glossy and you can tell that a lot of work went into the artwork and images.  It's a great book to keep on your desk, or to give as a gift to your favorite Excel geek.

Win a Free Copy of the Book

To help spread the word about this awesome book, I am going to give away 4 free copies!

Win a Copy of the Mr Excel 40 Greatest Tips Book

This will be the printed version of the the book.  You can check it out here on Amazon or The Mr Excel Bookstore.

I will hold a drawing and to pick the winners at random.

I want to make it as easy as possible for you to enter the drawing.  So, all you need to do is leave a comment at the bottom of this post with your favorite Excel tip.

This could be something as simple as your favorite keyboard shortcut or formula.  One of my favorites is the Alt+; keyboard shortcut to select visible cells.

Add a sentence or two to describe what your shortcut or tip does, so others can learn from it.  And don't worry about it being the most amazing tip ever, just something simple that saves you time.

Winners Announced!

I want to say a big THANK YOU to everyone that participated in this contest.  There were over 350 unique comments, and a lot of great tips that we can all learn from.

Here are a list of the winners I picked at random.  I accidentally picked 6, instead of 4, so we have two extra winners.  Congratulations!

  • Lynne – Ctrl+. (period) to move around selected range.
  • Rajendra – Use Pivot Tables for working with numbers – Report Filter Pages
  • Tom Crouch – Excel Tables and Ctrl+T
  • Diane Smith – Double Clicking the Format Painter
  • Matthew – F2 to Edit Text or Formula in active cell
  • Debra Holcomb – Ctrl+; (semicolon) to enter today's date

Video of the 6 Winning Tips

I also put together a tutorial video of the 6 winning tips listed above.

I will be adding more videos and tutorials on the tips you posted in the future.  Feel free to read through the comments below, and see how many of the tips you already know. 🙂

Thanks again!

 

401 comments

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

  • I often use Ctrl+W to close a workbook, Crl+O to open a workbook, Ctrl+P to print, and F12 for the Save As dialog. I use Ctrl+1 daily to format cells.

    I didn’t know about Ctrl+ and Ctrl- to add and delete columns and rows! Very cool… these will be added to my arsenal! Thanks!

  • Ctrl+shift * will select the entire table of data. You have to be in one of the cell of the data for the selection to happen. I am a fan of your Excel videos, Have learnt a lot from them. Thank You.

  • insert a “time stamp” on the fly on a sheet with ctrl+; (=current date) and/or ctrl+shift+; (=time now). You prevent so to use the today() function.

  • Ctrl+’

    As my last reply was being sent, it looked like the shortcut showed Ctrl+” – which is incorrect. The correct shortcut to copy a value above the current cell is Ctrl+’.
    Just wanted to make sure it was listed correctly, because it is a useful shortcut.

    Thank you.

  • I like your tips related to column and row of excel, especially shortcut ALT + H + O + I to adjust the column width to fit the contents

  • Thanks, Jon, for all the great blogs, tips and videos! You have a fantastic way of explaining complicated things in simple terms! I absolutely loved the Starbucks vLookup example and have shared it with multiple colleagues.

    My latest favorite Excel shortcut is CTRL+T to format data as a table.

  • Hi Jon,

    How about ALT +down arrow to display a list of previously entered values in a list. Great for maintaining data consistency.

  • Ctrl + 1

    This opens the format cell dialog, which allows to quickly format the cell without having to use the mouse or click through the options on the toolbar.

  • Favorite Excel tip – really a feature but I use it a lot and teach it to others: Pivot Tables. Starting to use slicers more but end users haven’t caught on to those yet and not sure how to use them.

  • Add “select current region” to the Quick access toolbar. The icon is a square with arrows on the corners. Find is in all commands. Just select a cell in the range or table and click the icon and the region is selected. Help me from scrolling down and across.

  • Tables are my favorite feature and when defining them I click in the upper left column heading and then select all the cells by holding down Ctrl + Alt and clicking END.

    Also like repeatedly using the Format Painter by Double-clicking on it to format as many cells as you want. (click on the icon again to turn it off)

  • my favourite shortcut is Alt + Enter, allowing you to start a new line of text within a cell
    my others are highlighting and moving around Ctrl+arrow keys to move and Ctril+Shift+arrow keys to highlight

  • Your videos are awesome. I have learned a lot and as a result this has made my job easier as I have to deal with a lot of data. Thanks!

  • Dragging the Fill handle is the BEST WAY to apply a formula to an entire column or row in EXCEL! Longtime fan of Bill Jelen & Jon Acampora. Use all they taught me at a hospital for various revenue and expense reports. This ‘XL AT XL’ Book sounds irresistible.

  • My favorite tip and the one I use the most is the ctrl down arrow followed by ctrl C and ctrl V; almost anything with ctrl works wonders.

  • My favourite tip is the Ctrl + Shift + down arrow to select all the data in the column because it is something I use all the time and it so quick and easy.

  • My favourite excel tip is pivot table. I used to think that it was something very complicated but sometimes it’s just me that complicate things.

    Excel is meant to be simple and easy for users – pivot table has nailed it.

  • My favorite tip is the use of Tables in spreadsheets. They make copying fomulas in the columns and adding data so much easier.

  • The newest short-cut I’ve learned (not counting all the comments here) is ctrl+a for select all.
    Thanks for all the info you’ve shared.

  • On the Formulas tab, click Show Formulas, highlight a series of formulas, and press Ctrl + H – add your find and replace values – to quickly change a group of formulas.

  • Hi Jon

    I like

    Vlookup and If statements a lot, as both of them would connect the and create a statements. Though we have alternative for both still I like both of them.

    Thanks,
    Sharan.

  • Favourite Excel tip :

    # Ctrl + 1
    I can format just format cells easily.

    # Ctrl + K
    For Hyperlink

    and of course the legendary short cut :

    #ctrl + c : to copy
    #ctrl + z : to undo
    #ctrl + x : to cut
    #ctrl + A : to select all

    Pivot Table and Dashboard is my latest crush now.

    🙂

Search
Generic filters
Exact matches only
Filter by Custom Post Type

JOIN US & LEARN EXCEL

Learn 10 great Excel techniques that will wow your boss and make your co-workers say, "how did you do that??"
Plus weekly updates to help you learn Excel.

Download the eBook

About Me

Jon Acampora Profile

Hello and welcome! My name is Jon Acampora and I'm here to help you learn Excel.

This blog is updated frequently with Excel and VBA tutorials & tools to help improve your Excel skills and save time with your everyday tasks. Subscribe above to stay updated. More about me...

MVP_Horizontal_BlueOnly