Save Tons of Time When Working with Excel Formulas!

10 Excel Pro Tips eBook

No matter what skill level you are at with Excel, chances are that you spend a lot of your time writing and editing formulas.  In this book I share techniques that I use every day to help save time when working with formulas.

The book contains 10 Awesome Techniques, and each of these is filled with screenshots and step-by-step instructions to help you learn.  The book also comes with an Excel workbook that helps you follow along and put these techniques to use right away.

The tips in this book can be used for either Windows or Mac versions of Excel from 2003 to present, and it does contain the Mac equivalent keyboard shortcuts where applicable.

The book is free and you just have to subscribe to my free email newsletter to get it.  The email newsletter will keep you up-to-date with new blog posts and other great content to help you learn Excel and save time with your daily tasks.  So it's a win-win!

Sign Me Up!

My newsletter is full of tutorials, videos, and tools to help improve your Excel and VBA skills.  No spam, just cool Excel stuff to help you learn!

So what do you think?

I would love to get your thoughts about the book and hear some of your time saving tips.

What is one tip from the book you found useful?

What is a tip that is not in the book that you use everyday?

Please leave a comment below.  Thanks!


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

  • Lots of great tips – I love keyboard shortcuts and it’s great to have the Mac equivalents, now that I’ve moved from Windows.

    • Thanks Lynne! I recently started working on an Excel project with my church and more than half of the team are using Macs. I was teaching some techniques on a Mac and realized how slow I was on the Mac because I didn’t know the equivalent shortcuts. I’m planning to include more Mac equivalent shortcuts and tips in the future. 🙂

  • Thank you for the tutorial on Index and Match and 10 xls tips.

    Have a Happy New York

    presently hv not been working so not able to take one of your course

  • I thought I was pretty good at this excel stuff until I reviewed your pro tips spreadsheet…WOW you saved me a bunch of time…I’ve been doing things the hard/long way. I never knew that you could type only one parenthesis and click cells to add them to the formula then close them. That is a huge find for me! BTW your VBA pro course is really great and jam pack with valuable information…every one should buy one…it’s so worth the money……..Thanks

    • Hi Sam,

      Thank you for the great feedback. We will never stop learning new tips, tricks, and techniques for Excel. It feels like there is an infinite number of possibilities with this app, and I believe that is what makes it fun and challenging. I really appreciate your support and I’m so happy to hear you are enjoying The VBA Pro Course. It sounds like you are becoming an Excel superstar. 🙂 Thanks again Sam!

  • Hello Jon,
    Thanks so much for making time to reply to all my emails despite your tight schedule. Thanks for this hands on practice. I’m finally picking up speed on my excel skills after not using it often in a while.
    Please how do I get to take some of your courses-VBA Pro et al?

    • Hi Meg,
      I’m sorry to not reply to your comment sooner. I’m way behind on the blog comments. Thank you so much for your support! I am happy to hear you are learning so much about Excel. 🙂

  • I cannot close my mouth for 2 minutes when I saw your book, and you are giving it to us for free. See I told you that you are Great Guru, Compassionate and with a heart of a Saint.
    I am so happy. You put alot of time and effort for the other people’s life easier…….
    Thank you so much My Guru Jon Acampora….. Thank you, so much the book is fool of things that others don’t know…..
    Thank you so much….. and God Bless You and Your Family……

  • You are right. Your book is so full of tips, and shortcuts. Great job. And you are a saint….. what else can I say, I know how much time and efforts you put into writing the books. Thank you so much.

  • Thanks Jon for sharing your knowledge and expertise on Excel. I love learning new tricks in this program and welcome any additional info you have on Pivot tables. This quick lesson on copying only visible fields is very helpful for me and I did add this to my tool bar.

    I would also like to add a short cut key for removing all filters. I can research but if you have something already on this and could send it my way… it would be much appreciated!!

    I’ll definitely try to send you some tricks I’ve found as well if I happen to think of any that you don’t already know. Take care and thanks again!!! 🙂

  • Jon, I have been working on a project that copies a number from a cell(that doesn’t change) on one sheet and pastes it to a changing cell within a range on another sheet(by row, then column).

    Do you have any ideas, as I have not been able to find anything that will work?

  • Hi, Thank you for all your efforts.

    Wish me all the best for my tomorrow interview 🙂

    Stay blessed.

  • How can I collapse data so that only rows that have a blank remain?
    I would then get the data to fill in the blanks.


  • I would love love love to really understand how to create a pivot table that could organize the following columns of info, but can’t:
    Name, WK State, Position, HRs, Wages, EmplyerTaxes, PHW

    The lessons show basic info but why is it so hard to set up these columns and their data?

  • Hi Jon,

    The PDF of 10 Excel Pro Tips downloaded but the Excel Workbook did not. How can I get that?

  • I’m not very savvy about Excel in general, but use it constantly in my little home business/hobby. The tips and instructions from your campus have helped tremendously. Many hours of repetitive tasks have been reduced to minutes.

  • I am TOTALLY digging your video on conditional formatting!!! I was looking for a video for hours that helped me to highlight a row when a date was involved and it finally worked when I found you! THANK YOU FROM THE BOTTOM ON MY TOES.

  • very very helpful!
    your videos are usually very simple and easy to follow.
    the short cuts really make working in excel more pleasnt.
    Thank you Jon