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 Lookup Column: How to Create One Easily

SharePoint Lookup Column: How to Create One Easily

If you have plenty of lists and libraries on one of your sites, then you may have wondered at some point if there was a way for you to show some columns from one list or library to another. With a lookup column, that’s certainly possible. In this article, I’ll show you how to easily create one on your SharePoint site. Note that although the use case for this feature is incredible, it comes with some limitations too. Let’s get started! What is a lookup column? The simplest explanation is that a lookup column is a special type of column […]

SharePoint Lookup Column: How to Create One Easily Read More »

Microsoft Office 365 vs GoDaddy Office 365 [Breakdown]

Microsoft Office 365 vs GoDaddy Office 365 (Breakdown)

GoDaddy and Microsoft formed a partnership in 2014. That led to the former creating its own offering of Microsoft 365 suite (they changed the name from Office 365 to reflect Microsoft’s recent change). Unfortunately, this offer, though significantly cheaper during the promotion period, has led to some problems for some of its users. In this article, you will learn the difference between GoDaddy Office 365 and of Microsoft Office 365. We will also discuss why plenty of people think of GoDaddy’s offer as a “trap”. Let’s get started. What is the GoDaddy Office 365 all about? Although GoDaddy has a

Microsoft Office 365 vs GoDaddy Office 365 (Breakdown) Read More »

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 »

Scroll to Top