Conditional formatting in Excel 2007 and Excel 2010 allows you to add visual impact to your spreadsheets. Use icon sets and cell formatting to add colour to highlight data or illustrate trends.
The PMT function within Excel is a financial function that is used to calculate loan payments (it can also be used to calculate the value of investments over time); with the associated IPMT and PPMT functions it is easy to create a worksheet that will calculate an amortization schedule for a mortgage or other loan.
After April 8, 2014 Microsoft will no longer supply security updates for Windows XP. Here’s what one small church plans to do to be able to continue to safely use WinXP.
In Excel 2010, Conditional Formatting Icon Sets and Data Bars have been greatly improved. Icons Sets can now be mixed and matched and Data Bars show negative values on an axis in a different colour.
The calendar in Outlook is a great organization tool. If you have alot of appointments to add, enter them in Excel and import them into Outlook.
In this article, I bring you the benchmarks of a recent $500 budget PC build. The budget PC features Intel's Coffee Lake Series Core i3-8100 CPU and is paired with the Radeon RX 550 2GB graphics card.
FreeNAS is an open source project that allows you to turn an old computer into a network attached storage system. This hub will walk you through the process of setting up FreeNAS 8.
Want to build the perfect custom gaming PC? Here are 10 good options from $500 to $2,000 for playing in 1080p, 1400p, VR, and 4k resolution.
Want to play your favorite AAA titles in 1440p and 4k? Here's a good desktop gaming PC build that is more than capable.
CloudTrax is a free WiFi Hotspot management system designed for small to large WiFi networks with minimum configuration. The free software/system is ideal for free & paid WiFi Internet access.
In this article, I am reviewing the Sapphire NITRO+ Radeon RX 570 4GB graphics card I picked up during Newegg's Black Friday Sales.
Looking for the right DDR4 for your gaming rig? Here's a look at the top value DDR4 kits for the money.
The motherboard includes components crucial to the functioning of a computer. Among them, the Central Processing Unit and Random Access Memory. Learn more about the parts and their functions.
Text Boxes may contain the written word but they are really a graphic tool. Used properly, they can add polish and professionalism to any written presentation. This is my first installment in a series of tutorials on the graphic capabilities of Microsoft Word.
Microsoft Excel has become the standard spreadsheet for most business use, but with it's functionality and ease of use the advantages of Excel can be used at home as well.
Android emulators for your Windows PC let you test your new Android application before you post it on Google Play, and also let you try out new Android games and apps.
What's the best power supply for your gaming rig? We've taken out the guessing by categorizing current options into tier lists and telling you which ones we feel give you the best value.
Discover how you can Get Things Done in Wunderlist with this step by step guide to implementing a digital version of David Allen's productivity system.
Game development has become much easier than it was a decade ago. Some of the best game creators offer an excellent toolset.
Improve wireless performance on slow browsing computers. Learn what negatively effects wireless and solutions to overcome slow internet browsing. Speed up the internet.
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.
The Excel CONVERT function allows you to convert numbers between a variety of measurements including weight and mass (grams, pounds and ounces), distance (meters and miles) and time among many others.
The OFFSET and COUNTA functions allow you to create dynamic ranges of data. Formulas created to SUM this data (for example) will automatically update if data is added or removed from within the range.
Photo or video editor on a budget? Here's a look at 4 top editing monitors for budgets of just under $500 in 2017.
Want a good value? Take a look at AMD's Am3+ platform in 2017. It's still widely available and has a lot to offer in terms of performance.
Here are step-by-step instructions for giving Lubuntu Linux a look that’s very close to Windows XP. The idea is to make the transition from Windows to Linux as easy as possible.
Best computer speakers under 100, best 2.0 and 2.1 computer speakers compared, know where to buy them cheapest
Dynamic charts in Excel change automatically if data it is added or removed saving you time and effort. They use a formula with the OFFSET and COUNTA functions and named ranges using Defined Names.
This article will talk about load balancing terminal servers with relation to Windows Server 2008 R2 servers.
The VLOOKUP function finds a value within a range of cells and returns information about that value. The TRUE / FALSE values allow you to choose whether Excel looks for an exact or approximate match.
If your data range contains many blank cells, it can be hard to correctly create a chart. Use the IF function to convert blank cells to #N/A which Excel ignores or change how Excel deals with blanks.
I was a PC user for over 30 years, but I recently switched to an Apple Mac Mini. I’ll tell you what I learned and what I needed to do to make the transition.
The 1st computer generation was characterized by current flowing through vacuum tubes. The 2nd, 3rd, and 4th via transistors, ICs, and microchips. The 5th operate on artificial intelligence.
RAM is one of the most easily upgrade components in any PC or Mac. Adding more RAM to your computer can bring a significant performance boost and doesn't have to be very expensive.
Do you still have your old 1980s Macintosh in the garage or attic? There's never been a better time to cash it in with this resale guide!
The Insert Function allows you to search for a function and easily create formulas. The Function Library groups all Excel 2007 and Excel 2010's functions in logical groups to make them easy to find.
Here’s how to install and use Google’s free remote access software to centrally control your remote computers.
The Excel 2007 / 2010 Rank and Percentile tool allows you to create ranking tables. In this hub we use Rank and Percentile with MATCH, INDEX and IF functions to create a fully automated ranking table.
Don't be fooled by the cable industry: There is no thing such as a HDMI Cable 4k or an HDMI 2.0 Cable. What you really need for Ultra High Definition TV is something else:
The Dell Latitude D430 is still a decent ultra portable notebook for basic web browsing, email and word processing needs for someone on the go, and upgrading the RAM in it can boost performance.
Upgrading the hard drive in your laptop can provide more space and also improve performance. This hub will demonstrate how to upgrade the hard drive in the Alienware M15x laptop with a solid state drive.
Trying to find the best parts to build a $1,000 gaming PC? Look no further. This Coffee Lake or optional Ryzen 5 build focuses on quality and performance.
Detailed step by step guide to creating a beautiful thermometer chart using Excel 2007. Starting with a 2D stacked column chart, each step is detailed throughout. Included are tips to remove the zero on the vertical axis and tips on creating the various shapes needed.
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.
If you upgraded to Windows 10 from a computer that came with Windows 7 pre-installed, reverting to Windows 7 will wipe out your product key and mark your operating system as "not genuine."
The CHOOSE function allows you to ask Excel to select an item from a list, add up or average a range of numbers by using CHOOSE with SUM or AVERAGE or to replace multiple nested IF statements.
If you are searching for the proper platform on which to play classic computer games, take a close look at Itronic’s GoBook III. This metal-clad monster meets stringent military standards.
Low input lag should be your first criterion when looking for the best gaming monitor for your console or PC gaming style.
Looking for the best processor for your gaming or photo editing computer? Here's a guide to the top AMD and Intel Processors of 2017 so far.
My selections for the best MacBook Pro cooling pads, suitable for the 13 inch version, including personal experiences.
If you're building a gaming PC and wondering what would be the best type of RAM for your gaming rig, then here's a look at my favorites. Also learn whether CAS Latency and Speed Matter for gaming.
Microsoft Excel is a very powerful tool that allows you to produce professional line graphs quickly and easily. It's possible to create professional and relevant graphs with the click of some buttons!
Want to build the perfect custom $2,000 gaming PC in 2017? Here's a fantastic computer build that's 4k and VR ready in 2017.
The price is right, but are Chromebooks good enough to do what you need them to do? Here are some of the pros and cons of Chromebook ownership.
Microsoft's withdrawal of support from Windows XP is forcing users to find an replacement. For those who can't or don't want to upgrade to Windows 7 or 10, Lubuntu Linux is a good alternative.
A Gantt chart in Excel 2007 or Excel 2010 is a Project Management tool that shows the progress of tasks over time. This hub shows how to create a 3D Gantt chart template from a stacked bar chart.
In this hub I'll explain how to create a bootable USB drive for installing pfSense. Installing pfSense from a USB memstick is faster and more convenient than using a CD. Using this method you can setup a new fully featured router for your network in no time.
Dropbox backs up files and syncs them between different devices. The free version offers limited online storage space, but this space can be easily increased.
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.
Guide to installing and configuring the shadow copy client on Windows 7, Windows Vista, Windows 2000 and Windows 98. Detailed Instructions for the configuration of Shadow Copy on a server running Server 2003. Demonstration of how to use Previous Versions to restore a deleted file or a deleted folder.
A bus is a common pathway through which information is transmitted from one component to another. This pathway is used for communication and can be established between two or more computer components
Tor, also known as The Onion Router, is a network of thousands of relays which can provide anonymous internet access. In this hub you'll learn how to install and configure a Tor Proxy on pfSense.
Heavy bandwidth users can slow down your entire network. This hub will show you how to use pfSense to set up traffic shaping to prioritize internet traffic.
Did you think that video card that died on you the other day is ready for the recycle bin? Let's not get ahead of ourselves. I'll show you how to bring that card back from the dead better than ever!
Have you ever tried to repair a "not recognized" USB flash drive? Well, learn how to fix a corrupted pen drive and fix other common USB problems to recover their data.
In this article, I go over the components of the entry level gaming PC I was challenged to build recently. I was quite surprised I could build a Coffee Lake i3 for under $500.
Shapes in Excel 2007 and Excel 2010 can be renamed and reordered using the Selection Pane. To save time, shapes can also be grouped so that they can be formatted, manipulated or moved together.
Dual WAN routers allow you to increase the internet bandwidth on your network by combining two internet connections. Using pfSense you can turn an old computer into a powerful multi WAN router.
Easy, step-by-step instruction on installing Ubuntu on VirtualBox. VirtualBox is an easy way to try out (or use) a new operating system on a virtual machine.
Wireshark is a very useful tool for capturing, and analyzing network traffic. This hub explains how to run Wireshark remotely over an SSH session to analyze traffic in real time. This method saves time because it doesn't require a capture file to be downloaded to another computer before it can be analyzed.
Toggle Buttons in Excel 2007 and Excel 2010 using Visual Basic code allow you to toggle or switch between two states; e.g. turning grid lines on and off, hiding or showing rows by clicking a button.
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.
Learn how to easily set up a captive portal using pfSense. Captive portals provide an easy way to authenticate users accessing the internet at Wi-Fi hotspots, hotels, apartments, or business centers.
A small church or business can connect their workers, wherever they may be, using a free online network based in the "cloud."
Browser extensions for Microsoft Edge are now available. Learn how to add the ones you need to super charge your favorite Windows web browser.
System software can be broken down into five categories. They are operating systems, device drivers, firmware, language translators, and utilities.
In this article, I give you a parts list for the December 2017 gaming PC build for enthusiasts. I discuss all components of this beastly gaming and productivity system on the Ryzen 7 platform.
The Pascal release is here and GPU prices are dropping. Here's a look at some good AMD and Intel CPUs to use in combination with these graphics cards for awesome performance.
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.
Outlook templates are a great time-saving tool. Any email you send regularly can be stored either in Outlook or on your computer as a template and re-used as often as you like to save you time.
It is important to know how to format a spreadsheet in Microsoft Excel as it can transform data into information. This article covers the basics of formatting an Excel spreadsheet.
The OM2P router is a high power, low cost WiFi router designed for quick and easy installations of WiFi networks. The OM2P features a 400 MHz processor & 64 MB RAM, dual SSID & zero configuration.
A good HTPC case can be hard to find. This is especially true when you're trying to make it into a Gaming PC. Here's a look at six good Mini and Micro ATX Computer cases for the money.
Building a PC for photo editing doesn't have to cost a fortune or take away your child's college fund. Here's a look at four builds for budgets of under $500 to $2,000.
Over time the clock on your computer can gain or lose several minutes. Correcting the time manually can be a daunting task, especially on networks with hundreds of computers. NTP allows you to automatically synchronize the clocks on all of the computers, and other devices on your network. In this hub I'll show you how to configure pfSense to function as an NTP server.
As wireless networks become increasingly popular, I look at the relative advantages and disadvantages when compared with wired networks.
Want to play WoW, Lol, and Dota 2? Here's a Cheap and good $150 to $200 budget Gaming PC build that has fantastic performance.
Finding the right Intel Kaby Lake motherboard for your i7-7700k or i5-7600k isn't difficult. Here are the best Under $200 Z270 chipset boards for your gaming PC
Looking for the right gaming keyboard for your RTS or FPS game of choice? Here's a look at the best mechanical keyboards available in 2017.
A good monitor for gaming has a low response time, low input lag, and a great picture. A responsive IPS monitor can provide you all three if you know where to look.
Replacing the backup battery in your AlphaSmart 3000, Neo or Neo2 is quite easy and can save a lot of heartache if you use your AlphaSmart to get a lot of writing done.
Looking for a good $500 Gaming PC? Why not build your own computer? Here's a look at the parts we'd recommend for a custom $500 Gaming PC.
This page is a tutorial on building a large / Citywide WiFi network/hotspot to make money. I am currently building a large WiFi network in my town so this will be a tutorial/diary.
Using Scroll Bars in Excel 2007 and Excel 2010 allows you to add visually appealing,easy to use and intuitive controls to your spreadsheets; users can then quickly and easily select a value using it.
This tutorial will go through the steps of installing Microsoft System Centre Operations Manager 2012R2 ( also known as Microsoft SCOM 2012R2 ).
When you can't scroll properly with your mouse, the cause can often be due to dust and fluff which has made its way into the wheel. This is really easy to clean with little effort