Save Tons of Time When Working with Excel Formulas! - Excel Campus

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!

Click Here to Leave a Comment Below 22 comments
Don - April 28, 2017

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?

Reply
Cathy - December 30, 2016

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!!! 🙂

Reply
Mira Hassan - November 4, 2016

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.

Reply
Mira Hassan - November 4, 2016

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……

Reply
Meg - October 11, 2016

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?

Reply
    Jon Acampora - October 22, 2016

    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. 🙂

    Reply
Sam Sammito - October 10, 2016

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

Reply
    Jon Acampora - October 11, 2016

    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!

    Reply
Claudette Merlin - April 20, 2016

My Excel skills are rusty; thank you for bringing me up to date.

Reply
wilson - December 30, 2015

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

Reply
Humair - December 17, 2015

Please tell me that how i change or create shortcut keys in excel 2010 or 2013 ???

Reply
lewis withey - October 28, 2015

I like all of it- like Alt += for sum

Reply
Cynthia Munoz - December 2, 2014

I thought the tip about pivot tables was really good at this website: https://www.excelcampus.com/modeling/structure-pivot-table-source-data/. Nice job explaining!

Reply
Lynne - April 30, 2014

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

Reply
    Jon Acampora - April 30, 2014

    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. 🙂

    Reply
Michael McCann - April 30, 2014

Have not had a chance to read as yet but I gobble up all things Excel.

Reply

Leave a Reply: