Use the Power Query Data Type Customization

In the Microsoft Office subscription or Microsoft 365 version of Excel there's data types that let you get a lot more information from just one value in a cell. There is a stock data type that lets you view the latest information of that public company like the stock price or shares outstanding; and that is just based on the name of the company in one cell. Now you can actually create you own custom data type courtesy of Power Query. Think of it as a small table or list that you can expand from just one cell in your worksheet. You can have any time of structured table of related information and it all gets encapsulations in one column of multiple row cells. See the video to learn how this can be done.

Create a Clickable Image Map in SharePoint

https://youtu.be/7NwSdVNBYUA

In SharePoint classic pages, you were able to have a clickable image map similar to an ordinary web page. However with SharePoint modern pages, Microsoft seemed to have taken that ability away. There is actually a workaround for this using another popular Microsoft product - PowerPoint. You can create the hotspots with multiple links for each part of an image, upload this using the file viewer web part and bam(!) you have a pseudo image map along with the ability to mouseover and see the link without writing html.

Calculate a Binomial Distribution Probability in Excel

A binomial distribution is basically a type of distribution that has only two possible outcomes: Success or Failure. An example would be toss of a typical coin...you either get a heads or tails. If you choose heads , that would be your success and tail would be the failure. Now if we wanted to calculated the probability of success based on X number of tosses, there is actually a formula to calculate that probability. Excel makes it really easy, but I'll show four different ways to get this answer.