Convert Numbers to Roman Numerals

Converting numbers to Roman numeral is quite easy with the ROMAN function. But I'll spice this up with some other tricks to get a series of numbers. If you have Office 365, you can use the SEQUENCE function to get a matrix of numbers in a 10x10 grid. If you don't have Microsoft Office 365, I'll so another method to get this matrix. Also if you're interested in how to convert from Roman numerals to number, it's also just as easy with the ARABIC function.

Lookup Values from Different Workbook with IMPORTRANGE() - Google Sheets

Lookups in Google Sheets are fairly easy with the standard functions like LOOKUP, VLOOKUP or INDEX / MATCH. Within the same worksheet or different worksheet in the same workbook is straight forward. However if your looked up table or range is in a different workbook in Google Sheets, it take an additional function (IMPORTRANGE) to work. It's not so bad, so check out this video to see how it could work.

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.