How to: Excel

The past few years has transformed the way the world views virtual meetings and collaboration but some of us were invested in Teams before it was cool! Here’s a selection of some of our favourite Teams features; have you tried them all?

EXCEL: Always see the headings when scrolling

Excel is great for looking at lots of data, but when you can’t see the column or row headers, you have to scroll back and forth to check what the data means. Did you know there’s a great time saver which can lock the headers in place? Here’s how to do it.

EXCEL: Easily zoom in and out

When you’re looking at data in Excel, make sure you’re looking at the bigger (or smaller) picture by using the Zoom functions. This video shows you how to zoom in and out easily.

 

 

EXCEL: Get to the top row without scrolling

If your Excel document is very long, it can take a lot of scrolling to get back to the top. Find out how to do it quickly, without moving the mouse or endless scrolling. It’s a shortcut you’ll use over and over.

EXCEL: Instantly see all data in columns & rows

Sometimes in an Excel document the column sizes need to be adjusted so you can see the data clearly. Rather than trying to change all the column and row sizes manually, we show you how to do it in just a few clicks.

EXCEL: Speed up typing

Do you find yourself typing duplicate words or numbers into Excel? You can speed up this process by using the clever Flash Fill feature. It’ll save you from typing out the same info multiple times. Here’s how to use it.

EXCEL: Do super-fast sums without formulas

Excel is great for calculations with formulas. But if you find your head spinning trying to remember how they work, we have the ultimate Excel hack for you. This video shows you how to do super-fast sums without formulas.

EXCEL: Turn numbers into money with one click

If you’re using Excel to track budgets or other financial data, it can be helpful to have your currency symbol alongside the numbers. Here’s how to turn numbers into money, with just one click.

EXCEL: Save time adding new columns or rows

Adding multiple columns and rows into spreadsheets can be time-consuming, not to mention boring. Give that trackpad a rest and add as many new columns and rows as you need in one go. Here’s how.

EXCEL: Create ranges of data without doing any typing

If you need to create sequential numbers, dates or other data in Excel, it can take forever. Not anymore. We’ll show you how to do it with the minimum of typing.

EXCEL: Swap rows into columns and vice versa

When you need to swap your rows into columns or columns into rows, it can be tricky. Not only is it time consuming, but you run the risk of mixing up your data. We’ll show you how to do it in just a few clicks.

EXCEL: Make dull data stand out and become dynamic

You may think it impossible to make Excel sheets appear interesting. Well, you’d be wrong. In this video you’ll learn how to make your data stand out.

 

 

 

EXCEL: Insert live Excel data into Word

If you need to display data from an Excel sheet in your Word document, don’t waste time trying to recreate it. We’ll show you how to use live Excel data in your Word document in just a few clicks.

EXCEL: Make a drop-down list to select from

Don’t waste valuable time typing the same data into Excel repeatedly. We’ll show you how to create a dropdown list that will get the job done in no time.

EXCEL: Understand your data with super-fast graphs

Excel is such a clever tool, it can make sense of your data for you. This video will teach you how to take a sheet of numbers and turn them into helpful graphs, fast.

EXCEL: Combine text from two cells into one

When you need to combine two cells into one, there’s no need to cut and paste every cell. With this simple formula, you can do it quickly and accurately.

Blur or change your background on a video call
Got a video call but your room isn’t appropriate for work? Did you know you can blur your background or change it entirely in Teams? Here’s how to make your backdrop look professional, without having to do any tidying.

Look like you are in one room
Remote working is great, but you can still miss that ‘together’ feeling when you’re on a Teams call. Here’s how to make it look like you’re all in the same room.

Master ALL the shortcuts
Shortcuts are great, but only if you know about them. Use this handy tip to see all Teams shortcuts in one place. It’ll change the way you use Teams.

Only allow interruptions from your boss
Everyone needs time to work free from interruptions. But what if your boss is trying to contact you? This video shows you how to use Priority Access to block everyone except your boss.

Quickly mute your mic during a call
How many Teams calls are interrupted by random noises? This really simple shortcut shows how to quickly mute your mic, so your co-workers don’t have to listen to every cough, sneeze or dog bark.

Quickly turn off your camera during a call
Have you ever been on an important Teams call, only to be interrupted by your children or pets in the background? We’ve used a famous viral video moment to demonstrate how to quickly turn off your camera.

Send messages without breaking your workflow
The messaging facility in Teams is great, but it can break your concentration and flow. In this video, we show you a different way to use messages without having to leave the screen you’re working on.

Stop the pings with Do Not Disturb mode
If you’re finding it difficult to get your work done due to constant interruptions, then you need the Teams equivalent of a closed door. Here’s how to turn on Do Not Disturb and silence the pings.

Turn a quick email into a message
We love Microsoft Teams, but sometimes it’s quicker to share your thoughts via email. In this video, we’ll show you how to send an email directly into your Teams channel.

Swap to the right mic during a call
You’re on a Teams call and you’re talking, but no one can hear you. It’s happened to us all. In this video, we’ll show you how to fix your microphone quickly, without having to leave the call.

Stop writing posts that are 1 sentence long
Every time you hit Enter in a Teams chat, you send a separate short message, which isn’t great for getting you full point across. In this video we’ll show you how to communicate effectively, without the multiple messages.

Share the right screen during a call
When sharing your screen during a Teams call, you want to be sure you’re not showing anything confidential or embarrassing. We’ll show you how to display only the information you want.

Setup your camera and mic before a call
Avoid the embarrassing tech fails at the beginning of Teams calls by setting up your camera and microphone before the call. Watch this, do it now, thank us later.

Find out if someone is free without having to check
Need to get in touch with someone but not sure if they’re free? In this video, we’ll show you how to find out if someone is available without having to continually check.

Create a personal voicemail message
Give Teams the personal touch. When receiving calls in Teams, you can now create a personal voicemail message for your colleagues. In this video we show you how.