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

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

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.

Expected Outcomes

  1. 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. Show more Show less Course content 13 sections • 181 lectures • 16h 18m total length Expand all sections Module 1: Introduction to Excel 1 lecture • 2min Module 1 Overview Preview 01:37 1.1 The What, Why, and How of Excel 1 lecture • 4min The What, Why, and How of Excel 04:25 1.2 Excel Components and User Interface 4 lectures • 16min 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 1.3 Introduction to Formulas and Functions 3 lectures • 23min 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 1.4 Overview of Cell References 1 lecture • 12min Understanding Cell References 12:02 Cell References 2 questions Module 2: Process and Transform Data 1 lecture • 3min Module 2 Overview Preview 02:44 2.1 Performing Data Aggregation 16 lectures • 1hr 46min 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 Multiple Criteria Conditional Aggregation: More on OR Testing Preview 08: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 2.2 Performing Logical Operations 8 lectures • 35min 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 2.3 Mastering Lookups and References 53 lectures • 5hr 15min Module 2.3 Overview Preview 02:41 Choose Function: An Overview and Simple Example Preview 03:35 Choose Function: Making Other Functions Dynamic Preview 08: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 2.4 Working with Informationals 12 lectures • 55min 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 3 more sections Instructor Jarrod Tanton Founder XLEssentials.com / CEO ReAppDev, Inc. 4.7 Instructor Rating 412 Reviews 3,245 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! Show more Show less Udemy 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 © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'678127d919b1f3eb',m:'3d790bf9f132df7165dfe7a98b8f6f148f455111-1627842816-1800-AZOlXGm54ihNcR15OoOaV0aeD7gilut18FojAfRgEayb9dpsphZ2xfATze0yovFcQwzceoTwbVEv4dEE0SBDRdstg/DP09E00vN+jSs89atT31c9Qavysfcg9PcKyYDi9jLCUCy+fWxsCtSm+LlXouo=',s:[0xc94c7cc647,0xf084f7124a],}})();
  2. 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. Show more Show less Course content 13 sections • 181 lectures • 16h 18m total length Expand all sections Module 1: Introduction to Excel 1 lecture • 2min Module 1 Overview Preview 01:37 1.1 The What, Why, and How of Excel 1 lecture • 4min The What, Why, and How of Excel 04:25 1.2 Excel Components and User Interface 4 lectures • 16min 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 1.3 Introduction to Formulas and Functions 3 lectures • 23min 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 1.4 Overview of Cell References 1 lecture • 12min Understanding Cell References 12:02 Cell References 2 questions Module 2: Process and Transform Data 1 lecture • 3min Module 2 Overview Preview 02:44 2.1 Performing Data Aggregation 16 lectures • 1hr 46min 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 Multiple Criteria Conditional Aggregation: More on OR Testing Preview 08: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 2.2 Performing Logical Operations 8 lectures • 35min 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 2.3 Mastering Lookups and References 53 lectures • 5hr 15min Module 2.3 Overview Preview 02:41 Choose Function: An Overview and Simple Example Preview 03:35 Choose Function: Making Other Functions Dynamic Preview 08: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 2.4 Working with Informationals 12 lectures • 55min 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 3 more sections Instructor Jarrod Tanton Founder XLEssentials.com / CEO ReAppDev, Inc. 4.7 Instructor Rating 412 Reviews 3,245 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! Show more Show less Udemy 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 © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'678127d919b1f3eb',m:'3d790bf9f132df7165dfe7a98b8f6f148f455111-1627842816-1800-AZOlXGm54ihNcR15OoOaV0aeD7gilut18FojAfRgEayb9dpsphZ2xfATze0yovFcQwzceoTwbVEv4dEE0SBDRdstg/DP09E00vN+jSs89atT31c9Qavysfcg9PcKyYDi9jLCUCy+fWxsCtSm+LlXouo=',s:[0xc94c7cc647,0xf084f7124a],}})();
  3. 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. Show more Show less Course content 13 sections • 181 lectures • 16h 18m total length Expand all sections Module 1: Introduction to Excel 1 lecture • 2min Module 1 Overview Preview 01:37 1.1 The What, Why, and How of Excel 1 lecture • 4min The What, Why, and How of Excel 04:25 1.2 Excel Components and User Interface 4 lectures • 16min 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 1.3 Introduction to Formulas and Functions 3 lectures • 23min 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 1.4 Overview of Cell References 1 lecture • 12min Understanding Cell References 12:02 Cell References 2 questions Module 2: Process and Transform Data 1 lecture • 3min Module 2 Overview Preview 02:44 2.1 Performing Data Aggregation 16 lectures • 1hr 46min 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 Multiple Criteria Conditional Aggregation: More on OR Testing Preview 08: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 2.2 Performing Logical Operations 8 lectures • 35min 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 2.3 Mastering Lookups and References 53 lectures • 5hr 15min Module 2.3 Overview Preview 02:41 Choose Function: An Overview and Simple Example Preview 03:35 Choose Function: Making Other Functions Dynamic Preview 08: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 2.4 Working with Informationals 12 lectures • 55min 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 3 more sections Instructor Jarrod Tanton Founder XLEssentials.com / CEO ReAppDev, Inc. 4.7 Instructor Rating 412 Reviews 3,245 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! Show more Show less Udemy 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 © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'678127d919b1f3eb',m:'3d790bf9f132df7165dfe7a98b8f6f148f455111-1627842816-1800-AZOlXGm54ihNcR15OoOaV0aeD7gilut18FojAfRgEayb9dpsphZ2xfATze0yovFcQwzceoTwbVEv4dEE0SBDRdstg/DP09E00vN+jSs89atT31c9Qavysfcg9PcKyYDi9jLCUCy+fWxsCtSm+LlXouo=',s:[0xc94c7cc647,0xf084f7124a],}})();
  4. 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. Show more Show less Course content 13 sections • 181 lectures • 16h 18m total length Expand all sections Module 1: Introduction to Excel 1 lecture • 2min Module 1 Overview Preview 01:37 1.1 The What, Why, and How of Excel 1 lecture • 4min The What, Why, and How of Excel 04:25 1.2 Excel Components and User Interface 4 lectures • 16min 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 1.3 Introduction to Formulas and Functions 3 lectures • 23min 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 1.4 Overview of Cell References 1 lecture • 12min Understanding Cell References 12:02 Cell References 2 questions Module 2: Process and Transform Data 1 lecture • 3min Module 2 Overview Preview 02:44 2.1 Performing Data Aggregation 16 lectures • 1hr 46min 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 Multiple Criteria Conditional Aggregation: More on OR Testing Preview 08: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 2.2 Performing Logical Operations 8 lectures • 35min 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 2.3 Mastering Lookups and References 53 lectures • 5hr 15min Module 2.3 Overview Preview 02:41 Choose Function: An Overview and Simple Example Preview 03:35 Choose Function: Making Other Functions Dynamic Preview 08: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 2.4 Working with Informationals 12 lectures • 55min 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 3 more sections Instructor Jarrod Tanton Founder XLEssentials.com / CEO ReAppDev, Inc. 4.7 Instructor Rating 412 Reviews 3,245 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! Show more Show less Udemy 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 © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'678127d919b1f3eb',m:'3d790bf9f132df7165dfe7a98b8f6f148f455111-1627842816-1800-AZOlXGm54ihNcR15OoOaV0aeD7gilut18FojAfRgEayb9dpsphZ2xfATze0yovFcQwzceoTwbVEv4dEE0SBDRdstg/DP09E00vN+jSs89atT31c9Qavysfcg9PcKyYDi9jLCUCy+fWxsCtSm+LlXouo=',s:[0xc94c7cc647,0xf084f7124a],}})();