Ryan Clark

As the Modern Workplace Architect at Mr. SharePoint, I help companies of all sizes better leverage Modern Workplace and Digital Process Automation investments. I am also a Microsoft Most Valuable Professional (MVP) for SharePoint and Microsoft 365.

A man with short curly hair and a beard is smiling. He is wearing a dark plaid suit jacket, a black shirt, and a dark tie. The background is softly blurred.
SharePoint Calculated Column in a List or Library [Tutorial]

SharePoint Calculated Column in a List or Library (Tutorial)

If you’re a long-time user of SharePoint, then you must have stumbled upon calculated columns in a list or document library. You must have seen it on some site and you’re probably wondering how to implement it to your as well. The cool thing here is that the steps you need to take are quite the same, whether you’re using the classic or modern experience of SharePoint. In this article, I’ll show you what a calculated column in SharePoint can do and how you can implement it yourself in only a few steps. Let’s get started! What do you need […]

SharePoint Calculated Column in a List or Library (Tutorial) Read More »

How to Create a Drop-Down List in Excel in 3 Easy Steps

How to Create a Drop-Down List in Excel in 3 Easy Steps

If you’re new to Excel, you may find it hard to implement a drop-down list in Excel simply because there’s no one-click button for that. In fact, some long-time users may still forget how to do it as the button involved isn’t that obvious. In this article, I will show you how to easily create a drop-down list in three easy steps. Step 1: Select a Cell The first step is simple — select the cell that you want to turn into a drop-down list. For example, let’s say we have this spreadsheet below and we want to turn cell

How to Create a Drop-Down List in Excel in 3 Easy Steps Read More »

SharePoint list limit

How to Resolve the SharePoint 5,000 Item List Limit Threshold

It is often a problem for SharePoint users when the number of their items in their library hits the 5,000-mark. If you have experienced this and you’re worried that you can’t access or find your files anymore, you have come to the right place. In this article, you will learn more about what exactly triggers this issue, how you can possibly prevent it in the future, and what you can do to fix it. Let’s get started! The Truth About the SharePoint 5,000 Item Limit Threshold A lot of people have the misconception that a SharePoint list or library can’t

How to Resolve the SharePoint 5,000 Item List Limit Threshold Read More »

SharePoint Classic vs Modern Experience [Comparison]

SharePoint Classic vs Modern Experience (Comparison)

SharePoint is a web-based collaborative platform from Microsoft that can be used to store and share content with others. Users can manage, collaborate, and access documents and other resources simultaneously. This platform has existed for two decades, but the modern experience was only introduced in 2016. Classic SharePoint is the legacy framework. A lot of organizations still use the old one, though because of the introduction of the new experience and Microsoft’s clear intention of focusing on it, a lot of people have been transforming old sites into modern equivalents. Modern SharePoint, on the other hand, visibly looks better and

SharePoint Classic vs Modern Experience (Comparison) Read More »

Exchange Hybrid Configuration Migration Wizard Tutorial

Exchange Hybrid Configuration Migration Wizard Tutorial

Because of the benefits of using Exchange Online (Office 365), numerous organizations have moved from an on-premises messaging environment. Reduced costs, enhanced management overhead, and easy management are enough to convince executives to switch. The problem is, the migration process is quite tedious and may be challenging for most people. In this article, let’s dive deeper into the exchange migration process and learn how to use the hybrid-configuration migration wizard. What is Office 365 Hybrid Migration? There are many options available that will allow you to move your Exchange environment to Office 365, including hybrid migration or tool-based migration. Office

Exchange Hybrid Configuration Migration Wizard Tutorial Read More »

Microsoft Entra Connect Installation: Azure AD Connect (Updated)

Microsoft Entra Connect Installation: Azure AD Connect (Updated)

Not sure how to install Microsoft Entra Connect? In this guide, I will walk you through installing Microsoft Entra Connect (previously Azure AD Connect). Let’s get started. What is Microsoft Entra Connect? Previously known as Azure AD Connect, this is used to synchronize on-premises directories with Microsoft Entra ID. This allows organizations to provide a unified login experience for users and bridge on-premises and cloud environments. Microsoft Entra Connect offers several core benefits: Microsoft Entra Connect also helps with compliance, as IT administrators can control and manage the identity data flow. The tool also provides scheduling options, so syncs can

Microsoft Entra Connect Installation: Azure AD Connect (Updated) Read More »

How to Create a SharePoint Modern Site With PnP Powershell

How to Create a SharePoint Modern Site With PnP Powershell

It has been a while since Microsoft released modern pages for SharePoint. Since most people still use the older, classic sites, not everyone knows how to create a SharePoint modern site using PnP PowerShell. Fortunately, it is not really that complicated. By following this tutorial, you can be done in only a few minutes. There is no need to worry about the code since all you have to do is copy and paste them. Let’s start! What is a modern site in SharePoint? As its name suggests, a modern site in SharePoint is a complete design overhaul of how classic

How to Create a SharePoint Modern Site With PnP Powershell Read More »

How to Attach an Email in Outlook to Another Email

How to Attach an Email in Outlook to Another Email

One of the basic problems that Outlook users face is how to attach an email in Outlook to another email. Everybody knows how to forward an email, but it seems that some are confused about how to attach another email to their message. Fortunately, doing that in Outlook is as simple as attaching an image. In fact, you can attach another email from another sender in an email in less than three seconds, in two different ways. Here is the first one: How to attach an email to another email? As you may know, there is a one-click solution to

How to Attach an Email in Outlook to Another Email Read More »

How to Disable OneDrive on Your Windows Computer (Updated)

How to Disable OneDrive on Your Windows Computer (Updated)

Not happy with how OneDrive keeps popping out? In this guide, I will show you how you can easily disable OneDrive from your Windows computer. Let’s get started. Unlink OneDrive from Microsoft Account Unlinking OneDrive is the easiest way to stop OneDrive without doing any drastic actions. 🙂 This action pauses syncing and keeps your files untouched so you can keep OneDrive installed if you want to use it later. Right-click on the OneDrive icon from your taskbar and click the gear icon then settings: A window will appear that contains the different settings available for OneDrive. Go to the

How to Disable OneDrive on Your Windows Computer (Updated) Read More »

SharePoint Migration Tool: How to Use the Mover Tool

SharePoint Migration Tool: How to Use the Mover Tool

There are three migration tools you can use with SharePoint, each has its own purpose. The first one, the so-called “migration manager”, enables you to copy on-premises files to Microsoft 365. The other one is to copy from the SharePoint server. One of the most recent additions to this is the Mover migration tool, which will enable you to copy content from other cloud services to Microsoft 365. If you need to migrate your files from Google Drive and Dropbox to SharePoint Online or Office 365, this is what you need to use. Let’s explore the Mover tool much further…

SharePoint Migration Tool: How to Use the Mover Tool Read More »

Scroll to Top