Resources - Excel Campus

Resources

The goal here at Excel Campus is to help you learn Excel and save time with your everyday tasks.  This will help you improve your skills and grow your career.

Jon with Excel Books Photo

This page contains information and links to different resources that have really helped me on my Excel journey, and I hope they will help you as well.  I only recommend products that I have personally used and find valuable.

I have also had the privilege to meet most of the authors on this page, and they are a fantastic group of people.  They are truly passionate about Excel and helping others learn.

Please note that some of the links below are affiliate links.  This means I make a small commission if you decide to purchase one of these products, however there is NO additional cost to you.  

Topics

The page is broken up into topics to help you find what you’re looking for.

Pivot Tables

The Pivot Ready Course (online course)
by Jon Acampora from Excel Campus

My Pivot Ready Course is a step-by-step training on how to get started with pivot tables.  The course focuses on the most critical step for using pivot tables, which is preparing your source data.  You will learn how pivot tables work and how to master this powerful Excel tool.

I also has a Free Webinar on Pivot Tables  called “The 5 Secrets to Understanding Pivot Tables” that will help you get started

Xtreme Pivot Table Course

Xtreme Pivot Table Course (online course)
by John Michaloudis from MyExcelOnline.com

This is an in-depth course on Pivot Tables that covers just about every aspect of this powerful Excel tool.  The course contains 9 hours of instruction, broken up into 217 short videos for the beginner to advanced user. The short videos make this a great reference if you need to go back for a quick refresher on a specific technique.

John also has a Free Webinar on Pivot Tables that will teach you the basics.

cover_core_pivot

Core Pivot (online course)
by Dave Bruns from ExcelJet.net

Core Pivot is a well rounded course that will teach you all the major features of Pivot Tables.  The course contains over 2 hours of instruction, broken up into 49 short videos.  If you have never used Pivot Tables, this is a great introduction to one of Excel’s most powerful tools.

Excel 2013 Pivot Table Data Crunching (book)
by Bill Jelen and Mike Alexander

This book is a fantastic reference for both beginners and advanced users.  It does a great job of introducing the beginner to Pivot Tables, and includes companion files you can download and practice the techniques.  For the advanced user you will probably say, “huh, I didn’t know you could do that!”, more than a few times while reading this book.

Formulas & Modeling

Advanced Excel Essentials (book)
by Jordan Goldmeier

This is not your everyday Excel reference book.  Jordan presents a different approach to how things are “normally” done in Excel & VBA.  From nested IF statements to advanced database models in Excel, he covers a lot of areas that will help any analyst.  You might not agree with all of his techniques, but I really appreciate that Jordan makes you think outside the box here.  It has definitely helped me rethink some of my design and development practices.

Excel Basics – Tips & Tricks


This Isn’t Excel, It’s Magic! (book)
by Bob Umlas

Did you know that Shift+Enter on the Find Menu finds the previous entry (instead of the next entry)?  Every time I pick up this book I learn an awesome little shortcut, and usually say “wow!”.  This is one of those references that will arm you with tricks that will impress your co-workers/boss.  Not only do these little shortcuts add up to a lot of time saved, but they also inspire me to keep learning the vast ocean that is Excel.

Excel Tables eBook - Zack Barresse - Kevin Jones

Excel Tables (book)
by Zack Barresse and Kevin Jones

A whole book on Tables! My friends Zack Barresse and Kevin Jones have written THE GUIDE to everything Tables.  This is a great read if you are looking to master Excel Tables. It also includes tons of information and resources for writing VBA for Tables.
eBook Version – Excel Tables Book
Paperback version – Excel Tables Book


Laminated Keyboard Shortcut Card (accessory)
by Dave Bruns at ExcelJet.net

If you read my blog then you know I love keyboard shortcuts! This reference card contains over 200 keyboard shortcuts for both the Windows and Mac versions of Excel. I always reference this when I’m using Excel on a Mac, and it has been a lifesaver. Keep one on your desk and one in your briefcase/backpack.

Macros & VBA


Excel 2013 Power Programming with VBA (book)
by John Walkenbach

At 1,104 pages this book can be considered the encyclopedia of VBA. It’s massive! I started learning VBA with the 2003 version of this book, and continue to buy the latest versions. This is another one of those references that I learn something new from every time I pick it up. John does a great job of explaining the basics of the VBA application, and the book also comes with a CD that contains a ton of sample files to help you learn the code.


Excel VBA Programming For Dummies (book)
by John Walkenbach

I consider this book to be the “crash course” version of the Power Programming book above.  VBA Programming for Dummies is probably my favorite VBA book.  It’s only 390 pages in length, and it’s a great read if you are just getting started with VBA.  John does a fantastic job of going over the basics of object oriented programming in Excel, and provides a great introduction to coding.  The covers all essentials of creating macros, add-ins, applications, and more.


Professional Excel Development (2nd Edition) (book)
by Rob Bovey , Dennis Wallentin, Stephen Bullen, John Green

If you are looking to take your VBA skills to the next level and develop an application or add-in, then this is the book for you.  I learned a lot of great techniques and best practices from this book, and still continue to reference it.  It even dives into .Net development for Excel, which will help you develop more robust and commercial quality applications.

Charts, Dashboards, & Data Visualization

Free Webinar on Excel Dashboards

Excel Dashboard Webinar (free webinar)
by Mynda Treacy at MyOnlineTrainingHub.com

This free webinar by my friend Mynda Treacy will help you create your first dashboard.  It is packed with information on how to create a fully interactive dashboard from start to finish.  You will learn: why it is important to plan your dashboard before creating it, how to prepare your data, and how to create interactive charts and reports.  This is a fantastic introduction to dashboards, and you will probably pick up some great tips even if you are familiar with dashboard design.

 

Dashboards Logo

Excel Dashboard Course (online course)
by Mynda Treacy at MyOnlineTrainingHub.com

The ability to effectively communicate your data and analysis is probably one of the most valuable skills for any analyst.  Employers are always looking for someone that can create visualizations that tell a story to executives and upper management.  This course equips you with all the Excel charting and data mining skills necessary to create great looking dashboards.  It includes over 9 hours of instruction, broken up into 70+ videos.  I find myself re-watching these videos all the time for a quick refresher on the techniques.  Checkout my full video review of the course.

Business Intelligence – PowerPivot, PowerQuery, PowerMap

Excel PowerPivot Logo

Power Pivot for Excel Course (online course)
by Mynda Treacy at MyOnlineTrainingHub.com

If you want to take your data crunching skills to the next level, then PowerPivot is a must know.  This course is great for beginners and will teach you everything you need to know to get started with PowerPivot.  The course includes over 5 hours of video, broken up into 75 short videos.  Your teacher Mynda sets the standard for online courses with her high quality videos and exceptional teaching style, and you won’t be disappointed.  Checkout my full review of the course.


DAX Formulas for PowerPivot (book)
by Rob Collie

This book really opened my eyes to the power of PowerPivot.  Rob helped create PowerPivot, so it’s no wonder that this book is filled with techniques that will really help you get the most out of this tool.  For me this book was an extremely valuable reference for the first PowerPivot project I worked on, and I continue to reference it.  It has a lot of great examples and sample files to follow along with.

M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query (book)
by Ken Puls and Miguel Escobar

I often refer to Ken Puls (the co-author) as “Mr. Power Query”. Both Ken and Miguel are a few of the leading experts in the field of Power Query. They conduct live training seminars and know just about everything there is to know about this tool. This book will help get you started with Power Query, and become a power user. It is a great reference to keep on your desk.

Power Query for Power BI and Excel (book)
by Chris Webb

Power Query is probably one of the most practical new Business Intelligence tools from Microsoft.  It will save you a ton of time with transforming your data and automating common processes.  Chris’s book is a valuable resource that covers all the basic and advanced features of Power Query.  It also includes some great recipes (examples) that will show you some of the capabilities of this tool.

Accessories

Logitech K270 Keyboard
by Logitech

I have tried a lot of different keyboards and I really like this combo from Logitech.  It is very simple in design and doesn’t contain all those extra buttons that we never use.  Plus, the function keys (F2 in particular) are big and easy to press.  I wrote an entire article on what makes a good keyboard for Excel.

Keyboard Guide Excel Keyboard Shortcuts Comparison

I Simply Excel T-Shirt

I Simply Excel T-Shirt
by Microsoft

If you love Excel, then make it official and get a t-shirt.  🙂  I had the opportunity to visit the Microsoft campus in Redmond recently for the MVP Summit, and I couldn’t leave without one of these.   I even take mine paddle boarding…

Jon in Excel Shirt GoPro

What did I miss? Please contact me and let me know about any resources that have helped you with Excel.  I will be happy to review and share them here.