Return Arrays with Excel’s LAMBDA Function
Master the Excel LAMBDA function to create array formulas effortlessly. Streamline your calculations and eliminate errors.
LAMBDA
Count Words in an Excel cell
Want to count words in Excel? Check out these two techniques using the TEXTSPLIT function and the COUNTA function.
Create your custom functions with LAMBDA
Discover how to create custom Excel functions using the LAMBDA function and named ranges in Microsoft 365.
Calculate Public holidays with Excel 📆
Discover how Excel can make it easy to calculate public holidays. Learn simple formulas to automate the process and never miss a holiday again.
Categories
- AI & Excel (1)
- Conditional (12)
- Conditional Formatting (18)
- Date (48)
- Dynamic Arrays (10)
- Excel Charts (11)
- Excel Online (4)
- Excel Tests (8)
- Excel Training (15)
- Excel Tutorial (16)
- Expert (26)
- Finance (7)
- Free Excel Tutorial for beginners (29)
- Function (1)
- Intermediate Excel Skills: Tutorials and Articles (19)
- Lookup functions (14)
- Manage data (18)
- Maps and GPS (5)
- Pivot Table (10)
- Power Query (6)
- Quiz Premium (7)
- Shortcuts (5)
- Statistical functions (25)
- Text functions (19)
- Tips and Tricks (21)
