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

Why Take an Excel Online Course When YouTube is Free?

I received a lot of great questions about the Dashboard and PowerPivot courses from MyOnlineTrainingHub.  I’m guessing that you might have these same questions, and in this post I will try to provide some answers. But first I want to remind you that registration for the Dashboard Course closes on October 23rd at 8pm PST.Continue Reading

Convert Pivot Table to SUMIFS Formulas – Free VBA Macro

Convert Pivot Table to SUMIFS Formulas – Free VBA Macro

This post contains a free VBA Macro that will convert any pivot table into a report containing SUMIFS, COUNTIFS, or AVERAGEIFS formulas. This will save you a lot of time when writing any of these IFS formulas.Continue Reading

How To Use PowerPivot Instead of VLOOKUP

How To Use PowerPivot Instead of VLOOKUP

In this post I will explain how you can use PowerPivot instead of VLOOKUP to save time and analyze your data in new ways. What is PowerPivot? PowerPivot is a free business intelligence tool from Microsoft that allows you to process and analyze large data sets in Excel.  It has a ton of great features, and here are someContinue Reading

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