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

Tab Hound Features Update – Version 1.5

Tab Hound Features Update – Version 1.5

This post will explain some of the new features that have been added to the Tab Hound Add-in recently. Tab Hound Is Getting Better I have received a lot of great feature requests for Tab Hound since it’s launch.  The feedback has been incredible and I am so glad you are getting use out of this…

How To CONCATENATE a Range of Cells + VBA Macro

How To CONCATENATE a Range of Cells + VBA Macro

Bottom line: Learn two different ways to quickly concatenate (join) a range of cells. This includes the Ctrl+left-click method, and a free VBA Macro that makes it quick & easy to create the concatenate or ampersand formulas.
Skill level: IntermediateContinue Reading

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

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

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