Extract sample randomly in Excel
How to extract a sample of data random data? A combination of a random number and the function INDIRECT will return the result expected.
INDIRECT
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.
How to use the INDIRECT function of Excel?
The INDIRECT function provides you to create dynamique references by using the cells' contain as part of your references.
Update a Dropdown List automatically
Find out two techniques to create a dynamic dropdown list in Excel by using the power of the Excel Tables. 📌
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)
