Learn how to use Excel Power Query's extract and split column features to extract delimited strings into their components.

If you've never heard of Excel's Power Query feature, you're not alone. Here's how to get started using it and gain a huge productivity boost.

Excel macros are like mini-programs that perform repetitive tasks, saving you a lot of time and typing. Here's everything you need to know to start programming macros yourself.

Simplify your data transformation by skipping complex parsing expressions and instead using Flash Fill and Power Query in Microsoft Excel.

Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know.

An Excel Web Query allows you to retrieve the latest real-time data and insert it in your spreadsheet. However, Web Query does not refresh data in the table automatically.

With Power Query in Excel 365, you can do just that. This powerful tool allows you to merge files from a folder into a single dataset, automatically updating as new files are added.

Excel can send alerts based on spreadsheet data, but you'll need to write a macro to do it. We'll show you how.

I have a relatively simple Excel task (I hope). One workbook, two sheets (Sheet1 and Sheet2) Sheet 1 has a dropdown Data Validation list that has 30 options. The user will choose an option from ...