# Excel Campus - Jon

• ### Welcome to the Excel Campus YouTube Channel

56,325 views 1 year ago
Hello and welcome to the Excel Campus YouTube Channel! My name is Jon Acampora and I am excited you are here!

Thanks again and have a great day! Show less

• ### Excel Hash: Episode 2 - Attendance Report with Storm Clouds & Fireworks - Duration: 6 minutes, 16 seconds.

• 3,332 views
• 3 days ago
• ### 19 Advanced Excel Shortcuts (do you know them all?) - Duration: 10 minutes.

• 21,216 views
• 1 week ago
• ### Highlight Rows Between Two Dates with Conditional Formatting in Excel - Duration: 11 minutes.

• 3,989 views
• 3 weeks ago
• ### Conditional Formatting Rows Based on Cell Value - Duration: 8 minutes, 3 seconds.

• 5,785 views
• 4 weeks ago
• ### Actual vs Targets Chart in Excel - Duration: 12 minutes.

• 9,891 views
• 1 month ago
• ### How to Select Cells with Different Formulas or Values - Duration: 4 minutes, 57 seconds.

• 4,975 views
• 1 month ago
• ### INDEX MATCH Explained (An Alternative to VLOOKUP) - Duration: 19 minutes.

• 16,422 views
• 2 months ago
• ### Excel Formula Performance Test: VLOOKUP CHOOSE vs INDEX MATCH - Duration: 7 minutes, 42 seconds.

• 6,557 views
• 2 months ago
• ### 7 Uncommon Excel Shortcuts to Teach to Your Coworkers - Duration: 7 minutes, 53 seconds.

• 91,350 views
• 2 months ago
• ### How to Prevent Vlookup Errors when Inserting or Deleting Columns (#REF! Error) - Duration: 7 minutes.

• 4,116 views
• 3 months ago
• ### XLOOKUP for Excel: Explained in 3 Minutes - Duration: 3 minutes, 33 seconds.

• 10,573 views
• 3 months ago
• ### The New XLOOKUP Function: Compared to VLOOKUP & INDEX MATCH in Excel - Duration: 20 minutes.

• 25,348 views
• 3 months ago
This item has been hidden
• ## Excel Pivot Tables Play all

Pivot Tables are one of the most powerful tools in Excel for creating summarized reports and analyzing data. These videos will help you learn how to use pivot tables to work with your data and save time creating reports, charts, and dashboards in Excel.

Signup for my free video series and pivot table checklist at: http://www.excelcampus.com/pivot-table-checklist-yt

Checkout all my articles on pivot tables at:http://www.excelcampus.com/category/pivot-tables/
• ### Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1) - Duration: 14 minutes.

• 8,143,438 views
• 4 years ago
• CC
• ### Introduction to Pivot Tables, Charts, and Dashboards (Part 2) - Duration: 14 minutes.

• 1,924,765 views
• 4 years ago
• ### How to Create a Dashboard Using Pivot Tables and Charts in Excel (Part 3) - Duration: 15 minutes.

• 1,637,992 views
• 4 years ago
• ### Why is the Pivot Table Field List Missing & How to Get It Back - Duration: 4 minutes, 18 seconds.

• 113,390 views
• 3 years ago
• ### How to Add a Search Box to a Slicer in Excel - Duration: 6 minutes, 38 seconds.

• 179,991 views
• 3 years ago
• ### Setup a Slicer to Sort or Filter Another Slicer for Quick Navigation - Duration: 8 minutes, 36 seconds.

• 83,444 views
• 3 years ago
• ### How to Filter Pivot Tables for Month-to-Date MTD Comparisons with Slicers - Duration: 9 minutes, 28 seconds.

• 117,134 views
• 3 years ago
• ### How to Analyze Survey Data Part 3 - Summarize with Pivot Tables and Charts - Duration: 6 minutes, 3 seconds.

• 68,008 views
• 3 years ago
• ### How to Analyze Survey Data Part 2 - Unpivot Column of Comma Separated Values - Duration: 4 minutes, 4 seconds.

• 22,161 views
• 3 years ago
• ### How to Analyze Survey Data Part 1 - Unpivot Data with Power Query - Duration: 5 minutes, 44 seconds.

• 53,056 views
• 4 years ago
• ### Pivot Chart Formatting Makeover in Excel 2010 - Duration: 3 minutes, 8 seconds.

• 36,602 views
• 4 years ago
• ### Slicer Pivot Table Cache Relationship and the Filter Controls Error - Duration: 7 minutes, 22 seconds.

• 13,814 views
• 3 years ago
This item has been hidden
• ## Excel Macros & VBA Play all

Learn how to write macros with VBA (Visual Basic for Applications) to create automated Excel processes that can be run with the push of a button.
• ### How to Create a Personal Macro Workbook in Excel and Why You Need It (Part 1 of 4) - Duration: 6 minutes, 58 seconds.

• 108,222 views
• 3 years ago
• ### Where Is The Personal Macro Workbook Stored and How to View It (Part 2 of 4) - Duration: 5 minutes, 11 seconds.

• 77,862 views
• 3 years ago
• ### How to Add Macro Buttons to the Excel Ribbon or Quick Access Toolbar (Part 3 of 4) - Duration: 8 minutes, 36 seconds.

• 137,109 views
• 3 years ago
• ### How to Add a Yes No Pop-up Message Box to a Macro Before it Runs (Part 4 of 4) - Duration: 9 minutes, 22 seconds.

• 59,087 views
• 3 years ago
• ### How to Write VBA Macros to Copy and Paste Cells in Excel - Part 1 of 3 - Duration: 4 minutes, 56 seconds.

• 269,702 views
• 4 years ago
• ### How to Write VBA Macros to Copy and Paste VALUES in Excel - Part 2 of 3 - Duration: 3 minutes, 20 seconds.

• 137,808 views
• 4 years ago
• ### How to Write VBA Macros to Copy and Paste in Excel - Part 3 of 3 - Duration: 8 minutes, 25 seconds.

• 93,284 views
• 3 years ago
• ### Find the Last Row, Column, or Cell in Excel VBA with the Range.End Method (Part 1 of 3) - Duration: 6 minutes, 56 seconds.

• 126,296 views
• 4 years ago
• ### Find the Last Row, Column, or Cell in Excel VBA with the Range.Find Method (Part 2 of 3) - Duration: 13 minutes.

• 39,153 views
• 4 years ago
• ### Find the Last Row, Column, or Cell in Excel VBA with the SpecialCells Method (Part 3 of 3) - Duration: 5 minutes, 22 seconds.

• 15,351 views
• 4 years ago
• ### Excel Zoom on Charts Macro Tutorial - Duration: 9 minutes, 35 seconds.

• 15,566 views
• 6 years ago
• ### How to Install an Excel Add in - Duration: 4 minutes, 21 seconds.

• 225,759 views
• 3 years ago
This item has been hidden
• ## Created playlists

• ### Excel Charts & Dashboards - Playlist

This item has been hidden
• ## Popular uploads Play all

• ### Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1) - Duration: 14 minutes.

• 4 years ago
• 8,143,438 views

In this video series you will learn how to create an ...
• CC
• ### Introduction to Pivot Tables, Charts, and Dashboards (Part 2) - Duration: 14 minutes.

• 4 years ago
• 1,924,765 views
http://www.excelcampus.com/charts/pivot-tables-dashboards...
This is part 2 in the series on an introduction to pivot tables and dashboards. In this video I explain some of the different pivot...
• ### How to Create a Dashboard Using Pivot Tables and Charts in Excel (Part 3) - Duration: 15 minutes.

• 4 years ago
• 1,637,992 views
http://www.excelcampus.com/charts/pivot-tables-dashboards...
This is part 3 in the series on Pivot Tables and Dashboards. In this video we bring it all together to create the interactive dashb...
• ### How To Paste to Visible Cells in Excel - Duration: 4 minutes, 2 seconds.

• 4 years ago
• 344,808 views
http://www.excelcampus.com/paste-buddy
Learn a few tips for pasting to a range that contains hidden rows or columns, when you want to copy & paste to the visible cells only. This allows you to ski...
• ### How to Create Drop Down Lists in Cells - The Complete Excel Guide - Duration: 12 minutes.

• 1 year ago
• 318,823 views
In this video you will learn how to create drop down lists in cells in Excel. These are also referred to as Data Validation Lists. The drop down lists allow the user to select from a drop-down me...
• ### How to Write VBA Macros to Copy and Paste Cells in Excel - Part 1 of 3 - Duration: 4 minutes, 56 seconds.

• 4 years ago
• 269,702 views
Free Video Training Series on Macros & VBA: http://www.excelcampus.com/free-vba-training
Learn how to copy and paste cells...
• ### Copy & Paste Visible Cells Only in Excel for Windows or Mac - Duration: 3 minutes, 44 seconds.

• 5 years ago
• 265,762 views
Use this simple keyboard shortcut to select the visible cells only when copying and pasting a range with hidden rows or columns or filtered data.
Windows: Al...
• ### How to Install an Excel Add in - Duration: 4 minutes, 21 seconds.

• 3 years ago
• 225,759 views
Step-by-step instructions on how to install an Excel add-in in Excel 2007, 2010, 2013, 2016 for Windows.

IMPORTANT NOTE: A July 2016 Office Security Update is causing the add-in ribbon menu to di...
• ### How to Add a Search Box to a Slicer in Excel - Duration: 6 minutes, 38 seconds.

• 3 years ago
• 179,991 views
Learn how to add a search box to a slicer to quickly filter pivot tables, pivot charts, or Excel Tables.
• ### Progress Circle Chart in Excel - Part 1 of 2 - Duration: 7 minutes, 11 seconds.

• 2 years ago
• 163,868 views
The progress circle (doughnut) chart displays the percentage of completion on a single metric. This is a simple chart that can be used in dashboards to show the progress towards a goal or target. ...
• ### 2 Ways to Reverse the Number Sign Positive Negative in Excel - Duration: 5 minutes, 51 seconds.

• 2 years ago
• 149,453 views
Learn 2 ways to reverse the sign of a number from positive to negative or negative to positive in Excel.

https://www.excelcampus.com/tips/reverse-number-sign/

Flipping or reversing the number sig...
• ### How to Install Power Query in Excel 2010 or 2013 for Windows - Duration: 4 minutes, 4 seconds.

• 3 years ago
• 144,704 views
Learn how to install Power Query with this step-by-step tutorial for Excel 2010 or 2013. If you have Excel 2016 then Power Query is already built-in and located on the Data tab of the ribbon.

The...
This item has been hidden
to add this to Watch Later