Auto Refresh Power Query on Workbook Open
Discover how to enable power query refresh open in Excel and keep your data updated each time you open your workbook.
power query
Power Query Function to Remove Accents in Excel
Master Power Query to remove accents and ensure your text is clean for joins, searches, and URL slugs effortlessly.
Split Text on a Delimiter without Formula
Discover the easiest way to split text on a delimiter without using a formula. The Text to Columns tool does the job.
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)
Extract folder and subfolders with Excel
It's very easy to extract the hierarchy of a folder and subfolders with Excel. In just 5 steps the job is done.
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)
