Use the Excel XLOOKUP Function

The XLOOKUP function is an Office 365 function that is sure to replace the other lookup functions like VLOOKUP, INDEX/MATCH, or HLOOKUP. It's so much more versatile and take the similar argument structure as the other functions and more. You can do various lookup variations like looking up to the left or looking up values from a bottoms up approach...and all this with just one function.

Google Sheets - Track Stocks with GOOGLEFINANCE

If you like to track your stock investments, Google Sheets has a function called GOOGLEFINANCE that helps you get delayed (~20 minute) stock price (or volume) information on numerous stocks in your portfolio. It can event track mutual funds and currency. You also have the option of getting historical information on those various stocks so you can do some anaylsis or comparisons of your portfolio. In this video I'll show you how to use the many ways of GOOGLEFINANCE to get this information and even show you how to create a small in cell chart to visualize the stock prices from 30 days or even 365 days to the current date.

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.