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!
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!
Have not had a chance to read as yet but I gobble up all things Excel.
“… gobble up all things Excel”. I like that! 🙂
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. 🙂
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!
Thank you Cynthia! I’m glad to hear it helped you.
I like all of it- like Alt += for sum
Please tell me that how i change or create shortcut keys in excel 2010 or 2013 ???
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
My Excel skills are rusty; thank you for bringing me up to date.
Thanks Claudette!
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.
Thank you so much for your support Mira! 🙂
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!!! 🙂
Hey Cathy,
Thanks again for joining us. I have a free video series on Pivot Tables & Dashboards that you might like.
The shortcut to clear filters is Alt,A,C. You can also add the Clear Filters button to the Quick Access Toolbar to create a shortcut key for it. Here is a very popular article I have on 7 keyboard shortcuts for Filters. I also just published a video series on Filters. The second video in that series is all about keyboard shortcuts. And here is an article on how to use keyboard shortcuts for the Quick Access Toolbar.
I hope that helps. 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 Don,
I have a video series on how to copy & paste with VBA macros. At the bottom of that page there is a link to a bonus video on how to copy and paste below the last used cell on a sheet. I hope that helps.
Hi Jon
thank for send email this file information use for began level
so thanks
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.
Joe
how to learn v lookup formula
How to copy only selected cells in the excel sheet.
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.
Thanks For Your tremendous Support 🙂
thanks alot for ur efforts!!!!
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.
Michele
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
i WANT THE BOOK