Excel Guru: The Only Excel Formulas Course You'll Ever Need (Udemy.com)

Microsoft Excel: Master Excel Formulas by Solving 100s of Problems in Excel. Can Use Excel 2003 - Excel 2016 (Excel)

( 190 Reviews )

Created by: Jarrod Tanton

Produced in 2016

What you will learn

Become an Excel formula master who is proficient in reading and writing even the most complex formulas in Excel.
Understand the majority of Excel's built in functions and how to use them to efficiently solve a wide range of problems with Excel.
Creatively write formulas in Excel to address complex practical problems by combining Excel's functions together.
Save time by learning Excel tips, tricks, and traps to look out for as I share advice that I've acquired from using Excel over the years.

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 94 / 100

Course Description

This course is focused on transforming students into Excel Wizards to give them a distinct competitive advantage over their peers. It is centered on teaching students how to master 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 this course is for:

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.

Time: 16.5h

Instructor Details

Jarrod Tanton

4.7 Rating
190 Reviews

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 company. 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

Excel Basics (2017)

4.9 (15 Reviews)

Provider: YouTube
Time: 12h

Free

Microsoft Excel - Online Tutorial for Beginners (2010)

0.0 (0 Reviews)

Provider: Chandoo.org
Time: 1h 30m

Free

Excel Power Pivot and Power Query For Dummies

Excel Power Pivot and Power Query For Dummies (2016)

0.0 (0 Reviews)

Provider: Amazon

$14.53

More Courses

Reviews

4.7

190 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Alexander R Bustos on 9/14/2020

Already taken some quick tips away : )

By Siddharth Satpathy on 9/5/2020

This is probably the most comprehensive Excel Formulas tutorial out there. I don't think there is any single course which is comparable to this course. If you wish to master how to aggregate data, perform lookup functions and learn how to mix and match various functions to solve complex real world problems, then this is the right course for you.
I am a little surprised that Jarrod didn't include the sumproduct function in this as that would have pretty much made this a complete course. But that is a minor detail as overall this is a pretty amazing Excel course.
The only reason, I am not giving 5 stars is because the course hasn't been updated in a while. It would be really great if Jarrod could take some time to update this course and add some of the newer functions like the IFS function, MINIFS, MAXIFS, etc.

By Avishek Kumar on 8/22/2020

Loved the way you went through each details, no matter how small / insignificant it was.

By April Maxwell on 8/19/2020

Jarrod teaches this class phenomenally. I am at a beginner level at Excel and was a little apprehensive about taking the class with my lack of knowledge. The instructor provides practical scenarios and is very thorough in his delivery of the information. I have only progress 5% in the training but I am already feeling confident and learning a lot.

By Cheryl Small on 8/13/2020

I like the details, summaries to know what to view and links back to video when questions are answered incorrectly.
I would like to see an option to review the video when quiz questions are answered properly too.
There is a short segment in DBASE section that has no sound.

By Levi on 8/13/2020

Amazing course.

By Adriana Diaz on 7/22/2020

Clear, perfect pace. Love practical examples. Not too long

By Maryam on 7/22/2020

Still too basic for me. I want to learn formulas and therefore prefer going directly to formulas.

By Ryan Branagan on 6/15/2020

This has been an absolutely excellent course and has helped me remain productive during this lockdown. The course is often clear, surprisingly interesting and really goes into depth about Excel in a way that can only come from a real professional. The examples are always relevant to what you could encounter in the workplace and broken down very well for learning purposes, being very well set-out. I did not know that Excel had so many levels of functionality before this course and was often quite amazed about what this program that on face-value I had initially come to take for granted over the years could really do in the right hands. I feel much more confident using Excel now, not only because of my new gained skill/awareness but because I also have an excellent revision resource I can come back to at any time. Thank you for this wonderful course, Jarrod.

By Laurie Thelwell on 5/1/2020

Yes, learned a few thinks already!

By Vernea Jones on 5/1/2020

informative history of excel

By Leo Vakhman on 4/18/2020

The most phenomenal, detailed and most COMPLETE Excel course I have ever taken. Blown away at the level of detail and the amount of hours this course provides is mindblowing.