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
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)
