Unique distinct/condition
Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
Filter unique distinct records
Improve your VLOOKUP formula and return multiple values
Partial match for multiple strings – AND logic
How to rank text uniquely without duplicates
Create a list of duplicates where adjacent cell value meets a condition
Identify missing three character alpha code numbers
Automate net asset value (NAV) calculation on your stock portfolio
Tracking a stock portfolio in excel (auto update)
Perform thousands of conditions to a data set
Compare the performance of your stock portfolio to S&P 500 using Excel
Find smallest and largest unique number
Convert array formula to a regular formula
How to use the COUNTIF function
Lookup with any number of criteria
Rotating unique groups with no repeat
Filter duplicate values based on criteria
Unique distinct/condition
Distribute values across numerical ranges
How to remove unwanted characters in a cell
Extract a unique distinct list across multiple columns and rows sorted based on frequency
Date and Time Functions – N to Z
Filter unique distinct records
Create a list of duplicates where adjacent cell value meets a condition
Filter unique distinct records using criteria
Extract unique distinct values from a relational table
Working with three relational tables
Lookup using multiple conditions
How to use the COUNTIFS function
Prevent duplicate records in a worksheet
How to group items by quarter using formulas
Search for a sequence of values
Search for a sequence of cells based on wildcard search
Unique distinct/condition
Match two columns and return another value on the same row
Extract unique distinct records from two data sets
Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
Filter unique distinct records
How to extract email addresses from an Excel sheet
Partial match for multiple strings – AND logic
VLOOKUP in a filtered Excel Table and return multiple values
Search for a sequence of values
Search for a sequence of cells based on wildcard search
Filter duplicate values based on criteria
Unique distinct/condition
How to use the FILTER function
Extract a unique distinct list across multiple columns and rows sorted based on frequency
Date and Time Functions – A to M
Date and Time Functions – N to Z
Engineering functions – A to C
Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
How to use the FREQUENCY function
Extract the most repeated adjacent values in a column
Unique distinct/condition
Find the smallest number in a list that is larger than a given number
Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
Filter unique distinct records
How to extract email addresses from an Excel sheet
Improve your VLOOKUP formula and return multiple values
How to identify two consecutive dates in a list
Partial match for multiple strings – AND logic
Identify missing three character alpha code numbers
Automate net asset value (NAV) calculation on your stock portfolio
Case sensitive lookup and return multiple values
Tracking a stock portfolio in excel (auto update)
VLOOKUP in a filtered Excel Table and return multiple values
Find entry based on conditions
How to create random numbers, text strings, dates and time values
Add buy and sell points to a stock chart
Plot signals based on 2 mov avg
Extract unique distinct values from a relational table
Working with three relational tables
Highlight lookups in relational tables
Locate lookup values in an Excel table [HYPERLINK]
Compare the performance of your stock portfolio to S&P 500 using Excel
Find smallest and largest unique number
Convert array formula to a regular formula
Create a hyperlink linked to the result of a two-dimensional lookup
Practice basic arithmetic calculations in Excel
Lookup with any number of criteria
Working with classic ciphers in Excel
How to group items by quarter using formulas
Search for a sequence of values
Search for a sequence of cells based on wildcard search
Extract the most repeated adjacent values in a column
How to color chart bars based on their values
Find and return the highest number and corresponding date based on a condition
Follow stock market trends – Moving Average
Follow stock market trends – trailing stop
Multiply numbers in each row by entire cell range
How to calculate and plot pivots on an Excel chart
Rotating unique groups with no repeat
Partial match and return value with highest level
Filter duplicate values based on criteria
Unique distinct/condition
Distribute values across numerical ranges
Two-dimensional lookup using two tables
How to use nested IF functions
How to remove unwanted characters in a cell
How to decode URL-encoded strings
How to track sector performance in the stock market – Excel template
Date and Time Functions – A to M
Date and Time Functions – N to Z
Financial functions – PMT to RATE
Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
Improve your VLOOKUP formula and return multiple values
Partial match for multiple strings – AND logic
Identify missing three character alpha code numbers
Case sensitive lookup and return multiple values
VLOOKUP in a filtered Excel Table and return multiple values
Search for a sequence of values
Extract the most repeated adjacent values in a column
Follow stock market trends – Moving Average
Multiply numbers in each row by entire cell range
Filter duplicate values based on criteria
Unique distinct/condition
Rearrange values using formulas
How to decode URL-encoded strings
How to use the MAKEARRAY function
Date and Time Functions – A to M
Date and Time Functions – N to Z
Engineering functions – D to IMC
Find positive and negative amounts that net to zero
Automate net asset value (NAV) calculation on your stock portfolio
Find entry based on conditions
Working with three relational tables
Lookup with any number of criteria
Working with classic ciphers in Excel
List all permutations with a condition
Rotating unique groups with no repeat
Unique distinct/condition
How to use the asterisk character
Financial functions – PMT to RATE
Filter unique distinct records
Working with classic ciphers in Excel
Unique distinct/condition
Distribute values across numerical ranges
How to use the UNIQUE function
Extract a unique distinct list across multiple columns and rows sorted based on frequency
Engineering functions – A to C
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