TakeLessons Logo
877-310-1872
Derrick M.

Derrick M.

5(1)
Beginner
23:34
419
Views

Index Match***BETTER THAN VLOOKUP!!!***

Learn to use functions Index and Match together to form lookup function that is far more powerful than VLookup. This will be a deep dive into how this complex function truly operates.

Derrick's videos

Vlookup Explained
This video explains the Vlookup function in great detail. We will look at the syntax of Vlookup, key definitions and also perform several Vlookup examples using mock data.
Beginner
15:58
Nested If Statements
In this video you will learn about how to use Nested IF functions in Excel. This can be very powerful and convenient when you need to output something based on multiple criteria being true or false.
Intermediate
15:42
Learn Index Match
Learn to use functions Index and Match together to form lookup function that is far more powerful than VLookup. This will be a deep dive into how this complex function truly operates.
Beginner
23:34
VLookup Hack!!!
See how to return multiple columns of data with 1 vlookup formula. This hack makes VLookup function a bit more like XLookup.
Intermediate
00:36
Extremely Useful Excel Shortcuts Pt. 1
See how to navigate through your data quicker. See how to quickly determine your last row and last column and more. This is part 1 of a multi -part series.
Beginner
02:00
Excel Tables Explained
Tables in Excel are powerful! Learn the difference between using official Excel tables and regular formatted spreadsheets. You will learn how to create tables in Excel and what the advantages are to using tables. From auto-sizing, automatic named ranges, auto-formatting, auto-data population plus more.
Beginner
14:14
XLookup Explained!!!
Learn the basics behind what makes the Xlookup function work and what makes it so very helpful. In this video you will learn about the syntax for the Xlookup function and get to watch it in action as we cover 5 examples.
Beginner
09:28
Pivot Tables 101
If you need to know about Pivot Tables and how to create them, then this is a must watch video! We will cover the basics behind how to create pivot tables along with how to change elements of pivots as well as how to apply formatting to Pivot Tables. This will be a one stop shop for understanding Pivot Tables 101!
Beginner
24:34
***How To Use Countif, Sumif and Averageif***
Learn how and when to use three very important functions in Excel. We will take a look at how to use the countif, sumif and averageif functions. We take our time and discuss each function in detail including the syntax, then we use the functions in an example together.
Beginner
09:20
Lets Learn Countifs, Sumifs and Averageifs***Multiple Criteria***
In this video we will learn how to aggregate our data when we have multiple criteria that must be met. We will cover how to use Countifs, Averageifs and Sumifs with multiple examples. Please enjoy and thank you!
Beginner
13:02
Index Match***BETTER THAN VLOOKUP!!!***
Learn to use functions Index and Match together to form lookup function that is far more powerful than VLookup. This will be a deep dive into how this complex function truly operates.
Beginner
23:34
Cell References***Absolute; Dynamic and Mixed***
Learn about the 3 different cell references in Excel. See how formulas will react when they are dragged using the fill handle. We will discuss the different references and then do some examples where we use each reference type.
Beginner
13:11
Teacher Reviews (1)
5.0
1 Review
5Review Star
100%
4Review Star
0%
3Review Star
0%
2Review Star
0%
1Review Star
0%
Online

Quite patient. Very knowledgeable. Has a study plan ready for you, but if you have questions about a different part of Excel, he's happy to switch over for you. Would definitely recommend.

Posted Sep 19, 2021