Create a Pivot Table without Using the Pivot Table Feature (SORT & UNIQUE)

Pivot Tables are one of those great data analysis tools. But what if you wanted a simple cross tab (aka pivot table) without using the Pivot Table command in the ribbon. You could have done this before with various combinations of commands and use the CTRL+SHIFT+ENTER to create arrays. But in Office 365 there are two dynamic array functions (SORT & UNIQUE) that let you create a cross tab very easily. The UNIQUE function in it self is totally useful and I'll cover it in detail near the end of the vid.

Split Comma Separated Value Ignore Comma In Brackets Excel (2 Excel Exam...

If you've tried to split or separate text string that's delimited by commas ( or semicolons) it's a straight forward process using the text to columns feature. However if you have some values that are enclosed in parenthesis or brackets and you don't want that text to be separated, it wouldn't work. There is a workaround that this video goes through. One is a VBA solutions provided from iliace at the mrexcel forum (https://www.mrexcel.com/board/threads...) and the other is an adjustment to the text with find/replace before using the text to column feature.

Filtering Tables on Multiple Criteria in Excel

To filter a range of data just got a bit more interesting with the new Dynamic Array functions in Office 365. This video will cover the FILTER function which is currently only available in O365 Excel, but I'll also give an alternative way to do range / table filtering if you don't have Microsoft Office 365.