How to extract email addresses from an Excel sheet
How to create random numbers, text strings, dates and time values
How to generate random numbers and text
Working with classic ciphers in Excel
How to decode URL-encoded strings
Engineering functions – A to C
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
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
How to create random numbers, text strings, dates and time values
How to generate random numbers and text
How to create random numbers, text strings, dates and time values
How to generate random numbers and text
Working with classic ciphers in Excel
Rotating unique groups with no repeat
How to use the RANDBETWEEN function
How to create random numbers, text strings, dates and time values
How to generate a round-robin tournament
How to create random numbers, text strings, dates and time values
Working with classic ciphers in Excel
How to use the ROUNDUP 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