Profile cover photo
Profile photo
Jon Acampora
About
Posts

Post has attachment
What's better, a Pivot Table or SUMIFs formulas?  Why not use both? #Excel  
Add a comment...

Post has attachment
Learn a few techniques to quickly add the SUBTOTAL function to all the cells in the Total Row of an Excel Table. #Excel
Add a comment...

Post has attachment
Learn how to use the VBA Immediate Window to quickly execute code and get answers about your application (Excel files).  It's a very helpful tool even if you are not writing macros.
Add a comment...

Post has attachment
Checkout the new Tab Hound add-in that will save you a ton of time with your everyday Excel tasks.  If you have a workbook that contains more than 5 or 10 worksheets, Tab Hound will really help you get your job done faster.
Add a comment...

Post has attachment
Learn how to automate common Excel tasks with the new Tab Control add-in.
Add a comment...

Post has attachment
Learn how to quickly find and navigate to a sheet, flip back and forth between sheets, and hide/unhide multiple sheets at the same time in #Excel.  In this video I also preview and demo the new Tab Hound add-in.
Add a comment...

Post has attachment
If you've ever wondered why the hidden rows or columns get pasted when you copy a range of cells, this shortcut will really help you.
Add a comment...

Post has attachment

Post has attachment
Checkout my new video on the fastest and easiest way to paste values in Excel using this simple add-in called Paste Buddy.
Add a comment...

Post has attachment
Check out what Batman & Robin have to say about a way to make your VLOOKUP formulas more flexible and prevent errors.
Add a comment...
Wait while more posts are being loaded