MS Excel: Nested Functions and Array Formulas Workshop

Master the art of combining several functions into one Excel formula

Surely, you have seen spreadsheets that contain these long and complex formulas which sometimes seem impossible to read and understand. Have you ever wished you were able to write such formulas yourself so that you can increase your productivity in Excel and impress your colleagues? In such case, this course is exactly for you.

What you’ll learn

  • Learn more than 50 functions in Excel by solving real-world examples.
  • Learn how to combine several functions into one single formula.
  • Learn Excel 365 ‘s new dynamic arrays functions (XLOOKUP, XMATCH, FILTER, SORT, UNIQUE, LET, RANDARRAY).
  • Learn different data manipulation and calculation techniques in Excel.

Course Content

  • Text Functions –> 22 lectures • 3hr 8min.
  • Logical Functions –> 5 lectures • 31min.
  • Statistical Functions –> 7 lectures • 42min.
  • Array Formulas –> 9 lectures • 1hr 20min.
  • Lookup Functions –> 7 lectures • 58min.
  • Generating Random Data –> 2 lectures • 9min.
  • Conclusion –> 1 lecture • 1min.

MS Excel: Nested Functions and Array Formulas Workshop

Requirements

  • Modern version of Microsoft Excel.

Surely, you have seen spreadsheets that contain these long and complex formulas which sometimes seem impossible to read and understand. Have you ever wished you were able to write such formulas yourself so that you can increase your productivity in Excel and impress your colleagues? In such case, this course is exactly for you.

In this course, we are going to review more than 50 Excel functions, but we will not simply learn how to use single functions here and there. Being able to apply single functions isn’t very helpful as in practice, unless you have to sum a range of cells, in most cases you will have to use several functions to achieve the desired results. Instead, we will focus on combining functions and formulas which will otherwise require helper cells, ranges or columns.

We will also review many array formulas examples which will bring you closer to be a real “super-user” in Excel.

We will also look at some of Excel 365’s dynamic array functions – XLOOKUP, XMATCH, FILTER, SORT, UNIQUE, RANDARRAY, LET.

What will NOT be covered in this course:

· Pivot tables

· Charts and visualizations

· Power Query

· VBA programming (we will review only a few examples…)

Get Tutorial