Microsoft Excel 2016 Advanced Level 1

So you think you know Excel? Challenge yourself by taking this advanced course with our master trainer and Excel guru, Lana. You’ll learn all about tables and structured references, formula auditing, and how to perform conditional/logical analyses using nested IF statements, and the famous IFS function, VLOOKUP function, and INDEX MATCH nested function. These are all important topics to learn if you want to become truly amazing at Excel!
Course Features
- Lectures 73
- Quizzes 0
- Duration 73 video lessons
- Skill level All levels
- Language English
- Students 5360
- Assessments Yes
-
Tables and Structured References
- Introduction to table objects
- Converting a range into a table
- Inserting or deleting rows and columns
- Changing table styles
- Using the total row
- What is a structured reference?
- Elements in a structured reference
- Renaming a table
- Escaping special characters in a column identifier
- Special identifiers
- Syntax for referencing a table, column, or part
- Syntax for referencing a part of a column
- Syntax for referencing a single cell
- Syntax for referencing a column range
- Syntax for referencing a part of a column range
- Qualifying structured references – Part 1
- Qualifying structured references – Part 2
- Creating a calculated column
- Creating structured references using point-and-click
- Formula AutoComplete
- Structured references outside of the table
- Limitation with structured references
- Copying vs filling structured references
- Rearranging columns easily
- Converting a table to a normal range
-
Nested IF Functions (aka Nested IF Statements)
-
IFS Function
-
VLOOKUP and IFERROR Function
- VLOOKUP Function – Part 1
- VLOOKUP Function – Part 2
- VLOOKUP Function – Part 3
- VLOOKUP Function – Part 4
- Boolean data type – Part 1
- Boolean data type – Part 2
- VLOOKUP Function – Part 5
- VLOOKUP Function – Part 6
- VLOOKUP Function – Part 7
- VLOOKUP Function – Part 8
- VLOOKUP Function – Part 9
- HLOOKUP Function
- VLOOKUP Function – Part 10
- VLOOKUP Function – Part 11
- IFERROR Function – Part 1
- IFERROR Function Part 2
- VLOOKUP Function – Part 12
- VLOOKUP Function – Part 13
- VLOOKUP Function – Part 14
-
INDEX MATCH Nested Function
-
Formula Auditing