Hello and welcome to Excel Campus!
My name is Jon and I'm here to help you on your journey to learn Excel.
Whether you're just getting started with Excel, or you're an old pro, there is always something new to learn. This page should help get you started on your quest to take your skills to the next level.
Your Excel Journey
Excel is a massive application with a ton of different features. The power and versatility of Excel is truly amazing.
But honestly, Excel can be challenging and frustrating some times. There are so many ways to accomplish the same task, and we don't always know the best way to do it.
Sometimes it feels like we are facing a huge mountain to climb, and don't know which path to take.
I can't say that I have all the answers, but I'm focused on constantly learning and improving. I want to share this journey with you in hopes that we can learn together, and also take our careers to the next level.
How to Get Started with Excel
There are so many different topics to learn in Excel. From formulas to charts to pivot tables to VBA macros, it can sometime be difficult to know where to begin.
A lot will depend on the job or project you are working on. I try to cover a wide range of topics on the blog for the beginner to advanced user.
If you are new to Excel, or really want to take your skills to the next level, then I recommend taking an online course. This will help you learn in a structured manner, and you can be confident that you are progressing in the right direction.
Online courses are great because they allow you to learn at your own pace, and you can use them as a resource to refer back to in the future. They also look great on your resume. Employers love to see that a person is taking initiative to learn and improve.
I have taken a ton of online courses, and here are a few that I recommend.
Courses for Beginners
Here are a few options if you are just getting started with Excel.
MyOnlineTrainingHub has a great introductory course, and it's free! You get almost 3 hours of instruction and each video is 3-5 minutes in length, making it very easy to consume.
by Dave Bruns from ExcelJet.net
This is a comprehensive course for the beginner that will get you to the intermediate level. From creating your first workbook to learning formulas, charts, and conditional formatting; this course covers all the basics. It includes 125 professional quality videos that are short and get right to the point. Watch a few on your lunch break and you'll be an expert in no time!
Intermediate to Advanced Courses
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.
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
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.
My Resources Page contains a lot of other training material including books, courses, add-ins, utilities, and accessories to help you work efficiently.
I also have a Downloads Page that contains all the Excel files, add-ins, and reference material that is available for download on this site. The majority of these downloads are free. The page is organized by topic to make it easy to navigate.
What Topics Are You Interested In?
The Excel Campus blog contains articles and video tutorials on a variety of different Excel topics. Here are a few links to help you get started.
- Formulas & Functions – VLOOKUP Explained at Starbucks > read all posts
- Pivot Tables & Tables – How Pivot Tables Work > read all posts
- Charts & Dashboards – Introduction to Pivot Tables, Charts & Dashboards > read all posts
- Keyboard Shortcuts – 7 Shortcuts for the Filter Drop-down Menus > read all posts
- Power BI (Business Intelligence) – VLOOKUP vs PowerPivot > read all posts
- VBA & Macros – 5 Uses for the VBA Immediate Window > read all posts
Newsletter and a Free Gift
For me, the best way to learn is through practice and repetition. Excel is a giant application with a ton of features, and it takes time to learn.
I believe there will always be a demand from employers for someone with advanced Excel skills. And investing time in learning Excel and improving your skills will really help you grow in your career.
I recommend subscribing to my newsletter to get free weekly email updates that will help you on this journey. This will keep you immersed in learning Excel and staying up to date. I will also send you a free gift as a bonus.
The Journey Continues
No matter what your experience or skill level with Excel, there is still more to learn. I don't believe anyone has mastered it all. I'm not even sure if that's possible. Excel is like a blank canvas, just waiting for you to create something amazing.
I look forward to being a part of your journey and hopefully we can help each other out along the way.
Please feel free to contact me with questions or suggestions.
I hope you have a great day!