The following trick will help you remove unnecessary languages and architecture-specific files on your Mac and get some extra free space.
Detailed guide on creating league tables and top 10 lists using the MIN, MAX, SMALL, LARGE, INDEX and MATCH functions in Excel 2007.
Read a beginner's tutorial on how to create a tri-fold brochure using only Microsoft Word and a minimal amount of computer skills.
IPS panels produce more vibrant and accurate images and wider viewing angles than TN screens, but have slower response times. Read on to find the best gaming IPS monitor for you in 2014.
In beginners guide to Insteon home automation systems, including a review of pros and cons, technical specs and more.
TorrentFreak ran a series of interview to uncover the VPN providers that truly care about your privacy. However, what they say may not actually be happening and so this article attempts to dig deeper.
ggplot2 is a graphics library package in R. It helps you create amazing plots in R. This article explains how you can start with ggplot2 and create 3 basic plots.
This is the story of Alisha, who uses Google Keep to lead an organized life. This article connects various how-to documents, freely available on the web with her real life's experiences.
Windows update provides security and feature patches for your computer's operating system. Sometimes, however, updates go wrong or do things you don't want them to. Here's how to remove a bad update.
If you've done some reading about VPN, you probably already know that it stands for Virtual Private Network and it's a popular way for businesses to provide a secure way for employees to remote into their servers. But did you know that there are...
In this article, I revisit a top end graphics card from 2015; the nVidia GTX 980 Ti. I tested the card in 5 modern 2017 games to see if the card could handle modern gaming. Here are the benchmarks.
The term topology refers to the way a network is laid out, either physically or logically. Two or more devices connect to a link: two or more links form a topology.
Polipo is a fast, and lightweight web proxy server with support for several useful features including pipelining. This hub demonstrates how to install and configure a Polipo proxy server on pfSense.
In the final stages of programming mastery, you must come to appreciate the strengths and weaknesses of your chosen language. Even if you choose a modern variant, a complete knowledge of C is useful.
A well-built $400 gaming computer can play even today's most graphically intensive video games. This optimized build should give you a good idea of the performance you can get from a budget gaming PC.
Upgrading FreeNAS to the latest version allows you to take advantage of bug fixes and new features. This hub explains how to upgrade FreeNAS 8 using three different methods.
Today, I give you 4 total PC builds including the new Intel Coffee Lake processor, 2 Kaby Lake builds, and a Ryzen build.
PfSense logs can be viewed through the web gui but it is much more convenient to view them remotely. Kiwi syslog server can receive syslog messages sent over the network from one or more pfSense systems.
FontBundles.net is a great website providing amazing premium fonts and font bundles at affordable prices. Their carefully collated bundles are actually dream come true for crafters and designers.
The Windows 10 lock screen is mainly intended for touchscreen-enabled PCs and laptops. If you are thinking of permanently disabling the lock screen in Windows 10, this article will teach you how.
In time, you may notice that your Mac battery does not last as long as it used to. Here are some tips to prevent that.
In this article I am reviewing and providing benchmarks for the Intel Core i7-8700K, 8th generation Coffee Lake processor.
Learn how to use the maths operators + - * / % ( ) and SUM, COUNT and AVERAGE in formulas in Excel 2007 and Excel 2010. Also how to use & to join cells and $ to make a cell an absolute reference.
If you run a business you understand the importance of Invoicing. Without an invoice, you’re not going to get paid. Small firms often do not have dedicated software that allows you to do all your accounting including the creation of Invoices, so...
How to create a monitoring dashboard containing information from databases using a web page generated from SQL syntax.
Nothing annoys the hell out of you more than your Linksys router & adapter refusing to connect. Use this guide to get everything up and running again!
Edit menu in Ms Word 2003 is very important. It helps us to edit the documents that we type. Knowing how to use it is much more important to you. This article introduces you to the edit menu.
You may need to bring data from different cells together in Microsoft Excel. One way to do this is to use a formula. A concatenate formula can display data together with spacing that is editable.
The amount of malicious software is growing by an exorbitant rate and overwhelming security vendors. Identifying and disinfecting systems of that software remains in the realm of antivirus software.
If you use Windows operating system, DirectX is, by chance, a term that is not unfamiliar to you. Especially if you are quite fond of playing games developed for Windows platform, chances are you hear about the term day in day out. Yes, you may have...
Administrator rights are necessary to install programs and edit system preferences. This tutorial will help you reset your Windows administrator password, in case your forgot yours.
The easiest and least expensive upgrade for your laptop is a memory upgrade. This hub will walk through the process of selecting memory and installing it in the Alienware M15x laptop.
This article explains how the pfflowd package can be used to export NetFlow data from pfSense. It also covers the basic process of setting up a flow analyzer on a remote machine.
In this article, I will be reviewing the DIYPC DIY-F2-P windowed budget PC case. This case is the epitome of budget cases.
This article looks at the best computer speakers with subwoofer currently available for those wishing to spend $100 or less.
In this article, I tested the PowerColor Red Devil RX Vega 64 graphics card undervolted and overclocked to assess rumored performance of the AMD Vega line of graphics cards in such scenario. Read on to find out the results of the testing.
Programming in C language is the technological equivalent of knowing Latin in Academia during the Middle Ages. C is a major language in its own right, and many popular languages have borrowed syntax.
Sometimes you may not want to delete the duplicate values but may want to highlight them anyway. Here's a step-by-step tutorial to highlight duplicate values in Microsoft excel without deleting them.
In this article I review and compare the Sapphire Nitro+ RX 570 4GB graphics card to the MSI GTX 1080 Duke 8GB graphics card. I have included a review of specs, benchmarks, and my recommendation.
With the help of automatic form fillers, you can quickly send messages via forms without the need to repeatedly type your information like name, email, contact number, etc.
A good monitor doesn't have to be expensive. Here's a look at 3 monitors between $150-$200 that are perfect for any workspace. Includes an LED IPS, TN, and gaming option.
This article is a review of the Cooler Master Devastator II keyboard and mouse bundle. A fantastic budget value with a premium feel.
Exploring the intrigue of AIs, or "thinking machines". How far are we from creating a computer with a human-like mind? How accurate are AIs depicted in fiction?
Devices that run Windows or Android often aren't so easily compatible with others of the same operating systems because they're made by different companies. But what what if they changed that?
This article explains how to upload a video to Adobe Premier Pro and capture a photo from that video.
This article contains a list of Microsoft Office shortcuts and tips for Word, Excel, and PowerPoint.
The Samsung S22D300H led monitor is best used as a computer monitor because of its high quality images, design, weight, and of course- price. We review the S22D300H in terms of price, quality and performance.
Browser extensions for Microsoft Edge are now available. Learn how to add the ones you need to super charge your favorite Windows web browser.
There are times that when forms are sent, they need fields to be no longer able to be edited. This tutorial shows how to make an interactive PDF form read-only before submitting.
Finding a laptop that is good for editing photos can be challenging. But the advent of notebooks with excellent IPS screens and powerful processors and GPUs makes it possible to find some.
If you currently use Mailpoet for your email subscription list, you've probably seen that they have a new version available. Is it worth making the switch?
I am bringing you my choices for the best gaming PC components for December 2017. These systems are good entry-level, budget gaming PC options for anyone looking to get into PC gaming.
Ever wondered why the comments attached to cells are not printed when the Excel sheet is printed? This step-by-step tutorial will show you how.
If you're writing a function and it gets big enough to be clumsy, I'm sure you know to break it down into multiple, smaller functions, each of which is comprehensible. Of course this is good practice in any language at all, but it's especially...
The Sampling Tool from the Analysis Toolpak in Excel 2007 and Excel 2010 allows you to create random samples or smaller samples from larger data sources as well as analysing your data for variations.
An easy way to improve the quality of your economic or financial graphs is to add recession bars; they enhance both the professional look and usefulness of your graph. The common way people add recession bars is simply drawing colored rectangles...
This is a Ryzen 7 1700 Streaming/Gaming PC build that I will be building over the next year. This PC will feature primarily Corsair and AMD/Ryzen components.
Intel just announced the hire of Raja Koduri, former AMD graphics card architect, to be the person to spearhead their endeavor into the discrete GPU market. This article discusses the ramifications.
Computers are used widely and are an important part of our lives. Yet there are people who don't know how to use them and that's why I've prepared this introduction to computer basics.
You can program in C every day for years and never use all the features in the core language. Most problems don't require them, but if you're aware they exist you can learn more as needed.
Free alternatives to Microsoft word - a list of the best open source word processors you can install on a Windows computer.
Windows 7 may be the best Microsoft system so far, but it is not immune to problems. Here's how to repair a damaged installation without losing your installed programs and personal files.
In this article, I share the results of a small sample, hybrid retrospective, cross-sectional analysis study of Intel's newest Coffee Lake i7-8700K computer processor.
Artificial Intelligence is the branch of computer science that researches and studies the ability to program software that uses logic to make decisions, mimicking that of human rationale... but how?
This page describes the step by step procedure to install Tomcat into Spring Tool Suite or Eclipse IDE.
Knowing the full syntax of a programming language is an essential step toward mastery. In this article, I draw a path from beginner to expert for readers who are willing to put in the practice.
Software testing can seem overwhelming at first, but breaking down the basic types of software testing is an immportant first step.
This is a step-by-step tutorial to use the Substitute function to replace some text (usually recurring) in an Excel sheet.
Use the MATCH function in Excel 2007 and Excel 2010 to compare lists or look for an item in lists to find its relative position which can then be compared to see if the item has moved up or down.
In this review, I rate, benchmark, and give thoughts on the AMD Radeon R7 360. Is it good enough for gaming in 2017?
This article lays out a part list to a budget PC build with AMD Ryzen at the heart. This build can be had for under $500 and can compete with modern gaming consoles.
Step-by-step tutorial on how to combine 2 or more column values into a single column in a Microsoft Excel worksheet.
The advent of digital technology has brought with it many many great advantages, here I list 16 of the main ones.
A USB modem or the presence of a single Ethernet port provides a working Internet connection only for one computer. Here's how you can easily share that connection with any wireless-ready device.
One of the basic lessons in the field of computer science is recursion and the formula that is used the most in the study of recursion is the Fibonacci sequence.
Does your DeathAdder mouse have that sticky surface? Many of us do after many hours of usage. Using a damp cloth simply wouldn't get rid of it. But here is how I did it - with just blu-tack.
How-to guide on using shapes in Excel 2007. I illustrate how to create a button in Excel 2007 using a rounded rectangle and a hyperlink.
There are many ways to become a more efficient Windows 7 User. Keyboard shortcuts for Windows 7 is a great way to start.
This article goes over ways to organize files and keep your computer's file system neat and organized. Doing this has many benefits and I explain what they are.
How to make an e-card on Microsoft Powerpoint. Create a great Christmas e-card to email to friends, do it all on Microsoft's presentation package, Powerpoint.
Combining the hybrid IT networks with an Integration Platform as a Service (iPaaS) approach requires technological knowhow. Refer this checklist for joining the set pieces of Hybrid Ecosystem .
Easy way to fix the PAIGEfilter Missing Plug-ins error in Adobe InDesign when working with two different versions of the program. A lot of times when opening an older version document in a newer version software this error will pop up. If it is not fixed it will create pre flight issues when attempting to PDF or print the document. This is a quick and easy way to fix the error.
Getting started with html? Here we'll cover some basic html concepts and what programs to use to write clean html.
What is as-built data? What is as-designed data? What is the relationship between as-built data, as-designed data and product verification?
Find out if it is better to buy the latest TP-Link Archer C9 or older TP-Link Archer C8 based on a detailed comparisons between these two Gigabit routers to get the best deal
Learning how to use nested IF statements in Excel will save you time and help you to be more efficient. They look challenging, but with the help of this tutorial, you can be using them in no time.
Now that pfSense version 2 has been officially released, it's a great time to upgrade your firewall to the latest version. I will demonstrate three different methods of installing the upgrade.
If you are a designer working with a development team who is building a piece of stand-alone software, chances are you’ve experienced the need to provide them with 4-bit graphics and icons. It’s not something that is entirely intuitive to do in...
Ways to compute the response time of each transaction in Maximo and identify each transaction's message ID using the logs and the message tracking table.
There are a few different options when printing your presentation in PowerPoint 2007. You can print handouts with notes for your audience as well slides with notes for your personal use. This article describes the print options and how to use them.
Utilizing 3rd party software components in a solution should be given serious consideration over a strict home grown approach.
In this article, I review the EVGA GTX 1080 Ti SC2 Gaming graphics card. I have tested this card in multiple games and provided benchmarks of those games as well as a quick review of the card, its specifications, and performance.