Create a dynamic named range
Automate net asset value (NAV) calculation on your stock portfolio
Tracking a stock portfolio in excel (auto update)
Create a dynamic named range
Compare the performance of your stock portfolio to S&P 500 using Excel
Lookup with any number of criteria
How to use Pivot Tables – Excel’s most powerful feature and also least known
List permutations with repetition and how many to choose from
How to generate a round-robin tournament
How to use the COUNTA function
List all named ranges and their cell references
Create a dynamic named range
Macro creates links to all sheets, tables, pivot tables and named ranges
Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
Create a dynamic named range
VLOOKUP in a filtered Excel Table and return multiple values
Working with classic ciphers in Excel
Extract the most repeated adjacent values in a column
Sort items by adjacent number in every other value
List all permutations with a condition
List permutations with repetition and how many to choose from
Rearrange values using formulas
How to remove unwanted characters in a cell
How to use the SEQUENCE function
How to decode URL-encoded strings
Date and Time Functions – A to M
Date and Time Functions – N to Z
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 function