How to Use If and Nested If Statements in Excel

by File in: Office Tips

One Excel function that I use quite a bit in my formulas is the IF function. The IF function is used to test a logical condition and produce two different results depending on whether the logical condition returns TRUE or FALSE. Let’s use the mobile phone sales table below as an example. You can download […]

Disable Keyboard Keys in Windows with AutoHotKey

by File in: How-To

When you’re at your keyboard, not too many things are as frustrating as accidentally hitting a disruptive key. For example, the Windows key can cause some fullscreen applications to minimize. Pressing the Alt key can sometimes completely block all key inputs thereafter. If you’re accidentally hitting these keys without knowing, it can cause major inconveniences […]

Automatically Scroll Down Pages in Your Web Browser

by File in: How-To

Automation is one of the biggest keys to maximizing your productivity. Think about how painstaking everyday desk work would be if simple shortcuts like Ctrl+A, to select all text, or Ctrl+LMB (left-click), to open a link in a new tab, didn’t exist. Modern browsers do a good job of covering the shortcut-key basics, like jumping […]

WiFi Extenders vs Powerline Adapters – Which is the Best?

by File in: Networking

When running an Ethernet cable from your router to your PC isn’t an option, you’re left picking between the lesser of two evils – WiFi extenders or powerline adapters. But which of these is the best? Both technologies have their pros and cons and we’ll be looking at both to explain how each option may […]

How to Install a New Graphics Card – From Hardware to Drivers

by File in: How-To

Got a new graphics card but don’t know how to install it? We’ve got you covered. In this article, we’ll take you through every step necessary to uninstall your old GPU, install a new graphics card, get your drivers up to date, and get playing. We will also take you through all of the precautions […]

Extract Images From A Word Document The Easy Way

by File in: How-To

Microsoft Word is one of the most common word processors on the market, but while it’s a great solution for editing text, managing images within a document can be hit or miss. Picking out pictures and saving them manually can be a long and frustrating process – especially in large files with many pages. Fortunately, […]

Use Dynamic Range Names in Excel for Flexible Dropdowns

by File in: Office Tips

Excel spreadsheets often include cell dropdowns to simplify and/or standardize data entry.  These dropdowns are created using the data validation feature to specify a list of allowable entries. To set up a simple dropdown list, select the cell where data will be entered, then click Data Validation (on the Data tab), select Data Validation, choose […]

Instantly Remove Backgrounds from Images using AI

by File in: How-To

What would the world be without applications like Photoshop? Computer-based image manipulation has revolutionized publishing and visual arts in general. Best of all, anyone with the right skills can create some amazing imagery using nothing but their computers and the right software. The key word here, however, is skill. Creating great manipulated images requires a […]

5 Great Reasons to Ditch Windows for Linux

by File in: Linux Tips

Linux. You have probably heard of this alternative to Windows, but how much do you really know? Linux has developed a reputation for being highly technical and best left to geekiest of computer enthusiasts. What you might not know is that Linux or one of its close cousins run almost everything we use. Your favorite […]

Find Specific Files in Windows Explorer with These Search Tips

by File in: Windows 10

Ever lost a file on your PC and just can’t track it down? With the search tips in this article, you’ll be able to find specific files in Windows file explorer, even if you can’t remember the exact name or location. The more information you know about the file you are looking for the better. […]