An easy way to protect sheets is to create a "Login" for your workbook, this can easily be achieved using VBA. Explained for people who know nothing about VBA, this guide will help you create a Login
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.
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.
The binary numbering system is the basis for storage, transfer and processing of data in computers and other electronic systems. It uses base 2 rather than base 10 which we are normally familiar with
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!
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.
A robot.txt file allows you to keep search engines from listing your online files. Here are some tips to help you set up a robots.txt file on your website.
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.
Computers have become an integral feature of our daily lives. This article lists 20 examples of ways that computers are used.
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.
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.
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.
Best computer speakers under 100, best 2.0 and 2.1 computer speakers compared, know where to buy them cheapest
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.
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.
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.
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.
Improve wireless performance on slow browsing computers. Learn what negatively effects wireless and solutions to overcome slow internet browsing. Speed up the internet.
Port forwarding (NAT) allows users on the internet to access services running on a computer inside your home network. This hub explains how to set up port forwarding using pfSense.
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.
Here’s how to install and use Google’s free remote access software to centrally control your remote computers.
Looking for the right graphics card to pair with your CPU? We take you through Processor and graphics card combos for every budget.
Whether you want to use, design, or improve a database application, understanding a few key ideas such as data types, indexes, and normalization can help you identify and share system requirements.
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.
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.
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.
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 five builds for budgets of under $500 to $2,500.
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.
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.
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.
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! Best of all you have roughly a 30% chance of success, which is pretty good for a piece of garbage!
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.
Traffic shaping (QoS) is no longer something only expensive commercial routers can do. An inexpensive home router with custom firmware like Tomato can prioritize certain types of traffic quite well.
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.
There’s plenty of free backup software available, but this solution is even better because you’ve already got it as part of the Windows operating system! All you need is to do is to write a few lines of commands to create a Windows batch file. You can even make it run on a schedule.
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.
This tutorial will go through the necessary post-installation tasks to make the Exchange Server able to send and receive e-mails with the outside world.
Have around $600 in your budget for your gaming PC? Here are the top parts we recommend for quality and performance.
Review of HP Envy 15t, 15 inch laptop with FHD IPS WLED- backlit screen. 6th Generation Intel Core i7 processor 6500; 8GB Ram memory; 256GB SSD storage;Windows 10. Comparable to Dell Inspiron 15 7000
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.
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 2019.
Want a good motherboard for your Coffee Lake system? Here's a look at our favorites from under $150 to $500.
Shortcuts are all about efficiency. If you are a Mac or Apple user, you know that keyboard shortcuts make work so much easier. Learn the most useful tips and tricks to navigate and get the job done on your computer.
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.
Kali Linux is a powerful distribution designed for penetration testing. This article explains how to create a bootable USB drive that can be used to run Kali.
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.
Game development has become much easier than it was a decade ago. Some of the best game creators offer an excellent toolset.
These are the different computer types; supercomputers, mainframe, mini and microcomputers. They are classified according to their size, power, and performance.
This tutorial shows how to configure a Remote Desktop Client to use a Remote Desktop Gateway. It shows how to configure the Remote Desktop client on both Mac and Windows. It also shows how to use a Self-Signed SSL Certificate with the Remote Desktop Gateway.
My selections for the best MacBook Pro cooling pads, suitable for the 13 inch version, including personal experiences.
Many tutorials are geared toward PC users. Mac users are often left on their own. Here are 3 methods to capture a screenshot for Mac users. GIMP, is a great free GNU Image Manipulation Software that can be used to capture a screenshot on a Mac or PC.
Low input lag should be your first criterion when looking for the best gaming monitor for your console or PC gaming style.
As wireless networks become increasingly popular, I look at the relative advantages and disadvantages when compared with wired networks.
Learn how to highlight your PDF documents with a PC or Mac. You can use Adobe on your PC or Mac or use a program online for free. Scanned documents are more difficult to edit and highlight but there are some ways around it.
This article considers the history of computer storage and some of the facts behind the need to keep regular backups of our most important files and folders.
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.
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
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.
What's Happening With Flash? By the end of 2020, Adobe will no longer support, update and distribute the flash player plug-in. What should you do if you have content published in Flash? Read more...
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.
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.
Are you a noob at using a MacBook? Have you just recently switched to a Mac OS platform? Then this list of Top 39 Mac Keyboard Shortcuts is made just for you! Why use an off-number? Well, I did start with 45 but realized the other 6 were unnecessary.
How to employ WUBI, the Windows Ubuntu Installer, as the the quickest and easiest way to migrate from Windows XP To Lubuntu.
Want a good value? Take a look at AMD's Am3+ platform in 2019. It's still widely available and has a lot to offer in terms of performance.
If you find your Windows Vista PC or laptop to be too slow, here are ten easy and simple tips that you can follow to dramatically increase the performance of your computer. Each tip includes step-by-step instructions as well as visual guides to make speeding up your computer fast and easy!
This tutorial will show how to install Remote Desktop Services in Windows Server 2016 but it can be applied to Windows 2012 or Windows 2012R2. The steps are based on a scenario where there is currently no Remote Desktop Services for Windows 2012 or later installed in the domain.
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.
Why pay a high price for a computer monitor when you can use an HDTV for a lot less. Here’s what I learned from my research when searching for a good monitor for my desktop computer.
This tutorial will go through the steps of implementing a Remote Desktop Gateway on a Windows Server 2016 server. A Remote Desktop Gateway is often used to allow remote desktop clients to connect from the internet to servers behind the Remote Desktop Gateway located on the corporate network.
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.
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.
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.
In this article, I review and benchmark the PowerColor Red Dragon RX Vega 56 graphics card. I test this card in 5 games from 5 different genres of gaming. How did it perform? Read on and find out.
This article looks at computer hardware. It explains what hardware is, what distinguishes internal components from external components, and lists 20 examples of hardware.
I compare using Ubuntu to Windows 10. I go over if this is something people will want to do or not. I also my own Ubuntu usage.
In the pre-digital era, keeping any artifacts that you might want to share with your grandchildren was a matter of putting them in a box. For digital photos, videos and documents it's a lot more complicated. This article helps you decide how to do it.
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.
The new Apple Reminders app can be a great GTD app if you set it up the right way. Discover how getting things done digitally can be more fun than ever before.
Check boxes can be used to create visually striking but easy to use lists including To Do lists in Excel 2007 / Excel 2010. This hub covers how to create, configure, edit, copy and align a check box.
This article will talk about load balancing terminal servers with relation to Windows Server 2008 R2 servers.
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.
Marie Kondo can deal with your physical stuff but what about your computer? What's taking up all the space? Find out how to clean up storage on domestic computers and in the workplace.
There are many reasons why your WiFi may seem slow on certain devices or in certain parts of your home or apartment. Here are some great fixes and products to help get the speed you are paying for!
You’re on a budget, yet you want a laptop equipped with the best mobile processor for your needs. Do you go for an 8th gen Intel Core i5 or Core i7? This guide compares CPUs and provides answers.
The advent of digital technology has brought with it many many great advantages, here I list 16 of the main ones.
A small church or business can connect their workers, wherever they may be, using a free online network based in the "cloud."
Finding similar but not identical photos can help you pick the best of a group of the same scene. For text documents, you can find the latest version, the original Word document from which you obtained a PDF or all the slight variants of an email that you sent. There's a lot of software to help.
This article will show you how to consolidate data from a variety of devices into a single drive, how create a backup strategy for all your data, and how to securely dispose of the old devices while ensuring the data within them won't be accessible by any future owners of those devices.
Pivot tables within Microsoft Excel help you summarize large amounts of data quickly and efficiently. They are very easy to use and format and can be refreshed very quickly if the data changes.
Making slideshows from a collection of photos and videos? There's lots of software for this. Read on to find out which to use.
Want to play your favorite AAA titles in 1440p and 4k? Here's a good desktop gaming PC build that is more than capable.
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.
Photo or video editor on a budget? Here's a look at 4 top editing monitors for budgets of just under $500 in 2019.
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.
File tagging can help you find electronic documents by browsing their tags and by letting them be in more than one place a time. There’s a lot of software to help you add tags to electronic documents and then retrieve them by tag. But they aren’t all equal.