12 Advanced Excel Formulas

Welcome & New Functionality 4 lectures 08:51 Total the Visible Rows After Applying Filter by Selection Create an ad-hoc total at the top of your data set after using the Filter by Selection feature. Spearing Formula to Create a 3D Reference There is a lot of subtle content in this lecture. Randbetween, Faster AutoSum, CELL, TRIM, MID, and 3-D References. Referring to Geography Data Types The new geography and stock data types introduced in Office 365 introduce a new world of formulas. Learn how to use =A2.Population and similar formulas. Download the Excel Workbook Used in these Lectures If you would like to work along, download the zip file attached to this session. All of the worksheets are in the single Excel workbook so you can try anything on your computer. Check Your Understanding of Session 1 A short quiz to test your understanding of the first session. Welcome & New Functionality 4 lectures 08:51 Total the Visible Rows After Applying Filter by Selection Create an ad-hoc total at the top of your data set after using the Filter by Selection feature. Spearing Formula to Create a 3D Reference There is a lot of subtle content in this lecture. Randbetween, Faster AutoSum, CELL, TRIM, MID, and 3-D References. Referring to Geography Data Types The new geography and stock data types introduced in Office 365 introduce a new world of formulas. Learn how to use =A2.Population and similar formulas. Download the Excel Workbook Used in these Lectures If you would like to work along, download the zip file attached to this session. All of the worksheets are in the single Excel workbook so you can try anything on your computer. Check Your Understanding of Session 1 A short quiz to test your understanding of the first session. Total the Visible Rows After Applying Filter by Selection Create an ad-hoc total at the top of your data set after using the Filter by Selection feature. Total the Visible Rows After Applying Filter by Selection Create an ad-hoc total at the top of your data set after using the Filter by Selection feature. Total the Visible Rows After Applying Filter by Selection Create an ad-hoc total at the top of your data set after using the Filter by Selection feature. Total the Visible Rows After Applying Filter by Selection Create an ad-hoc total at the top of your data set after using the Filter by Selection feature. Create an ad-hoc total at the top of your data set after using the Filter by Selection feature. Create an ad-hoc total at the top of your data set after using the Filter by Selection feature. Spearing Formula to Create a 3D Reference There is a lot of subtle content in this lecture. Randbetween, Faster AutoSum, CELL, TRIM, MID, and 3-D References. Spearing Formula to Create a 3D Reference There is a lot of subtle content in this lecture. Randbetween, Faster AutoSum, CELL, TRIM, MID, and 3-D References. Spearing Formula to Create a 3D Reference There is a lot of subtle content in this lecture. Randbetween, Faster AutoSum, CELL, TRIM, MID, and 3-D References. Spearing Formula to Create a 3D Reference There is a lot of subtle content in this lecture. Randbetween, Faster AutoSum, CELL, TRIM, MID, and 3-D References. There is a lot of subtle content in this lecture. Randbetween, Faster AutoSum, CELL, TRIM, MID, and 3-D References. There is a lot of subtle content in this lecture. Randbetween, Faster AutoSum, CELL, TRIM, MID, and 3-D References. Referring to Geography Data Types The new geography and stock data types introduced in Office 365 introduce a new world of formulas. Learn how to use =A2.Population and similar formulas. Referring to Geography Data Types The new geography and stock data types introduced in Office 365 introduce a new world of formulas. Learn how to use =A2.Population and similar formulas. Referring to Geography Data Types The new geography and stock data types introduced in Office 365 introduce a new world of formulas. Learn how to use =A2.Population and similar formulas. Referring to Geography Data Types The new geography and stock data types introduced in Office 365 introduce a new world of formulas. Learn how to use =A2.Population and similar formulas. The new geography and stock data types introduced in Office 365 introduce a new world of formulas. Learn how to use =A2.Population and similar formulas. The new geography and stock data types introduced in Office 365 introduce a new world of formulas. Learn how to use =A2.Population and similar formulas. Download the Excel Workbook Used in these Lectures If you would like to work along, download the zip file attached to this session. All of the worksheets are in the single Excel workbook so you can try anything on your computer. Download the Excel Workbook Used in these Lectures If you would like to work along, download the zip file attached to this session. All of the worksheets are in the single Excel workbook so you can try anything on your computer. Download the Excel Workbook Used in these Lectures If you would like to work along, download the zip file attached to this session. All of the worksheets are in the single Excel workbook so you can try anything on your computer. Download the Excel Workbook Used in these Lectures If you would like to work along, download the zip file attached to this session. All of the worksheets are in the single Excel workbook so you can try anything on your computer. If you would like to work along, download the zip file attached to this session. All of the worksheets are in the single Excel workbook so you can try anything on your computer. If you would like to work along, download the zip file attached to this session. All of the worksheets are in the single Excel workbook so you can try anything on your computer. Check Your Understanding of Session 1 A short quiz to test your understanding of the first session. Check Your Understanding of Session 1 A short quiz to test your understanding of the first session. Check Your Understanding of Session 1 A short quiz to test your understanding of the first session. Check Your Understanding of Session 1 A short quiz to test your understanding of the first session. A short quiz to test your understanding of the first session. A short quiz to test your understanding of the first session. INDEX+MATCH and Other VLOOKUP Oddities 4 lectures 12:18 How to Build INDEX & MATCH with the Function Arguments Dialog The Function Arguments dialog is great when you have a formula with a single function. But what if you need to use INDEX with MATCH and MATCH? This lecture shows you how to change the Function Arguments on the fly. VLOOKUP Between Worksheets You have to build a VLOOKUP on Sheet1 that points to Sheet2. This lecture shows an alternative using Named Ranges and expanding tables. Using the "True" Version of VLOOKUP When would you ever use the =VLOOKUP(A2,Table,2,TRUE) version of VLOOKUP? This lecture walks through an example. Find the Last Value in a Column or Row This lecture shows a technique where you use the True version of VLOOKUP to find the last number in a column. Quiz for Session 2 One question to test your understanding of Session 2. INDEX+MATCH and Other VLOOKUP Oddities 4 lectures 12:18 How to Build INDEX & MATCH with the Function Arguments Dialog The Function Arguments dialog is great when you have a formula with a single function. But what if you need to use INDEX with MATCH and MATCH? This lecture shows you how to change the Function Arguments on the fly. VLOOKUP Between Worksheets You have to build a VLOOKUP on Sheet1 that points to Sheet2. This lecture shows an alternative using Named Ranges and expanding tables. Using the "True" Version of VLOOKUP When would you ever use the =VLOOKUP(A2,Table,2,TRUE) version of VLOOKUP? This lecture walks through an example. Find the Last Value in a Column or Row This lecture shows a technique where you use the True version of VLOOKUP to find the last number in a column. Quiz for Session 2 One question to test your understanding of Session 2. How to Build INDEX & MATCH with the Function Arguments Dialog The Function Arguments dialog is great when you have a formula with a single function. But what if you need to use INDEX with MATCH and MATCH? This lecture shows you how to change the Function Arguments on the fly. How to Build INDEX & MATCH with the Function Arguments Dialog The Function Arguments dialog is great when you have a formula with a single function. But what if you need to use INDEX with MATCH and MATCH? This lecture shows you how to change the Function Arguments on the fly. How to Build INDEX & MATCH with the Function Arguments Dialog The Function Arguments dialog is great when you have a formula with a single function. But what if you need to use INDEX with MATCH and MATCH? This lecture shows you how to change the Function Arguments on the fly. How to Build INDEX & MATCH with the Function Arguments Dialog The Function Arguments dialog is great when you have a formula with a single function. But what if you need to use INDEX with MATCH and MATCH? This lecture shows you how to change the Function Arguments on the fly. The Function Arguments dialog is great when you have a formula with a single function. But what if you need to use INDEX with MATCH and MATCH? This lecture shows you how to change the Function Arguments on the fly. The Function Arguments dialog is great when you have a formula with a single function. But what if you need to use INDEX with MATCH and MATCH? This lecture shows you how to change the Function Arguments on the fly. VLOOKUP Between Worksheets You have to build a VLOOKUP on Sheet1 that points to Sheet2. This lecture shows an alternative using Named Ranges and expanding tables. VLOOKUP Between Worksheets You have to build a VLOOKUP on Sheet1 that points to Sheet2. This lecture shows an alternative using Named Ranges and expanding tables. VLOOKUP Between Worksheets You have to build a VLOOKUP on Sheet1 that points to Sheet2. This lecture shows an alternative using Named Ranges and expanding tables. VLOOKUP Between Worksheets You have to build a VLOOKUP on Sheet1 that points to Sheet2. This lecture shows an alternative using Named Ranges and expanding tables. You have to build a VLOOKUP on Sheet1 that points to Sheet2. This lecture shows an alternative using Named Ranges and expanding tables. You have to build a VLOOKUP on Sheet1 that points to Sheet2. This lecture shows an alternative using Named Ranges and expanding tables. Using the "True" Version of VLOOKUP When would you ever use the =VLOOKUP(A2,Table,2,TRUE) version of VLOOKUP? This lecture walks through an example. Using the "True" Version of VLOOKUP When would you ever use the =VLOOKUP(A2,Table,2,TRUE) version of VLOOKUP? This lecture walks through an example. Using the "True" Version of VLOOKUP When would you ever use the =VLOOKUP(A2,Table,2,TRUE) version of VLOOKUP? This lecture walks through an example. Using the "True" Version of VLOOKUP When would you ever use the =VLOOKUP(A2,Table,2,TRUE) version of VLOOKUP? This lecture walks through an example. When would you ever use the =VLOOKUP(A2,Table,2,TRUE) version of VLOOKUP? This lecture walks through an example. When would you ever use the =VLOOKUP(A2,Table,2,TRUE) version of VLOOKUP? This lecture walks through an example. Find the Last Value in a Column or Row This lecture shows a technique where you use the True version of VLOOKUP to find the last number in a column. Find the Last Value in a Column or Row This lecture shows a technique where you use the True version of VLOOKUP to find the last number in a column. Find the Last Value in a Column or Row This lecture shows a technique where you use the True version of VLOOKUP to find the last number in a column. Find the Last Value in a Column or Row This lecture shows a technique where you use the True version of VLOOKUP to find the last number in a column. This lecture shows a technique where you use the True version of VLOOKUP to find the last number in a column. This lecture shows a technique where you use the True version of VLOOKUP to find the last number in a column. Quiz for Session 2 One question to test your understanding of Session 2. Quiz for Session 2 One question to test your understanding of Session 2. Quiz for Session 2 One question to test your understanding of Session 2. Quiz for Session 2 One question to test your understanding of Session 2. One question to test your understanding of Session 2. One question to test your understanding of Session 2. The Oddities: NetWorkDays, GetPivotData, Indirect, Offset, and Index. 4 lectures 22:40 How Many Workdays Between Two Dates? Dates in Excel are great. Learn how to successfully count the number of workdays between now and a project deadline