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 theIFfunction. TheIFfunction is used to test a logical condition and produce two different results depending on whether the logical condition returnsTRUEorFALSE. Let’s use the mobile phone sales table below as an example. You can download theexample file here. IF Function with Single Condition...
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. 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 and confusion....
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 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 between tabs, changing your zoom level, stopping a page from loading, and more....
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 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 be suitable for you....
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 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 that should be taken before, during, and after the installation process....
