How To – Video Guides
J2 Technology specialises in helping businesses achieve the most from their IT infrastructure investment. We can provide the complete solution from specification, supply, configuration, installation and on-going maintenance support.
There are lots of simple shortcuts in Microsoft 365 that will save you time, if you know about them that is
Well the good news is that we have put together a library of easy-to-follow short videos on how to get the most out of Word, Excel, PowerPoint and Teams
Take a look, and we promise you’ll be saying ‘I never knew that’ in no time
Click on one of the following thumbnail images to jump to the relevant video library
New “How To” videos will be added periodically. Hit the button below and be notified immediately when new videos are made available
Interested in more in-depth “how to” and training content?
We have over 750 bite sized videos covering a wide range of subjects, including –
- Windows 10
- Microsoft 365
- Microsoft Teams
- Cyber Security
- Remote Working
- Working from Home
- Mental Health & Wellbeing
- Customer Care
- Leadership & Management
- How to be successful
- Selling Skills
WORD: Swap text to capitals and back on the keyboard
You may already know about the toolbar shortcut to change your text from capitals and back again, but did you know that there’s an even quicker way? We’ll show you this nifty keyboard shortcut.
WORD: Start a bullet-pointed list in just one click
Bullet points are great for communicating information and breaking up large chunks of text. We’ll show you how to create a bulleted list in Word without even touching the mouse.
WORD: Save documents much more quickly
Saving your Word documents can slow you down, especially if you’re having to change the default options. This video will show you how to set your own defaults, so that saving is a breeze.
WORD: Never lose vital work when you click Save
Once you’ve pressed that Save button, you may have lost work you can’t get back. We’ve solved that problem for you. Learn how to create automatic backups in Word so you can always find the work you need.
WORD: Send the fonts used in your document
Your beautiful Word documents deserve to be seen as you intended. In this video, we’ll show you how to embed fonts in the document, so they can be opened by anyone.
WORD: Create your own text format and use it quickly
Don’t spend ages recreating text styles throughout your documents. In this video we’ll teach you how to create your own style formats that you can use quickly and easily.
WORD: Compare 2 documents really easily
When you need to compare documents, you don’t need to keep flicking back and forth between windows. We’ll show you how you open these documents side by side for easy comparison.
WORD: Change lots of text all in one go
Need to make a lot of changes throughout your Word document? Don’t waste time scrolling through pages and pages. We’ll show you how to do it quickly with this handy feature.
WORD: Concentrate and type more
Sometimes when you’re writing an important Word document, it’s too easy to be distracted by all the menus and buttons. Did you know you can remove the clutter from Word and put it into Focus mode… with just one click? Here’s how.
WORD: Do whatever you want with one click
If you spend a lot of time searching through menus and tools in Word, then your life is about to become a lot easier. Here’s how to create your own Quick Access Toolbar, so you can get to the tools and settings you use most often with just one click.
WORD: Get rid of the annoying welcome screen
The Word welcome screen is great… the first time. Did you know you can skip it every time you open Word, so you can get straight to work? Here’s how to do that.
WORD: Insert chunks of text with a click
If you use Word a lot, you’re probably typing in the same information again and again and again. Save time by using the Auto Text function. Let us show you how.
WORD: Insert chunks of text with short codes
Always typing the same information into Word documents? Save time and get it right by using short codes. You’ll wonder how you ever lived without them. Here’s how to set them up.
WORD: Do mass personal emailing
Did you know you can send mass personal emails from within Word? Here’s how to make multiple emails look personal to every recipient, without having to leave your document.
WORD: Print mass personal letters
If you have a lot of letters to send and want to personalise them, this video is for you. Learn how to insert personal information, merge and print multiple letters from just one document.
WORD: Start a new document quicker
If you find yourself copying or overwriting old documents, you need to start using templates. Here’s how to create, save and open them.
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: 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: 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.
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.
POWERPOINT: Remove the background from images quickly
We’re on a quest to get rid of terribly designed PowerPoint presentations. In this video, we’ll show you how to remove the background in images without having to use third-party graphics software.
POWERPOINT: Add sound to your slides
If you want to create a PowerPoint presentation that will impress, consider adding sound. Music, sound effects and audio files can make your presentation stand out. It’s a lot simpler than you think.
POWERPOINT: Say goodbye to boring bullet-points
Bullet-points. Useful, but kind of boring. Not anymore. This video shows you how to make your bullet-points looks as awesome as the rest of your PowerPoint presentation.
POWERPOINT: Grab attention by live zooming in your presentation
No more “death by PowerPoint”. Make your presentation stand out by learning how to live zoom in and out during your presentation. Your audience will thank you.
POWERPOINT: Quickly blank the screen during a slideshow
A great PowerPoint presentation isn’t just about what’s on screen. It’s what you say too. When you want all eyes on you, we’ll show you how to quickly blank the screen until you’re ready to continue.
POWERPOINT: Live draw on your slides to grab attention
Pretend you’re a TV sport pundit by drawing directly on your PowerPoint slideshow during the presentation. In this video we’ll show you how to grab attention with live drawing.
POWERPOINT: Turn your presentation into a video
No PowerPoint? No problem. In this video, we’ll show you how to turn your presentation into a video, so it can be played on any device, even one without access to PowerPoint.
POWERPOINT: Insert elegant invisible links in your presentation
You’ve designed a visual PowerPoint masterpiece, so why ruin it with a clunky looking menu or set of links? In this video we’ll show you how to create invisible links that appear part of the design.
POWERPOINT: Change your pointer to grab attention
When you’re presenting in PowerPoint, how do you focus the audience’s attention? In this video we show you how to quickly change the standard pointer, so everyone’s attention stays exactly where you want it.
POWERPOINT: Create and insert screen recordings
A video’s worth a thousand PowerPoint slides for communicating information. In this video, we show you how to create and insert screen recordings directly into your slides.
POWERPOINT: Send the fonts in your presentation
You’ve created the perfect PowerPoint presentation… only for it to look terrible when it’s opened by someone who doesn’t have the same fonts. Now your slides can look perfect on any device. Here’s how.
POWERPOINT: Make everything symmetrical
If you want all the elements of your PowerPoint slide to line up, but don’t want to spend ages moving them about and trying to make them symmetrical, this video is for you. We show you how to make everything line up perfectly, in just a few clicks.
POWERPOINT: Turn a Word document into a PowerPoint
Have you ever needed to make a PowerPoint presentation based on a Word doc? Don’t waste hours cutting and pasting. Instead use our next-level PowerPoint tip to automatically turn your Word document into a presentation. Here’s how.
POWERPOINT: Use 3D models in your slides
It’s time to ditch the clip art in your PowerPoint presentations. Here’s how to insert 3D models directly into your slides and take your presentations to the next level.
TEAMS: 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.
TEAMS: 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.
TEAMS: 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.
TEAMS: 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.
TEAMS: 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.
TEAMS: 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.
TEAMS: 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.
TEAMS: 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.
TEAMS: 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.
TEAMS: 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.
TEAMS: 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.
TEAMS: 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.
TEAMS: 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.
TEAMS: 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.