Win a Copy of the New Mr. Excel Book! It's Awesome! - Excel Campus
396

Win a Copy of the New Mr. Excel Book! It’s Awesome!

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!

 

Please share
Jon Acampora
 

Welcome to Excel Campus! I am excited you are here. My name is Jon and my goal is to help you learn Excel to save time with your job and advance in your career. I've been an avid Excel user and VBA developer for 10+ years. I am also a Microsoft MVP. I try to learn something new everyday, and want to share this knowledge with you to help you improve your skills. When I'm not looking at spreadsheets, I get outdoors and surf. :) more about me

Click Here to Leave a Comment Below 396 comments
landy - July 30, 2017

hello im from cameroon central africa i your very interesting video and im realy need the book very powerful tools who who can change alots in my life how much its the coost thank alot landry

Reply
David - June 3, 2016

What is your viewpoint on pdf book?

Reply
    Jon Acampora - June 8, 2016

    Hi David,
    I don’t have the pdf version of the book, so I can’t really comment on that. The paperback version is great and I’m sure the pdf version will also be a great reference. I hope that helps. Thanks!

    Reply
vishnu - January 31, 2016

Function “F7” ==> Spell check

Reply
5 Little-Known Excel Tips That Will Make You Look Smarter Than Your Co-Workers - BRAD EDGAR - January 23, 2016

[…]  If you’re interested in seeing and checking out a review from an Excel MVP, checkout Jon Acampora’s review of the book. Unfortunatley, the contest that Jon held is now over but he does have some cool pictures/shots of […]

Reply
carmen roman - January 11, 2016

Is my first time seeing the video. So sad that the change of winning the book is over ill have to refresh my mind about excel on the pivot table because soon i have a job interview regard tables on excel.

Reply
    Jon Acampora - January 14, 2016

    Hi Carmen,
    I have a free 3-part video series on pivot tables and dashboards. Click here to download my pivot table checklist and get access to the videos. Thanks!

    Reply
laxman - January 6, 2016

Sir i want to learn a advance excel please provide me a book

Reply
Avi E. - January 2, 2016

Hi John

I have used command MOD in VBA to calculate times.
Before using MOD I calculate the hours, minutes and seconds separately as usual and then I convert the total minutes to hours and minutes and the total seconds to minutes and seconds
For example if Total_Minutes = 195 then
Hours = Total_Minutes MOD 60
Hours = 3 and Minutes = (Total_Minutes – Hours*60)/60
So Minutes = 15 and the result – 3:15 .
In my opinion it is a convenient way to perform arithmetic operations
on times.

Best Regards

Reply
Arvapally - December 29, 2015

Good Book

Its Creative

Reply
Jimson Seraspe Jr - November 15, 2015

Hi to all… can i have a book, cuz i new for excel, now i self study for my first job as office clerk. and that would be a great full for me if have this book… thank you and goodbless you all…

Reply
Stefan - November 12, 2015

I don’t know if it is a regional thing, but the short-cut for creating a table is
CTRL+L instead of CTRL+T in my version of Excel (Dutch). Just in case any one is wondering why the above mentioned shortcut doesn’t work for them.

Reply
Pablo Baez - November 12, 2015

Hi John,
I would love to have participated but I already bought the book, though I could have given away the extra one (in case of winning) to a coworker.
In any case, one of my favorite tips is how to create templates by defining my preferences and saving them as Book.xls? and Sheet.xls? to the XLSTART folder, very clever and a real time saver.
Great video by the way.
Thanks,
Pablo

Reply
Khuram Maqsood - November 11, 2015

Excel Tables and Double Clicking the Format Painter is wonderful

Reply
Thomas Lee` - November 11, 2015

“Ctrl+. “tip is really great. I am sure I will use this tip a lot.
Thank you.

Reply
Petrit - November 11, 2015

Double click Format Painter

Reply
Li - November 11, 2015

Very nice, just less than 10 min, I know more tips.

Reply
Ron - November 11, 2015

The Format Painter tip reminded me that you can format a range according to the formatting of another range.
If in say column A you have data with different formatting in each row for 5 rows that you want to copy to succeeding group of 5 rows.

Select the 5 cells in column A and click on the Format Painter. Now left click and hold in a cell where you would like to start copying the selected formats and drag down the column. The selected formatting will be faithfully reproduced in each 5 cell group.

I chose 5 cells just for convenience but you can have a much larger selection if necessary.

Reply
Nicole - November 11, 2015

A little addition to Mattew’s tip :
after F2 to edit a formula
click on fx and you will get the dialog box of the formula 😉

Reply
Wolgrand Neto - November 9, 2015

The best Excel Tip for me is Ctrl + Enter, inside a cell.

Reply
Amartesh singh - November 9, 2015

I always use CTRl+Shift+L to Filter & Alt+D+S to Short by

Reply
Tina Pollard - November 6, 2015

Your training video’s such as How to Remove or Replace Errors in Your Pivot Tables was very useful and easy to follow.

Reply
kay sobowale - November 6, 2015

CTRL + W = CLOSE WORKBOOK

CTRL + K = HYPERLINKS DIALOG

CTRL + H = FIND & REPLACE

Reply
Roberta - November 6, 2015

I have a regular downloaded spreadsheet which has headings in one column which only appear as the next section is reached – thus lots of empty cells between sections. I highlight from the first empty cell (assuming in A3) to the bottom of the colomun then
Ctrl+G (Go To), Special, Blanks (this selects all the blank cells). I then type =A2 (which is the first cell with a heading in my example) and press Ctrl+Enter at the same time.
This then populates all the empty cells with the heading above – and voila I have a proper database!!

Reply
Roberta - November 6, 2015

My favourite is using Alignment, TextAlignment, Center Across Selection.

This will allow you to type you heading in one cell – and center it across a range of cells without merging the cells together – thus you can still treat each column in your spreadsheet as an invidual column – including sorting and filtering.

Reply
Atif AbdulRehman - November 6, 2015

ALT + ; — to select specific selections in Lists

This shortcut really helped in lot of ways.

Reply
Anet - November 6, 2015

I use ctrl+c, ctrl+v and ctrl+end all the time. I learned a lot of new ones here today! Thanks. I wonder if there’s an excel bloody Maria in that recipe book . . . .

Reply
Greg - November 5, 2015

Ctrl + Shft + Down arrow, to select all data below that cell. Saved me lots of time!

Reply
M.J Banaei - November 4, 2015

My favorite shortcut is :
ALT + D + L : for data validation
ALT + D + O : for conditional formatting and Dragging the Fill handle and
ALT + J + T+ A for table name

Reply

Leave a Reply:

FREE Live Webinar 

The 5 Secrets to Understanding Pivot Tables
x

Take Your Excel Skills & Career to the Next Level

10 Excel Pro Tips eBook

Get my eBook & FREE weekly updates to help you learn Excel.

x