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
How to calculate the public holidays in Excel? This article will present many formulae to calculate those dates according to the year.
Categories
- Conditional (11)
- Conditional Formatting (18)
- Date (47)
- Dynamic Arrays (8)
- Excel Charts (11)
- Excel Online (4)
- Excel Tests (8)
- Excel Training (15)
- Excel Tutorial (15)
- Expert (30)
- Finance (5)
- Free Excel Tutorial for beginners (32)
- Function (2)
- Intermediate Excel Skills: Tutorials and Articles (24)
- Lookup functions (14)
- Manage data (22)
- Maps and GPS (4)
- Pivot Table (7)
- Power Query (5)
- Shortcuts (5)
- Statistical functions (23)
- Text functions (18)
- Tips and Tricks (23)
