Learn how to use the new Microsoft Excel REGEX functions to easily extract, clean and format data for easy data visualization and analysis ...

The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

Microsoft Excel’s Name box is a powerful tool for its size. Use it to move around, create range names and even enter functions.

How to Combine First & Last Name Columns in Excel. In previous versions of Excel, you had to combine first and last names using the Concatenate function, or its shortcut "&" method.

An Excel email address list should contain nothing but the addresses themselves. Yet if the spreadsheet received its data from an external form, the column may contain irrelevant text.

OutWit Hub is a cool FireFox addon that allows you to extract any web page information and export it to our favorite Excel for easier management and organization.

Planning to create a Disavow File for Google? Learn how to extract domain names from URLs using Excel - and then add 'domain:' in front of each.

Q. I receive Excel spreadsheets regularly that contain dates. I have to manually look up the day of the week that represents these dates. Are there any functions that can help speed this process along ...