It’s easy to change the color scheme of your modern SharePoint intranet site, as long as you have the correct permissions. In this very short tutorial, I’ll show you how!
While on your SharePoint intranet site, click the cogwheel in the top-right corner.
As long as you have the correct permissions and your company hasn’t locked down a colour scheme for your intranet sites, you will see this option here called “Change the look”. Click on that one, then go to “Theme”.
Just click the colour combination you like. Let’s try this one.
You’ll see a preview here, and then you just hit “Save” to update your site with the new theme. If you don’t like any of the themes, you can customise them. Click on a theme – that one looks ok – and then hit “Customize”. All you need to do here is to select the main colour and accent colour you want for your site.
Finally, remember to hit “Save” to apply the changes.
You can get a YouTube vanity URL or – in other words – a custom channel address once your channel hits 100 subscribers. In this video I celebrate hitting 100 subscribers on this channel and show you how to set up your own channel with a vanity URL. It’s easy, I promise!
Heads up! We may earn a commission for any products or services purchased via links in this post. The money we make through these links helps keep the lights on and the wheels turning. Thanks for supporting us!
How to get a custom YouTube vanity URL
Here’s how to get your very own YouTube channel address! That’s the kind of YouTube address that a normal human can read and remember. Like the one for my channel – https://youtube.com/pixamoo.
Time required3 minutes
Meet YouTube vanity URL criteria
To be eligible for a YouTube vanity URL, your channel must be at least 30 days old and have at least 100 subscribers. In addition, you must have uploaded a profile picture and a banner picture.
Once you’re eligible to get your very own channel URL, the option to “Set a custom URL for your channel” becomes available.
It takes a couple of days from when you hit a 100 subscribers until that option shows up. So if it’s not there yet, just wait a little.
In the left hand menu, click through to CUSTOMISE YOUR CHANNEL.
This is where you change the look and feel of your channel, like which videos appear on your channel home page.
Skipping across to branding you can set up your channel logo and banner. But not your channel URL. That one lives under BASIC INFO.
Choose your vanity URL
YouTube will give you a vanity URL based on your channel name. If an address is available, which matches your channel name perfectly, that’s the address YouTube will give you. Otherwise, it’ll add some characters to the URL, so that it’s definitely unique.
If you want to make a custom URL, you can do that too. You’re still stuck with your channel name as part of the URL, but you can add more letters and numbers after it. No spaces or special characters though.
Publish and confirm your new YouTube channel URL
Once you’re ready to lock in that new channel URL, just head up to the top right corner and smash the PUBLISH button.
YouTube will quickly check that you’re happy with the URL, and once you hit CONFIRM, the new channel address is locked in.
Need a website to go with your awesome new YouTube channel?
There’s been so many times in the past where I’ve needed to rank numbers in Excel from one to whatever based on size, weight, height, score, duration or any other number of factors.
I must have been living under a rock, because it was only yesterday that I realised Excel can rank stuff for you with two really simple formulae: =RANK.EQ() and =RANK.AVG().
I don’t know why I never thought to look into it… It randomly came up in an email newsletter called the Morning Brew, which I subscribe to. That newsletter has nothing to do with Excel, but there you go.
Anyways, here’s a tech tutorial showing you how to rank stuff in Excel!
First you’ll need a list of things to rank. We’re going to rank cars based on how fast they accelerate from 0 to 100 kilometres per hour (that’s 0 to 62 miles per hour if you’re metrically challenged). Of course, you can rank anything based on a list of numbers, but let’s stick with cars.
Here’s a list of cars. And how fast they accelerate. If you’re both an Excel nerd and a rev head, go easy on me. I grabbed these numbers off the first website I could find, so the numbers aren’t necessarily accurate.
Anyways, I will show you two rank functions in Excel. The first one is rank equal. The other one is rank average.
How to rank numbers in Excel using the RANK EQUAL formula
If you’re into sports, you’ll like rank equal. You know how if you have two runners finish their 100 metre sprint in exactly the same time, they’ll share the rank – so equal first, for example… That’s what the rank equal function does.
To do rank equal, just type =RANK.EQ. You can hit tab once the formula you want is highlighted to autocomplete it.
Then, the first thing you want to select is the number next to the car on this line.
Then hit comma, and select the entire list of numbers. Remember to make this an absolute reference by hitting F4. Otherwise, when you copy the formula down, it’ll get messed up.
Hit comma again, then you have to select 0 for descending or 1 for ascending. What that means is, if you select to rank the items in descending order, it’ll make the largest number rank as number one.
But, for our cars, low is better, so we’ll select 1 for ascending, meaning the car with the fastest acceleration will be ranked number one.
Once you’ve done that, put in the ending bracket and hit enter.
Then you can copy the formula down to the other rows or just double click the little dot in the bottom-right corner of the cell and Excel will take care of it for you.
So there you go! The Saleen S7 is pretty awesome when it comes to accelerating quickly.
Notice how the Ferrari, Lamborghini and McLaren all do 0 to 100 kilometres per hour in 2.9 seconds. That’s the fourth fastest time, so Excel has ranked them all as equal fourth, and then the next one down is number seven.
How to rank numbers in Excel using the RANK AVERAGE formula
Let’s see what the rank average formula does! It works the same. Just type =RANK.AVG, hit tab to autocomplete, and select the same stuff again.
This time around, you’ll see Excel has ranked the three cars that do 0 to 100 in 2.9 seconds as equal fifth.
That’s because these three cars would occupy the fourth, fifth and sixth place on the ranking, so it’s gone ahead and averaged that. And as you know, four plus five plus six equals 15, then divide that by three to get five.
But what if there were only two cars sharing the same rank? Let’s fudge the numbers! Maybe the Lambo had a bad day and actually only managed 3.1 seconds?
The two cars in our list that do 2.9 seconds now share fourth and fifth place. They’re still showing as equal fourth in the rank equal column. But in the rank average column, they’re now showing as 4.5. Because four plus five equals nine, divide that by two and you get 4.5.
So there’s how to rank numbers in Excel! Was that useful? Let us know in the comments. And don’t forget to check out more of our Microsoft 365 tutorials!
In this tutorial we look at on SharePoint news links. This is the second tutorial in our series that will turn you into a SharePoint news publishing expert.
This series is highly relevant for corporate communication professionals, but even if you’re just looking to make the most of your team’s SharePoint site, you’ll get a lot of value out of this one.
What you’ll learn in this SharePoint news links tutorial
In this video we examine the differences between news links and news posts and teach you how you can use news links to avoid creating duplicate content on your intranet.
We show you how to create and edit news links and look at how news links show up in the SharePoint news feed just the same as news posts.
In this first of four lessons, we will turn you into a total expert at SharePoint news publishing!
This tutorial is particularly relevant for corporate communication professionals, but even if you’re just looking to make the most of your team’s SharePoint site you’ll get a lot of value from this one.
What you’ll get from our SharePoint news post tutorial
We’ll look at the difference between SharePoint intranet pages and news posts and how you can use the metadata field called promoted state to identify news posts.
While building the news post we talk through how to post in SharePoint on behalf of someone else, configuring the header, and adding text and other web parts. We also touch on the importance of keeping intranet news posts simple to avoid distracting your readers from the message you’re trying to communicate.
After saving a draft and posting your SharePoint news post, we also talks through Everything that happens in SharePoint after you publish your news post, including the SharePoint start page and news feed, news web parts on other intranet sites and on the smartphone app.
If you’ve never published anything on SharePoint before, we suggest you look at our tutorial on how to build your first SharePoint page and make it awesome.
Have you ever tried to find missing SharePoint pages? It’s not always easy if you don’t know where to look!
Don’t worry… In this tutorial we’ll show you how you can find those pesky, missing pages.
What you’ll learn in this tutorial on how to find missing SharePoint pages
One problem with modern SharePoint intranet sites is that pages don’t normally get added to navigation automatically.
And news posts won’t stay on the home page for long… So, what to do if a SharePoint page that you need just is nowhere to be found?
In this 5-minute tutorial we talk you through how you can search for SharePoint pages. We also look at how you can normally find lost SharePoint pages either in the site pages library in site contents.
We’ll even show you how you can find your SharePoint pages and news posts in your site’s recycle bin, if someone deleted a page by accident.
Have you ever tried to remove a deleted video from a YouTube playlist only to get stuck? YouTube has hidden that option well. But it’s easy once you know where to look.
Follow our mini tutorials below on how to remove deleted videos from YouTube playlists. And if you found the videos useful, please consider subscribing to our channel!
Remove deleted videos from YouTube using a computer
Remove deleted videos from YouTube using your iPhone
So, you’re at work and you get told you will need to build a SharePoint intranet page. And you go like “whaaaaat?”
How to build a SharePoint page in 20 minutes!
In this tech tutorial from Pixamoo we will walk you through how you build a modern SharePoint page from start to finish, and we’ll show you how you can make it look much better than your average intranet page.
We’ll explain SharePoint templates, the page building blocks or web parts that are available in SharePoint, and how to configure the SharePoint page headerHow to actually build the page.
Then we’ll move on to how you can make the most of columns in SharePoint pages, text formatting and how to make your intranet page easy to read Creative intranet page layouts.
Finally, we look at publishing your SharePoint intranet page and how you can spiffy it up just a little more.
