Tech Tips, Tricks and Guides
How to Create a Simple Pivot Table in Excel
Feb 4th, 2019 by Aseem Kishore
Also, we answer what is a pivot table?
How to Overclock an Intel Processor (CPU)
Jan 31st, 2019 by Ollie Green
And feel confident while doing it
How to Fix a Microphone Not Working on Windows 10 or 11
Jan 28th, 2019 by Ollie Green
Get up and running again in minutes.
How to Use If and Nested If Statements in Excel
Calculate commissions and so much more
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 […]
How to Use COUNTIFS, SUMIFS, AVERAGEIFS in Excel
The three most commonly used formulas in Excel that perform simple mathematical calculations are COUNT, SUM and AVERAGE. Whether you are managing a financial budget in Excel or simply keeping […]
Disable Keyboard Keys in Windows with AutoHotKey
A simple script to avoid inconvenience and confusion
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. […]
Automatically Scroll Down Pages in Your Web Browser
An overlooked feature that's actually quite handy
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 […]
WiFi Extenders vs Powerline Adapters – Which is the Best?
Pros and cons, different usage scenarios
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 […]
How to Install a New Graphics Card – From Hardware to Drivers
Be up and rockin' in no time flat
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 […]
Extract Images From A Word Document The Easy Way
Impress your coworkers with this neat little trick
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 […]
Use Dynamic Range Names in Excel for Flexible Dropdowns
Easy to edit, great for inexperienced users
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 […]
Instantly Remove Backgrounds from Images using AI
Works flawlessly, try it yourself!
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 […]
5 Great Reasons to Ditch Windows for Linux
No longer just for geeks
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 […]
Find Specific Files in Windows Explorer with These Search Tips
Even if you can't remember its name
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 […]
Google Sheets vs Microsoft Excel – What are the Differences?
The gap is closing between them
Previously, we wrote about the differences between Google Docs and Microsoft Word and in this post, we’re going to talk about spreadsheets. Spreadsheets are the pillars for our modern day […]
Why You Should Be Using Named Ranges in Excel
Use it in forms, macros, and source definitions
Named ranges are a useful, but often underutilized, feature of Microsoft Excel. Named ranges can make formulas easier to understand (and debug), simplify the creation of complicated spreadsheets, and simplify […]
Play Any PC Game with a Gamepad Using JoyToKey
For those who prefer controllers to keyboards
There was a time when “hardcore” PC gamers would look down on the idea of using a gamepad to play PC games. The mouse and keyboard reigned supreme, especially in […]
How to Record Your Screen on Windows 10
Step by step using free software
We have included two free methods for recording your screen on Windows 10 in this article. One method is via a feature built straight in to Windows 10 and the […]
Google Docs vs Microsoft Word – What are the Differences?
Some of these are very important
Ever wondered what the differences were between Google Docs and Microsoft Word? Whilst both word processors may look similar on the surface, they are actually different in many ways. In […]
Best New Features in Microsoft Office 2019
Office 365 users can access right away
Microsoft Office 2019 was announced and released on September 24, 2018 and it’s now available for Mac and Windows 10 users to purchase in all regions. Microsoft Office 2019 brings […]