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.

Use the LET Function in Excel

If you familiar with programming or VBA you'll love the LET function. It basically lets you define a name with a cell, assign it a value and perform calculations with that name. It might be overkill with basic functions, but when you've got more complicated formula that call on the same range or set data ranges, the LET functions makes it more efficient to execute and easier to read and troubleshoot. It's only available on Microsoft 365 version, so if you got that version check out this video to get an introduction to the LET function.