Master Excel with our tips, tricks & tools!
Subscribe to our 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 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

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

How To Copy & Paste Visible Cells Only

How To Copy & Paste Visible Cells Only

Have you ever tried to copy and paste a range with hidden rows or columns and didn’t get the results you expected? This problem can be frustrating and time consuming! In this post and video I will explain how to solve this problem with a very simple shortcut to select the visible cells only.Continue Reading

How To Compare Multiple Lists of Names with a Pivot Table

How To Compare Multiple Lists of Names with a Pivot Table

If you have ever had to create a report that compares two or more lists in Excel, then this tutorial will really help you. You will learn a simple technique to create this report using a Pivot Table. It is very easy to implement and there are NO formulas required.Continue Reading

The INDEX Function – A Road Map For Your Spreadsheet

The INDEX Function – A Road Map For Your Spreadsheet

This post will just focus on explaining the how the INDEX function works. It is best to understand the basics of INDEX before creating more advanced formulas using INDEX & MATCH.Continue Reading

VLOOKUP & MATCH – A Dynamic Duo

VLOOKUP & MATCH – A Dynamic Duo

This post provides an explanation of how to use the VLOOKUP and MATCH functions to give you better control over how the column index number changes.  This is often referred to as a dynamic formula.  You will learn how this dynamic duo can help prevent errors and improve your VLOOKUP formulas. The Dynamic Duo WeContinue Reading

VLOOKUP Explained in Simple Terms at Starbucks

VLOOKUP Explained in Simple Terms at Starbucks

This post explains the Vlookup function in simple terms using a Starbucks menu as an example. Includes a step-by-step guide on creating a vlookup formula and free file download to follow along.Continue Reading

7 Keyboard Shortcuts for the Filter Drop Down Menus

7 Keyboard Shortcuts for the Filter Drop Down Menus

This post will explain 7 keyboard shortcuts for the filter drop-down menus. This includes my new favorite shortcut, and it’s one that I think you will really like!Continue Reading

5 Excel Keyboard Shortcuts for Font or Fill Colors

5 Excel Keyboard Shortcuts for Font or Fill Colors

Looking for the keyboard shortcuts to apply font and fill colors to a cell? Unfortunately, there aren’t any built-in to Excel, but this article explains some workarounds and an easy way to customize your own.Continue Reading

Best Keyboards for Excel Keyboard Shortcuts

Best Keyboards for Excel Keyboard Shortcuts

This post explains things to look for in a keyboard that will make it easier to use the most common keyboard shortcuts in Excel for Windows. I also recommend some great keyboard that meet these criteria.Continue Reading