Skip to Content
Home
Course Library
finance
Microsoft Excel
Indirect Tax (GST)
relationship management
Customer Service
Emotional Intelligence
0
+1 555-555-5556
Sign in
Contact Us
0
Home
Course Library
+1 555-555-5556
Sign in
Contact Us
Lessons
Share
Exit Fullscreen
Back to course
Microsoft Excel: Advanced Excel and Formulas
Excel Formulas 101
Introduction Excel Formulas 101
Excel Formula Syntax
Writing Efficient Formulas with Fixed & Relative References
Common Excel Error Types
Formula Auditing Trace Precedents & Dependents
Formula Auditing Evaluate Formula & Error Checking PC Only
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 Operators 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
Conditional Aggregation with COUNTIFS, SUMIFS & AVERAGEIFS
Building a Basic Dashboard with COUNTIFS & SUMIFS
DEMO Counting Duplicates with COUNTIF & 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