Connecting SharePoint 2016/2019 and ADFS Server (Part 2)

In my previous article, I described an authentication method, where an ADFS Server is responsible for authenticating users. I also described which certificates are needed and how to properly export a certificate, so you can import it to you SharePoint Server. Read the rest

Calculating Running Total in Excel

Let’s say we have an Excel spreadsheet with sales data for different months of the year. We have information about the number of products we sold in each individual month. But in the next column, we would like to have a running total – a sum of all the products sold up to that month in a year. Read the rest

Connecting SharePoint 2016/2019 and ADFS Server (Part 1)


Many corporations are making the decision to open up their SharePoint Server to the outside world, to mobile users or for external collaboration with their partners. Because of security (and other) reasons, you don’t want to expose your SharePoint Server to the internet. Read the rest