-
Excel Formulas 101
-
Excel Formula Syntax
-
Writing Efficient Formulas with Fixed & Relative References
-
Common Excel Error Types
-
Formula Auditing Trace Precedents & Dependents
-
Navigating Excel Worksheets with Ctrl Shortcuts
-
Saving Time with Function Shortcuts
-
Accessing Tools with Alt Key Tips
-
PRO TIP Creating Drop Down Menus with Data Validation
-
Congrats, You're a Developer!
-
Conditional Statements & Logical Operators
-
Conditional Statements & Logical Operatars Introduction
-
Anatomy of the IF Statement
-
Nesting Multiple IF Statements
-
Adding Conditional ANDOR Operators
-
Using NOT & Conditionals
-
Fixing Errors with IFERROR
-
Common IS Statements
-
-
Common Excel Statistical Functions
-
Common Excel Statistical Functions Introduction
-
Basic Excel Statistical Functions
-
Extracting Values with SMALLLARGE & RANKPERCENTRANK
-
Randomization with RAND & RANDBETWEEN
-
Row Level Calculation with SUMPRODUCT
-
DEMO Calculating Shipping Costs with SUMPRODUCT
-
PRO TIP Data Profiling with COUNT & SUMPRODUCT
-
-
Lookup & Reference Functions
-
Lookup & Reference Functions Introduction
-
Working with Named Ranges
-
Counting Rows & Columns with ROWROWS & COLUMNCOLUMNS
-
Introduction to VLOOKUPHLOOKUP
-
Joining Data with VLOOKUP
-
Fixing Errors with IFERROR & VLOOKUP
-
VLOOKUP Reference Array Options
-
Approximate Match Lookups
-
Navigating Cell Ranges with INDEX
-
Matching Text & Values with MATCH
-
Combining INDEX & MATCH to Dynamically Search Ranges
-
Combining MATCH & VLOOKUP for More Flexible Lookups
-
TROUBLESHOOTING VLOOKUP with Duplicate Keys
-