Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Personal Transformation Life Purpose Meditation CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Online Business Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Office Productivity Microsoft Excel Formulas and Functions

Excel Guru: The Only Excel Formulas Course You’ll Ever Need

Microsoft Excel: Master Excel Formulas by Solving 100s of Problems in Excel. Can Use Excel 2003 - Excel 2016 (Excel)
Rating: 4.7 out of 54.7 (398 ratings)
3,206 students
Created by Jarrod Tanton
Last updated 5/2016
English
English [Auto]
30-Day Money-Back Guarantee

What you'll 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.

Requirements

  • Students will need to have access to Microsoft Excel. The course is taught in Excel 2010. For the best experience students should have Excel 2010 or later. However, many of the concepts taught in this course are related to the core functions in Excel, which have not changed much since Excel 2003. Therefore, if you only have access to Excel 2003, you will still be able to follow along and will get quite a bit of value from the 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.

Course content

13 sections • 181 lectures • 16h 18m total length

  • Preview01:37

  • The What, Why, and How of Excel
    04:25

  • Excel Components and File Extensions
    02:36
  • Excel's User Interface: The Ribbon
    04:55
  • Excel's User Interface: Quick Access and Formula Toolbars
    04:06
  • Excel's User Interface: The Worksheet
    03:58

  • Introduction to Formulas and Functions
    02:57
  • Formulas and Functions
    4 questions
  • Order of Operations and Formulas
    06:48
  • Using Excel's Built in Functions
    13:18

  • Understanding Cell References
    12:02
  • Cell References
    2 questions

  • Preview02:44

  • Module 2.1 Overview
    01:34
  • Simple Aggregation Functions
    12:00
  • Simple Aggregation Functions
    4 questions
  • Single Criteria Conditional Aggregation: Static Criteria
    08:13
  • Single Criteria Conditional Aggregation: Dynamic Criteria
    08:59
  • Single Criteria Conditional Aggregation: >, <, and <> Conditions
    10:18
  • Single Criteria Conditional Aggregation: Combining Aggregations
    03:39
  • Single Criteria Conditional Aggregation Functions
    12 questions
  • Multiple Criteria Conditional Aggregation
    10:11
  • Multiple Criteria Conditional Aggregation: AND Testing
    04:40
  • Multiple Criteria Conditional Aggregation: OR Testing
    04:13
  • Multiple Criteria Conditional Aggregation: Using Arrays for OR Testing
    06:42
  • Preview08:17
  • Multiple Criteria Conditional Aggregation Functions
    5 questions
  • Bonus: Using Array Multiplication to Aggregate Data from Many Columns
    05:03
  • Database Aggregation Functions: Overview
    03:39
  • Database Aggregation Functions: Building a Reporting Tool
    10:03
  • Database Aggregations: Advanced Searches
    05:30
  • Database Aggregation Functions
    4 questions
  • Performing Data Aggregation: Wrap Up
    03:05

  • Module 2.2 Overview
    01:17
  • Logical Operators
    08:11
  • Conditional Functions Overview
    03:41
  • More on Conditional Functions: The If Function
    07:44
  • Handling more than two Outcomes: Nesting If Functions
    06:29
  • Simple Error Handling with the Iferror Function
    02:52
  • Logical Value Functions: True, False, and Not
    03:02
  • Logical Operations
    5 questions
  • Performing Logical Operations: Wrap Up
    01:42

  • Preview02:41
  • Preview03:35
  • Preview08:54
  • Choose Function: Transforming Quality Scores and Selecting a Forecast Model
    07:00
  • Choose Function: Nesting Functions Inside Choose
    05:42
  • The Choose Function
    4 questions
  • Vlookup and Hlookup: An Overview
    03:41
  • Vlookup: Key Concepts
    10:09
  • Vlookup: Adding Meaning to Classifications
    06:30
  • Vlookup: Making it Unique
    06:50
  • Vlookup: Understanding Approximate Match
    05:26
  • Vlookup: A Federal Income Tax Calculator
    08:07
  • Vlookup: Searching Multiple Tables
    02:53
  • Hlookup: More of the Same, Kind of
    06:39
  • The Vlookup and Hlookup Functions
    6 questions
  • Index and Match: An Overview
    03:31
  • Match: Finding the Position
    04:16
  • Match: Understanding the Approximate Match
    05:56
  • Index: A Special Case with 1D Arrays
    06:39
  • Index: Getting Values from a Table
    05:20
  • Index: Getting Values from Multiple Tables
    03:01
  • Index: Returning a Reference Instead of a Value
    06:29
  • The Index and Match Functions
    10 questions
  • Index and Match: Benefits of Index / Match Lookup
    04:44
  • Index and Match: Left lookups and Reference Stability
    06:41
  • Index and Match: Building a Dynamic Order Report
    08:46
  • Index and Match: Mastering the Approximate Lookup
    04:06
  • Index and Match: Putting the Approximate Match to Use
    06:59
  • Index and Match: The Power of Offsetting Lookups
    04:07
  • Index and Match: Searching Multiple Tables - Revisited
    07:50
  • Index and Match: Finding the First Occurrence
    05:22
  • Index and Match: Returning the Entire Row or Column
    06:21
  • Combining the Index and Match Functions
    5 questions
  • Defined Names: Overview and Simple Example
    07:30
  • Defined Names: More than Constants - Storing Ranges and Calculations
    05:50
  • Defined Names
    4 questions
  • Offset: Understanding the Offset Function
    06:19
  • Offset: Creating a Dynamic Dropdown List
    08:23
  • Offset: Creating a Dynamic Calculation
    04:19
  • Offset: Another Dynamic Calculation
    05:34
  • Offset: Dynamic Charting
    05:13
  • The Offset Function
    3 questions
  • Row and Column: An Overview
    05:27
  • Row and Column: Finding the Last Row and Automatic Numbering
    05:45
  • Rows and Columns: An Overview
    03:47
  • Rows and Columns: Cleaning Up Bad Data
    03:51
  • Row, Column, Rows, and Columns
    3 questions
  • Lookups, References, and Arrays: Returning More than the First Occurrence
    13:09
  • Lookups, References, and Arrays: Managing Schedules - Part 1
    07:35
  • Lookups, References, and Arrays: Managing Schedules - Part 2
    10:52
  • Lookups, References, and Arrays: Managing Schedules - Part 3
    06:14
  • Lookups, References, and Arrays: Searching Data to Return Records
    14:24
  • Address: An Overview
    04:26
  • Address: Finding the Last Cell of A Dynamic List
    02:54
  • Address: Getting Data From Templated Worksheets Quickly
    05:38
  • Transpose: An Overview
    04:09
  • Transpose: Transposing Data Inside Array Formulas
    04:17
  • Hyperlink: An Overview
    02:42
  • Hyperlink: Workbook and File Navigation
    07:13
  • Address, Transpose, and Hyperlink Functions
    3 questions
  • Mastering Lookups and References: Wrap up
    01:27

  • Module 2.4 Overview
    01:31
  • Value Testers: An Overview
    08:28
  • Value Testers: Special Treatment for Blanks
    06:00
  • Value Testers: Conditionally Controlling Action Based on Input Data Type
    04:48
  • Error Testers: An Overview
    03:19
  • Error Testers: Enhancing Lookup Functions
    07:38
  • Error Testers: Preventing Errors from Bubbling Up
    04:44
  • Core Informationals: An Overview
    06:07
  • Core Informationals: Formatting Details and File Names
    04:20
  • Core Informationals: Last Active Cell and Environment Information
    03:26
  • Core Informationals: The Type Function
    02:55
  • Informationals
    3 questions
  • Working with Informationals: Wrap Up
    01:17

Instructor

Jarrod Tanton
Founder XLEssentials.com / CEO ReAppDev, Inc.
Jarrod Tanton
  • 4.7 Instructor Rating
  • 398 Reviews
  • 3,206 Students
  • 1 Course

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 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!

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.