Microsoft Excel: From Beginner to Formula Master

Transforms Students into Excel Wizards by Solving Practical Problems in Excel

   Watch Promo

The Excel Apprenticeship Series is focused on transforming students into Excel Wizards to give them a distinct competitive advantage over their peers. This installment of the series is about mastering the art and science of problem solving with formulas in Excel.

The course takes a unique approach that is rooted in solving real world problems. This gives students an apprenticeship experience as opposed to a traditional lecture approach. By the end of the course, students will have worked nearly 170 examples and will have learned how to leverage Excel to solve just about any problem they might face in practice. Students will cover just under 100 functions in the course and will be proficient in reading and writing even the most complex formulas in Excel.

The course is broken down into two modules. The first module provides an introduction to Excel. This module is intended to get everyone on the same page, so even those who have never used Excel can feel comfortable starting with this course.

The second module teaches students how to become formula masters and expert problem solvers with Excel. This module is broken down into seven sections that are mapped to functional areas, once again putting an emphasis on how Excel is used in the real world.

This course offers students:

  • Over 16 hours of valuable video instruction that is uniquely structured to share the lessons learned from over a decade of professional experience
  • Over 125 quiz questions strategically placed throughout the course to help test your understanding and reinforce what you’ve learned
  • A Practical Application Workbook and solution manual for each section
  • An Excel Wizard’s Guide to Critical Skills
  • A Comprehensive Data Aggregation Reference Sheet

This course is intended for individuals who have a desire to become phenomenal at writing formulas in Excel. This includes:

  • Recent or soon to be college graduates
  • Individuals who work in analyst, consulting, management, or supervisory roles
  • Individuals looking to gain a tangible skill on their resume
  • Individuals looking to gain a competitive advantage over their peers

Recent studies show it pays to know Excel. Get started today!

Who is the target audience?
  • This course is for individuals who have a desire to be phenomenal at writing formulas and problem solving in Microsoft Excel. The people that will benefit from this course the most are recent or soon to be college grads, individuals working in analyst, consulting, management, or supervisory roles, individuals looking to gain a tangible skill on their resume, or individuals who currently use Excel in their daily job and would like to better understand how they can leverage Excel to help them with their work.
  • This course is not for casual students who are looking to learn just the basics of Excel. Also, because this course focuses on how to process and transform data using Excel’s built-in functions in depth, it does not cover pivot tables or the visualization of data (charting). These topics are covered separately in their own course. If you already know how to use Excel’s reference functions, can write your own array formulas to aggregate data conditionally, and have plenty of experience working with strings, dates, and times, this course is probably not for you.
  • As a bonus, this course has an entire module that is dedicated to covering the Excel basics needed to get newbies up to speed so that they can benefit from this course as well.

Your Instructor

Jarrod Tanton
Jarrod Tanton

Hi, I’m Jarrod. I have over a decade of professional experience leveraging Microsoft Excel to solve practical business problems for companies of all sizes and I’m passionate about sharing what I’ve learned over the years with others.

I studied Industrial Engineering at Texas A&M University. After school, I worked as an Industrial Engineer at American Express, spent four years as a project manager at an engineering firm, and then spent three years as a Business Analytics consultant for IBM - where I worked on projects like the Deepwater Horizon oil spill in 2010, automating financial reporting capabilities for one of the world’s largest investment management companies, and partnering with a leading pharmaceutical company to help evaluate the state of the mental healthcare ecosystem.

I eventually left consulting to get more experience in operations management, which led me to spend two years in a finance management role at a large industrial supply company before I decided to launch my own companies - xLEssentials.com and ReAppDev, Inc.

While I worked in various industries and sectors over the past ten years, my knowledge of Microsoft Excel consistently gave me a competitive advantage over my peers and helped me advance my career.

A few years into my career, several of my coworkers made a comment about how they thought I was an “Excel Wizard”. That tag stuck with me ever since. In each of my roles, I became the go to person for transforming data sets into actionable information and for helping others with questions they had about Excel. I’ve taught countless coworkers and clients how to leverage Excel effectively and efficiently to solve their problems, as well as tips and tricks to save them hours of time. Now, I’d love the opportunity to share what I’ve learned over the years with you to give you the same advantage I have!

Class Curriculum

  Module 1: Introduction to Excel
Available in days
days after you enroll
  1.1 The What, Why, and How of Excel
Available in days
days after you enroll
  1.4 Overview of Cell References
Available in days
days after you enroll
  Module 2: Process and Transform Data
Available in days
days after you enroll
  2.3 Mastering Lookups and References
Available in days
days after you enroll
  2.5 Working with Dates and Times
Available in days
days after you enroll
  2.6 Working with Strings
Available in days
days after you enroll
  2.7 Working with Array Formulas
Available in days
days after you enroll

Frequently Asked Questions

When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.

Get started now!