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 […]
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 […]
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 […]
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 […]
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 […]
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, […]
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 […]
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 […]
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 […]
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. […]
