Create a Dynamic VLOOKUP function
Learn how to create a dynamic VLOOKUP with the MATCH function and customize your search criteria to return accurate results in Excel.
Dynamic function
How to Unstack Data using Excel?
Easily unstack data in Excel with this simple guide. Learn how to quickly rearrange your data for better analysis and visualization.
Dynamic SUM in Excel
Discover two powerful techniques for creating dynamic sums in Excel: Excel Tables and the SUM function with INDEX.
How to use the MATCH function in Excel?
The MATCH function returns the position of an item in a list. This function is very useful to create DYNAMIC dashboard and formulas
Categories
- Conditional (11)
- Conditional Formatting (18)
- Date (48)
- Dynamic Arrays (10)
- Excel Charts (11)
- Excel Online (4)
- Excel Tests (8)
- Excel Training (15)
- Excel Tutorial (15)
- Expert (26)
- Finance (7)
- Free Excel Tutorial for beginners (29)
- Function (1)
- Intermediate Excel Skills: Tutorials and Articles (20)
- Lookup functions (14)
- Manage data (20)
- Maps and GPS (5)
- Pivot Table (10)
- Power Query (5)
- Shortcuts (5)
- Statistical functions (23)
- Text functions (17)
- Tips and Tricks (21)
