Excel 2016 Advanced
Take Excel to the next level with advanced formulas, What-If Analysis tools, advanced PivotTables, Macros and much more.'
This course will teach students advanced concepts and formulas in
Microsoft Excel 2016. Students will learn functions such as SUMIF,
AVERAGEIF, and COUNTIF, advanced lookup functions such as HLOOKUP and
VLOOOKP and MATCH and INDEX, and complex logical and text functions.
Additionally, students will experiment with auditing formulas and error
checking, use the What-If Analysis tools, learn the options for
worksheet and workbook protection, review advanced use of PivotTables
and PowerPivot add-in, work with Macros, use form controls, and ensure
data integrity in their worksheets and workbooks. Students will also
learn about Excel's many collaboration features, as well as how to
import and export data to and from their workbooks.
Excel Introduction and Intermediate courses or equivalent experience.
Who is this course intended for?
Students who want to expand their Excel knowledge.
StartUsing VLOOKUP with TRUE to find an Approximate Match (3:40)
StartUsing HLOOKUP TRUE to find an Approximate Match (1:22)
StartUsing the Index Function- (3:08)
StartUsing the Match Function (2:14)
StartCreating a Combined Index and Match Formula (4:09)
StartComparing Two Lists with VLOOKUP (1:42)
StartComparing Two Lists with VLOOKUP and ISNA (3:47)