Convert Binary Number to Decimal in Excel
Learn how to convert binary numbers to decimals in Excel using the BIN2DEC function or a custom function when there are more than 10 digits.
Custom function
DATEDIFF for POWER QUERY
This article gives you the M Code for Power Query to return the result of the DATEDIFF function (difference between 2 dates)
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
- 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)
