List all named ranges and their cell references
Find positive and negative amounts that net to zero
Filter unique distinct records using criteria
Macro creates links to all sheets, tables, pivot tables and named ranges
Perform thousands of conditions to a data set
Find smallest and largest unique number
Prevent duplicate records in a worksheet
Lookup with any number of criteria
How to use the Subtotal tool
Optimize pick path in a warehouse
How to use Pivot Tables – Excel’s most powerful feature and also least known
How to use the COMBIN function
How to filter using OR logic between columns [Advanced Filter]
How to filter using OR logic between columns [Formula]
How to delete empty rows – advanced filter
VLOOKUP in a filtered Excel Table and return multiple values
Count Conditionally Formatted cells
How to use the Subtotal tool
Filter duplicate values based on criteria
How to use the SUBTOTAL function
Function Reference Formulas Charts Conditional Formatting Excel Tables Pivot Tables VBA Knowledge Base Macros User Defined Functions Videos Advanced Excel CourseMost used functions
COUNTIF function INDEX function IF function SUM function SUMIFS function SUMPRODUCT function VLOOKUP functionFormula categories
Count Dates Extract Index and Match Logic Lookups String manipulation Sum Time Vlookup