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

Office 365 PowerShell – Part 5

In my previous articles I described how to use PowerShell to manage various Office 365 services. But we sometimes also need to plan our scripts to run on a schedule. In this scenario, a problem is encountered – how can we safely store passwords for administrative accounts and run scripts with the help of Task Scheduler. Read the rest

Office 365 PowerShell – Part 4

In my previous article I wrote about connecting to and managing Exchange Online. In this article, I will finally write about my specialty – SharePoint and SharePoint Online. As usual, SharePoint is a bit of a story of its own when it comes to Office and Server products. Read the rest

Custom CreatePublishingPageDialog in SharePoint? No problem!

Let’s imagine that we have multiple types of articles with multiple page layouts and we want to call Add a page dialog for each of them.

The problem is in SharePoint OOTB CreatePublishingPageDialog.aspx page which is called when you choose Add a page from Site Actions menu. Read the rest

Office 365 PowerShell – Part 3

In the previous article, we took a look at how we can use PowerShell to connect to Skype for Business Online. In this article, we will continue with connecting and managing other services in the Microsoft cloud. Namely, we will be talking about Exchange Online. Read the rest

Office 365 PowerShell – Part 2

In the previous article of this series, I described how to prepare our environment with all the necessary software needed to connect to Office 365. We installed the following software:

  • Microsoft Online Services Sign-In Assistant
  • Azure Active Directory Connect
  • Azure Active Directory PowerShell

After successfully installing, we connected to the cloud services using the following command:

Connect-MsolService -Credential (Get-Credential)

After that, we ran a few more commands to confirm that the PowerShell commands are being ran and executed. Read the rest

A Simple Way to Insert Bibliography in Word

Can you remember writing papers back in your student days? It probably wasn’t your favorite thing in the world to properly cite all of the sources you used in your paper. Perhaps you still have a need for this today, when you are writing scientific articles, doctoral dissertations etc. Read the rest