Skip to main content
  1. Home
  2. How-To Guides

How-To Guides

Man uses Microsoft Teams on a laptop in order to video chat.

How to keep your Microsoft Teams status active

Learn how to keep Microsoft Teams active so you never appear as Away to your boss and are always reachable for calls and messages.
The Backbone One - PlayStation Edition lays down with the PS Remote Play turned on.

How to use remote play on PS5

Wondering how to use remote play on PS5? Getting set up is simple as long as you have a compatible device and controller. Here's how to start.
Discord gaming key art.

How to use Discord on PS5

A new update has made it easier than ever to chat with friends on the PS5 using Discord. Here is how the new process works and how to set it up in a flash.
Astro Bot climbs on a DualSense controller.

PS5 controller drift: how to fix PS5 controller joystick drift

If you're noticing issues with your DualSense joysticks, there are a few methods you can try to repair it yourself. Here's how to fix joystick drift on PS5.
A red and blue PS5 stands on a table with matching controllers.

How to factory reset a PS5

No matter if you want to sell, trade in, or just troubleshoot your PlayStation 5, our guide will help you figure out how to reset your PS5 quickly and easily.

How to find duplicates in Excel

Microsoft Excel is perhaps the most powerful spreadsheet application you can buy. But it also has some simple functions, like finding duplicates in data.
A man using a PC to view an Excel spreadsheet.

How to use concatenate in Excel

Concatenate merges the data you have inserted into columns into its own cell or column in Excel. Let’s take a look at how to use concatenate in Excel.
Motherboard CMOS battery.

How to reset your BIOS

Resetting your BIOS can be a great way to fix common boot problems, undo a broken overclock, or undo a system change you regret. Here's how to do it.
A MacBook on a table using Google Sheets.

How to convert Excel files to Google Sheets

Google Sheets is known for its versatility, namely its compatibility with Excel files. Here's a guide on how to convert Excel files to Google Sheets.

How to add a column in Excel

Adding a new column to either an entire spreadsheet or just a portion is an easy thing to do in Microsoft Excel. Here's how.
A person looking at bar charts on a PC.

How to make a graph in Excel

Graphs in Excel help break down your data into an easily digestible format. Here’s how to make a graph in Microsoft Excel.
Changing your PS5 welcome hub background.

How to change your PS5 Welcome Hub background

PlayStation won't let you change the background of your PS5 dashboard, but you can change your Welcome hub. Here is how you can customize how this screen looks.
A laptop opened to the ChatGPT website.

How to use ChatGPT to write Excel formulas

Need a formula for your Excel spreadsheet in a flash? Try ChatGPT. In this guide, we'll show you how to write Excel formulas using ChatGPT.
Stock photo of man using laptop

How to wrap text in Microsoft Excel

Text wrapping isn't just for word processors. You can wrap text in spreadsheets too. Here's how to wrap text in Microsoft Excel using two different methods.
A hand holding an iPhone with the Apple TV+ and other services in a menu.

How to cancel your Apple TV Plus subscription

Interested in canceling your Apple TV Plus subscription to save money or end your free trial quickly? We'll show you exactly how to do it on multiple platforms.
A person sitting on the grass and taking notes at a laptop.

How to subtract in Excel

Subtraction methods in Excel aren't the quickest or simplest, but if you need to get it done, we can show you how to subtract in Excel. Here's how.
Stock photo of woman using laptop at desk

How to multiply in Excel

Multiplying numbers in Excel isn't always the easiest thing to do, but it can be done. Here's how to do it in four ways, depending on what you need to multiply.
A man using a PC to view an Excel spreadsheet.

How to create a drop-down list in Excel on Windows and Mac

Adding a drop-down list in Excel is a quick and efficient way to choose predefined data. Here's how to create a drop-down list in Microsoft Excel.
A person using a laptop while lounging on a couch.

How to password-protect an Excel file on Windows and Mac

Sending Excel files containing crucial financial and business data has risks. To add a layer of protection, you should learn to password protect an Excel file.
Microsoft Excel opened on a desktop computer.

How to freeze rows and columns in Excel

Looking for a way to make your Excel spreadsheets read more clearly? Why not try freezing some of the rows and columns. Here’s how.
Spreadsheet on a laptop on a table.

Here’s how to quickly and easily convert a PDF to Excel

Excel gives you tons of options for editing, but what if your file is a PDF? Here's how to convert a PDF into an Excel file with ease. Just follow these steps.
An Excel employee database.

How to use VLOOKUP in Excel

The VLOOKUP function is one of the most useful when pulling information from an Excel database. Here's how it works and how you can start using it in your work.
A person using a laptop that displays various Microsoft Office apps.

How to lock cells in Excel

Locking cells in a Microsoft Excel spreadsheet is among the most commonly used functions. Here’s a guide on how to lock cells in Excel.
Excel app

How to merge and unmerge cells in Microsoft Excel

Microsoft Excel has numerous powerful data analysis functions, but sometimes you need to do something simple like merge some cells. Here's how.
The player’s character, Demetrian Titus, holds a banner while shooting enemies with a pistol in Warhammer 40,000: Space Marine 2.

Warhammer 40,000: Space Marine 2: Eternal War tips and tricks

Eternal War is the 6v6 multiplayer mode in Warhammer 40,000: Space Marine 2. Here's what you need to keep in mind to dominate the competition.
A player prepares to enter an airship in Warhammer 40,000: Space Marine 2.

The best classes and perks in Warhammer 40,000: Space Marine 2

In Operations mode, you'll be able to choose from six unique classes. Here's what you need to know about each one to maximize its success in the field.
Warhammer 40,000: Space Marine 2 enemies.

All bosses and enemies in Warhammer 40,000: Space Marine 2

In Warhammer 40,000: Space Marine 2, countless threats are eager to lay waste to the domains of the Imperium of Man. Here are all enemies in the game.
A Space Marine in a red helmet holding a giant gun.

All weapons and perks in Warhammer 40,000: Space Marine 2

Getting the upper-hand in Warhammer 40,000: Space Marine 2 means using the right weapons for the job. Here's a breakdown of every weapon in the game.
PowerPoint Slide Sorter view on a Windows laptop.

How to create a Powerpoint Presentation

Powerpoint presentations are a great way to share information with a team or to make a presentation to a group. Here's how to make one.
Three women in a Microsoft Teams meeting.

How to join a Microsoft Teams meeting

If you have an important call coming up, we're here to tell you how to join a Microsoft Teams meeting in four easy ways.
A person drinking coffee while using a laptop at a table.

How to insert footnotes in Word on PC and Mac

Adding a footnote to a Microsoft Word document isn't difficult at all. In this quick guide, we'll show you how to insert footnotes in Word in just a few clicks.
Word with linked text on a Windows laptop.

How to add hyperlinks in Word

Make it easy to navigate your document, visit a web page you mention, or create an email. Here’s how to add hyperlinks in Word for quick actions with a click.
The rentals screen on Plex.

How to use Plex Media Server to watch all of your media

Plex can take your movies, TV shows, music, and photos and give them the Netflix treatment for the ultimate at-home or away-from-home streaming experience.
Example of Teams chat.

How to create a new team in Microsoft Teams

Microsoft Teams allows you to organize your group based on different teams for different projects. Here's how to create and customize those Teams quickly!