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
Learn how to manipulate and transform your data effortlessly with Power Query. Find examples and tips to optimize your data analysis process.
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.
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)
Merge Multiple Excel files into one workbook
How to merge many Excel workbooks into a single one? This steby-step guide will explain you the technique with Excel and Power Query.
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.
Excel Split Date and Time
Discover how to separate date and time in Excel with ease. Use the INT and subtraction functions to extract the desired values.
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)
