-
Tables and Structured References 25
-
Introduction to table objectsLecture1.1
-
Converting a range into a tableLecture1.2
-
Inserting or deleting rows and columnsLecture1.3
-
Changing table stylesLecture1.4
-
Using the total rowLecture1.5
-
What is a structured reference?Lecture1.6
-
Elements in a structured referenceLecture1.7
-
Renaming a tableLecture1.8
-
Escaping special characters in a column identifierLecture1.9
-
Special identifiersLecture1.10
-
Syntax for referencing a table, column, or partLecture1.11
-
Syntax for referencing a part of a columnLecture1.12
-
Syntax for referencing a single cellLecture1.13
-
Syntax for referencing a column rangeLecture1.14
-
Syntax for referencing a part of a column rangeLecture1.15
-
Qualifying structured references – Part 1Lecture1.16
-
Qualifying structured references – Part 2Lecture1.17
-
Creating a calculated columnLecture1.18
-
Creating structured references using point-and-clickLecture1.19
-
Formula AutoCompleteLecture1.20
-
Structured references outside of the tableLecture1.21
-
Limitation with structured referencesLecture1.22
-
Copying vs filling structured referencesLecture1.23
-
Rearranging columns easilyLecture1.24
-
Converting a table to a normal rangeLecture1.25
-
-
Nested IF Functions (aka Nested IF Statements) 6
-
Nested IF Functions – Part 1Lecture2.1
-
Nested IF Functions – Part 2Lecture2.2
-
Nested IF Functions – Part 3Lecture2.3
-
Nested IF Functions – Part 4Lecture2.4
-
Nested IF Functions – Part 5Lecture2.5
-
Tip: Inserting line breaksLecture2.6
-
-
IFS Function 6
-
IFS Function – Part 1Lecture3.1
-
IFS Function – Part 2Lecture3.2
-
IFS Function – Part 3Lecture3.3
-
IFS Function – Part 4Lecture3.4
-
IFS Function – Part 5Lecture3.5
-
IFS Function – Part 6Lecture3.6
-
-
VLOOKUP and IFERROR Function 19
-
VLOOKUP Function – Part 1Lecture4.1
-
VLOOKUP Function – Part 2Lecture4.2
-
VLOOKUP Function – Part 3Lecture4.3
-
VLOOKUP Function – Part 4Lecture4.4
-
Boolean data type – Part 1Lecture4.5
-
Boolean data type – Part 2Lecture4.6
-
VLOOKUP Function – Part 5Lecture4.7
-
VLOOKUP Function – Part 6Lecture4.8
-
VLOOKUP Function – Part 7Lecture4.9
-
VLOOKUP Function – Part 8Lecture4.10
-
VLOOKUP Function – Part 9Lecture4.11
-
HLOOKUP FunctionLecture4.12
-
VLOOKUP Function – Part 10Lecture4.13
-
VLOOKUP Function – Part 11Lecture4.14
-
IFERROR Function – Part 1Lecture4.15
-
IFERROR Function Part 2Lecture4.16
-
VLOOKUP Function – Part 12Lecture4.17
-
VLOOKUP Function – Part 13Lecture4.18
-
VLOOKUP Function – Part 14Lecture4.19
-
-
INDEX MATCH Nested Function 7
-
Index Match Nested Function – Part 1Lecture5.1
-
Index Match Nested Function – Part 2Lecture5.2
-
Index Match Nested Function – Part 3Lecture5.3
-
Index Match Nested Function – Part 4Lecture5.4
-
Index Match Nested Function – Part 5Lecture5.5
-
Index Match Nested Function – Part 6Lecture5.6
-
Index Match Nested Function – Part 7Lecture5.7
-
-
Formula Auditing 10
-
Introduction to formula auditingLecture6.1
-
Tracing precedentsLecture6.2
-
More on tracing precedentsLecture6.3
-
Tracing dependentsLecture6.4
-
More on tracing dependentsLecture6.5
-
Evaluating formulas with F9Lecture6.6
-
More on evaluating formulas with F9Lecture6.7
-
Evaluating formulas with Evaluate FormulaLecture6.8
-
Error checking rulesLecture6.9
-
Error Smart Tag optionsLecture6.10
-
