Excel Guru: The Only Excel Formulas Course You’ll Ever Need
- 16.5 hours on-demand video
- 18 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- 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.
- 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.
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!
- 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.
Get more practice using the averageifs function to aggregate data on multiple conditions when all criteria need to be true ("and testing"). We'll see how the multiple criteria conditional aggregation functions can be used on both vertical and horizontal data sets.
Work an additional problem where you get to use array formulas to perform OR testing on a single range. Then expand your OR testing capabilities by learning how to perform OR testing on criteria that applies to more than one row or column.
Get an overview of the material covered in Module 2.3 - Mastering Lookups and References. The workbooks used in this module are attached as resources.
Get an overview of the choose function and understand what makes it unique among its lookup counterparts.
Learn how to leverage the choose function to provide range inputs to other functions dynamically based on a user input. As a bonus, learn another method (combo box) to create a drop down menu in Excel and learn why this style of drop down complements the choose function so well.
Learn how the choose function handles decimal values and how to use that knowledge to transform quantitative values into qualitative ones. Also, learn how the choose function can be used to build dynamic tools by allowing users to select a calculation to perform.
Learn some very important concepts about the vlookup function by working a simple example. Here you will learn why its important to lock down the range for the table you are searching, what causes the vlookup function to return the value not found and reference errors, some common reasons why those errors can be misleading, and what happens when the table you are searching contains duplicate values.
Learn how to build a tool that enables you to lookup information from a table that contains duplicates and return the requested information for each occurrence by combining the index, row, and small functions together in an array formula.
We'll continue building a tool that helps manage the enrollment and scheduling for a series of training events. Learn how to combine the index, match, row, and small functions together in an array formula to lookup information from a table that contains duplicates and return the requested data for each occurrence that meets the lookup criteria.
Get an overview of the istext, isnontext, isnumber, and isblank functions, learn how they handle different types of cell values, and understand how formatting changes impact these functions. Also, learn a trick for using relative references when the ranges you are referencing need to move in a transposed direction.
Learn how the cell function works when a reference is not specified and learn how to use the info function to return information about the Excel environment. Also, understand the importance of recognizing that you have many options available when designing solutions in Excel and that it's your job as an Excel Wizard to evaluate the pros and cons of each option before selecting an implementation.