Master Excel with my tips, tricks & tools!
Subscribe to my free email newsletter
& receive a Free Gift!
Excel Campus is dedicated to helping you improve your Excel skills.
  • Add Zoom Button to Excel Charts
  • Excel Keyboard Shortcuts for Font Fill Colors
  • Excel Quarter Sum Formulas Add-in

    Create Quarterly Sum Formulas Instantly

  • Stacked Bar Column Chart Alternatives

    Stacked Column or Bar Chart Alternatives

  • Pivot Table Source Data Structure
_

Expand your knowledge with our Recent Blog Posts

How To Sum All Columns in the Total Row of an Excel Table

How To Sum All Columns in the Total Row of an Excel Table

In this post and video I explain how to add the sum (subtotal) to all the cells in the Total Row of an Excel Table. Copy & paste does not work, but I share 2 techniques that will make this process fast and easy.Continue Reading

5 Ways to Use the VBA Immediate Window in Excel

5 Ways to Use the VBA Immediate Window in Excel

The VBA Immediate Window is a great tool that can help any Excel user, even if you are not writing macros. Learn how to get answers about your Excel file, quickly run macros, debug your code, and more. Free file to download contains VBA code samples.Continue Reading

Resize Plot Area in Excel Chart – Titles and Labels Overlapping

Resize Plot Area in Excel Chart – Titles and Labels Overlapping

Learn how to re-size the plot area of a chart to prevent the axis titles and labels from overlapping.Continue Reading

How To Create a Sales Pipeline Funnel Chart in Excel

How To Create a Sales Pipeline Funnel Chart in Excel

Learn how to make a funnel chart in Excel using a stacked bar chart. Download the template file to follow along, or copy the example into your workbook. This simple chart is a great way to visualize your sales pipeline stages.Continue Reading

Tab Hound & Tab Control for Mac – Now Available!

Tab Hound & Tab Control for Mac – Now Available!

That’s right Mac users!  The wait is finally over… The Mac versions of the Tab Hound and Tab Control add-ins are now available. What’s In The Mac Version? The Mac versions of both add-ins have all the same great features as the Windows versions.  These add-ins give you the  power to quickly find worksheets inContinue Reading

How To Jump to the Last Cell in a Selected Range

How To Jump to the Last Cell in a Selected Range

Learn how to select the last cell in a range of selected cells in this video. This is a great technique to use when pasting over existing data. Also get a sample page from my eBook on Navigating Excel with the Keyboard.Continue Reading

The Tab Hound and Tab Control Add-ins for Excel

The Tab Hound and Tab Control Add-ins for Excel

Learn how the Tab Hound and Tab Control add-ins will dramatically improve your productivity in Excel. Includes 19 videos that contain tons of Excel tips and shortcuts.Continue Reading

How To Automate Common Processes in Excel with Tab Control

How To Automate Common Processes in Excel with Tab Control

Do you spend time hiding and unhiding multiple sheets for a monthly reporting package? Learn how the Tab Control add-in can automate this process and save time with common worksheet tasks.Continue Reading

How To Organize & Manage Your Worksheets – Tab Hound & Tab Control

How To Organize & Manage Your Worksheets – Tab Hound & Tab Control

In the last video we learned how Tab Hound can save time with common tasks like finding and jumping to sheets, flipping between sheets, and unhiding multiple sheets. I really appreciate all your suggestions and support for Tab Hound. In this video I am going to explain: Shortcuts for copying and renaming sheets. A fast wayContinue Reading

How To Save Time with Everyday Excel Tasks – the New Tab Hound Add-in

How To Save Time with Everyday Excel Tasks – the New Tab Hound Add-in

Do you spend time doing any of the following tasks in Excel? Finding and navigating to worksheets. Flipping back and forth between two sheets. Hiding and unhiding multiple sheets. In the following video you will learn some Excel shortcuts to help save time with these tasks.  You will also see how the new Tab HoundContinue Reading