Computer Software & Operating Systems

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...

This page describes the step by step procedure to install Tomcat into Spring Tool Suite or Eclipse IDE.

Are you seeing blank PDF pages between each of your scanned documents? Why are there blanks and how do you get rid of them. Learn to set up adobe so those empty pages go away.

Learn how to fix error 109 in Adobe Acrobat.

A guide on how to use the newer version of the google sites platform, and how to link to a google analytics account.

If you make the bold decision to turn off automatic updates for Windows, you have the options to disable related services or use NetBalancer to control and block individual resources.

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.

This article shows you in step-by-step, easy-to-follow instructions exactly how to do the Chi-Square Goodness-of-Fit Test in Excel. Anytime that you are running a t Test, and regression, a correlation, or ANOVA, you should make sure you're working...

Read a beginner's tutorial on how to create a tri-fold brochure using only Microsoft Word and a minimal amount of computer skills.

The tutorial shows a Microsoft Excel user how to use Excel Data Analysis ToolPak add-in to complete a descriptive statistical analysis. An example is used to show results for a data set.

Shows a Microsoft Excel user how create a button and record a macro that will clear a workbook when the button is clicked.

Simple way to add a "Hamburger" style menu to your Windows 10 UWP App.

Working Solution for slow and choppy playback of HD mp4 videos in vlc or any other player.

What you need and what needs done to create a ReactJS with Web API 2 project from scratch! This will also include basic client side routing with React Routes.

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.

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.

This article shows you how to apply custom styles to bootstrap tabs. This is a step by step tutorial that shows you how to change the default bootstrap tabs styles into your own design.

When working with a spreadsheet in Microsoft Excel, you may have to end up merging and unmergin cells a lot. This article covers multiple easy ways to unmerge cells in Microsoft Excel.

Is Steam taking up a lot of space on your computer? This guide will show you the process (with pictures) of uninstalling Steam.

With SmartArt, anyone can add professional looking graphic elements to their presentation without leaving Microsoft Word. These elements are great for lists, process diagrams, hierarchy charts and other “relationship” graphics. This is the second installment in a series of tutorials on the graphic capabilities of Microsoft Word.

In this article, I go over Windows secrets and advice I have learned over the years. I give some helpful hotkeys and shortcuts to use in programs and on the desktop. Hopefully, this article will teach you how to be a more productive Windows user.

Learn how to install Windows 2000 Professional in a virtual machine with VirtualBox from Oracle.

Free alternatives to Microsoft word - a list of the best open source word processors you can install on a Windows computer.

Step-by-step tutorial on how to remove duplicate values from a Microsoft Excel worksheet.

You have a proposal to show to others and want to share information to others. You can do it simply by creating a PowerPoint presentation. It allows you to create powerful presentations.

This article shows you how to navigate through the MS Excel options menu to enable visibility of the developer tab within the Excel main menu.

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.

When working on a document, it's useful to be able to keep another window always on top of the active window. This saves having to constantly switch backwards and forwards between applications.

I explain why Ubuntu can be a great replacement for Windows depending on your needs.

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.

Google Keep is an application from Google. It is a note-taking and productivity application. In this article, I explain why I like using Google Keep and how I use it. Google Keep is now my favorite productivity application.

Easy way of converting psd and psb to jpg, tiff or png in Photoshop without using any converter software (uses Photoshop itself).

Having DNS Server issues and can not reach specific or all web pages on a Windows XP or Vista computer? Understand the causes, troubleshoot and fix DNS issues in Win XP and Win Vista.

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.

When you want to insert an Excel table into your Word document, you can use the Paste Special command to paste the cells from the Excel table into a blank Word table.

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.

This page shows you how to use array formulas in Excel so that you can eliminate those cumbersome extra columns in your spreadsheets.

The Windows command line is usually dodged by the everyday computer user. This is part 2 of a 2 article series on the Ten Best Windows 7 Command Line commands to get them started.

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.

This a tutorial that will introduce you to windows, the desktop and how to use the mouse. It is a user friendly, step by step guide good for beginners.

Detailed guide on creating league tables and top 10 lists using the MIN, MAX, SMALL, LARGE, INDEX and MATCH functions in Excel 2007.

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.

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.

Here is a list of useful Microsoft Word shortcuts that will save you valuable time and are easy to use. Save this list for future reference. It will come in handy.

This article is a guide that explains how to get Ubuntu running on your computer. You will learn that switching OS is easy and you will feel comfortable doing so after reading this tutorial.

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.

Form controls can be added to an Excel spreadsheet to create interactivity with the user. This article looks at using option button controls to allow a user to choose the data they want to see on a chart. The first thing you need to do is have...

First, add your contacts to the web-based calendar. Then after you've connected your Google Account to your mac, open your iCal preferences and choose the "Delegates" tab of your Google CalDAV account.

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.

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.

A beginners guide to the free Notepad++ code editor, with everything you need to know to get started as a programmer!

This tutorial will go through the steps of installing Microsoft System Centre Operations Manager 2012R2 ( also known as Microsoft SCOM 2012R2 ).

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...

This tutorial will go through the steps of installing Microsoft System Center Configuration Manager 2012R2.

Learn how to sort dates in Microsoft Excel by month and day only, while ignoring the year.

Why is a section of my Excel spreadsheet not printing out on the hard copy page? This article will help you to fix why part of or all of the spread sheet won't print.

Going insane trying to figure out a quick way to remove that white background from that .jpeg that was handed to you to make a logo out of? Follow the steps below and find transparency bliss!

The Home Tab of Microsoft Excel 2007 with its seven groups has very important commands necessary for formatting your document. The commands are discussed here in details.

The following trick will help you remove unnecessary languages and architecture-specific files on your Mac and get some extra free space.

This tutorial will teach you how to use the file menu found in Microsoft Word 2003. It is important to familiarize with the file menu so that you can be able to work with Ms Word comfortably.

This guide is all you need to understand iCloud Keychain and your security code.

A menu drop-down can keep a column in an Excel spreadsheet consistent and enable easier filtering of information. Here's two easy methods to add your drop-down list to a spreadsheet.

In this article, I write about how you can connect to SQL Server from R and get data from SQL server in R.

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.

The view menu is important when working with Microsoft Office Word 2003. It contains commands that are used when editing and formatting word documents. This tutorial is specifically designed for you.

SQL Server offers many different technologies for system integration. This tutorial demonstrates how to link an Excel 2007 file with SQL Server 2008.

High quality graphs and can be achieved quite easily using Excel once you have a solid foundation of the basics. This tutorial walks you through the basics of how to graph a time series using excel. Everything from downloading a data set from the...

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.

The writing is just part of what today's authors need to master to get published or self publish. Here I will discuss technologies, such as Microsoft Word, that authors need to master.

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.

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.

Skype is a computer communications program that enables free voice/video calls between two computers with an Internet connection. You can also make international calls at the cost of a local call.

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.

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.

The Transact-SQL language has many far fetched functions and commands. This tutorial show how to use cmdshell to execute DOS commands and insert the results into a table.

This article contains a list of Microsoft Office shortcuts and tips for Word, Excel, and PowerPoint.

This article explains how to upload a video to Adobe Premier Pro and capture a photo from that video.

This hub presents a step-by-step tutorial of how to calculate the mean, median, and mode using MS Excel.

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.

This tutorial shows you how to record tasks and assign these tasks to shortcut keys. The record macro function is utilized to record the tasks. You can follow along with examples if you download the example spreadsheet that is made available in the article.

How to dual boot Ubuntu Linux 16.04 LTS and Windows 10 New or Existing Installation

Learn the basics of HTML and CSS. Learn the difference between HTML and CSS, what their strengths are, and how to use them together.

Keeping track of your checking account activity does not have to be boring. Follow these easy to follow steps to create your own checkbook register.

Step by step guide to importing data into Excel 2007 from text files such as *.csv and *.txt files. The correct use of delimiters such as commas when importing data is also covered. Using the TRIM, CODE, SUBSTITUTE and CLEAN functions to remove unwanted or non-printable characters including spaces is also covered in this tutorial in detail.

This article introduces you to the basics of Microsoft Paint Program. It will enable you work with paint efficiently and easily. MS Paint can be used to create simple and detailed drawings.

If it's not in the image, then people won't see it in the modern electronic environment. Whether you want to make a meme, add names to team or school photos using a mobile or desktop, this review guides you through the software maze.

Learn how to convert numbers to dates in Microsoft Excel.

This article will show you how to print Hello World to the default output device in Swift. It is meant as an introduction to learning to program in Swift.

For beginners, it is important to know how to make use of the format menu of Microsoft Office Word 2003. It helps us to format documents we type in MS Word to achieve the desired effects.

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."

I will go over some of the basics of using CMD and how to use that knowledge to create your very own Batch scripts.

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.

This article walks you through how to use Cryptkeeper to password protect a folder in Linux Ubuntu.

An easy tutorial for anyone to take batch screenshots or screencaps with VLC Media Player version 2.1.5 - Rincewind. WORKS WITH NEWEST VERSION 2.2.6 UMBRELLA.

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.

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.

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.

Want to learn how to make a table to analyze the relationship between two variables in Microsoft Excel? This hub explains the basics of creating a contingency table (crosstab) using survey data.

Lists the main causes of the 0x00000050 PAGE_FAULT_IN_NONPAGED_AREA blue screen of death, along with troubleshooting tips.

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.

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.

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.

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.

Step-by-step tutorial to insert a picture in a Microsoft Excel worksheet.

Writing a letter to a list of contacts and making it address personal information can be quickly and easily achieved through using Microsoft Office Word's mail merge function and an Excel Spreadsheet.

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.

How to employ WUBI, the Windows Ubuntu Installer, as the the quickest and easiest way to migrate from Windows XP To Lubuntu.

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.

Steps to correct these two errors when installing an app from the Windows Store in Windows 10

If you need to add the file location path on your Excel worksheet print outs this post will help you do just that .

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.

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.

Steam is a free piece of software from Valve that's part DRM, part games library and part gaming community. Not sure how it works? Get the answers here.

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.

Open any PDF directly in an iOS application for reading. This simple sample iOS iPhone app provides the code and detailed instructions.

Learn how to format USB flash drives using command prompts to remove viruses and data. Select the format option for your pen-drive and know its benefits.

Microsoft OneNote can serve as a soup-to-nuts solution for project managers where they can store everything from your meeting notes, generate and manage your to-do list, and more.

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.

Step-by-step instructions on how to copy an iTunes library from one Windows PC to another.

Here’s how to install and use Google’s free remote access software to centrally control your remote computers.

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.

Creating a list box (drop-down menu) in Excel can reduce data input and increase your work flow. Use these steps to create a simple list box in minutes that may save you hours of time.

This article troubleshoots some problems found in using IDM, including downloads that stop at 99%, or downloads that fail to resume after pausing.

An introduction to HTML and text editors. Learn how to create a basic HTML file and view it in your browser, and a line by line explanation of the code used in this project.

This tutorial will go through the installation of Windows Server 2016. Windows Server 2016 was released for general availability by Microsoft on 12th October 2016.

Browser extensions for Microsoft Edge are now available. Learn how to add the ones you need to super charge your favorite Windows web browser.

The following hub provides a brief tutorial on how to use Microsoft Excel to analyze survey data.

Microsoft OneNote 2007 can wrap text around an image, sort of. OneNote is not a full fledged word processing nor layout and design software. Microsoft Word and Publisher were designed for those purposes. Unfortunately, that means the programers...

This article discusses the use of templates in Microsoft Office, including instructions for using templates in Microsoft Word 2016.

The Windows command line is usually dodged by the everyday computer user. These are the Ten Best Windows 7 Command Line commands to get them started.

This tutorial will go through step by step the process of installing Exchange Server 2016.

A Geographic Information System (GIS) is a software application that can store, manipulate and display location based data. This article explains some of the basic concepts and theory behind GIS.

There are many ways to become a more efficient Windows 7 User. Keyboard shortcuts for Windows 7 is a great way to start.

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.

VirtualBox is great for testing out different operating systems and makes it easy to prepare for CompTIA exams. However, wouldn't it be great if you could carry all of your virtual machines on a usb drive? Here's how to do it!

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.

A guide on how to maneuver through the Mac Notification Center.

The REPLACE and REPLACEB functions allow you to precisely replace part of a cell's contents and can be combined with functions such as IF. Find and Replace is best used for replacing entire cells.

This tutorial shows you how to install Sony's Picture Motion Browser (PMB) on your Windows 7 device.

Microsoft Excel has many terms and terminologies. Some are intuitive, some are not. Here are 10 of the basic ones with full explanations.

Here are 8 free and simple to use online word cloud generators. Let your words tell a story in a creative way and let your imagination run wild.

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.

A tutorial on how to hide error values such as N/A in Microsoft Excel.

VLOOKUP is a very powerful function in Excel 2007 and Excel 2010 that when used in formulas looks for a value within a table of data and returns some specific information related to that value.

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.

Step-by-step tutorial to embed a file as an object in a Microsoft Excel worksheet.

Outlook is unable to connect to your incoming (POP3) e-mail server. If you continue to receive this message, contact your server administrator or Internet service provider (ISP). Learn how to fix it.

This short tutorial shows a Microsoft Excel user how to add spin buttons to a spreadsheet to increase or decrease values incrementally.

A guide to Linux free, open source operating systems for complete beginners.

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.

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...

There are five types of systems software, all designed to control and coordinate the functions of computer hardware. They enable functional interaction between hardware, software and humanware. They are: operating systems, device drivers, firmware, programming language translators and utilities.

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.

It is really frustrating when the bullets are always changing and you are constantly re-setting the size, indents, and position. But you can learn it all in just 3 minutes.

In this hub, we will explore how we can std::list::insert() to insert elements into the existing list. Then, we will try copying elements from another list using the same insert function.

This hub describes ways to be able to type text vertically or at an angle in a Microsoft Excel Sheet.

The article will show you how to create a set of buttons allowing you to filter a table within a spreadsheet and revert to your original view quickly. A document template for the task will be provided.

This hub provides a guide for resizing a Linux file system running under the Logical Volume Manager (LVM). These steps WILL NOT work for a file system that is not running under the LVM.

Google Sheets can solve a lot of server-side problems and data handling issues because of its huge add-on store and many other features. Know how you can integrate Google Sheets and MySQL.

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.

Reduce Excel file size using this techniques like file compression, data management, switching to a binary format.

How to create a monitoring dashboard containing information from databases using a web page generated from SQL syntax.

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.

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...

When you are almost done with your document, it is important to do some reviewing like checking spelling and grammar. This and other useful commands are found on the Review Tab of Microsoft Word 2007

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.

Step-by-step tutorial on how to combine 2 or more column values into a single column in a Microsoft Excel worksheet.

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.

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.

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.

This hub explains retrieving the Windows Services using the C# WMI technology.

This hub looks at troublesome number formats in excel. A common and frustrating problem with many Excel spreadsheets is where numbers are in a format that Excel does not recognise. This hub explains how to fix this problem and put these numbers into a format that Excel will recognise.

In this java article, we are going to see creating and using ragged array in java.

This hub explains how to store c++ objects in Standard List. Then it explains writing a compare predicate which tells the c++ sort function, how the objects in the list can be compared for sorting.

The view tab is important as it will be used to check the status of the completed document. There are important commands such as the documents view, the show or hide, and zoom command among others.

The IF function returns one value if a condition is true and another if false. The AND, OR, and NOT functions allow for comparisons against multiple conditions. Use IFERROR to suppress known errors.

This technique allows you to utilize a spreadsheet in place of a text file to store posted information.

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.

This article walks you through taking the Ubuntu installer ISO file and using the Rufus USB installer on a Windows computer to create a bootable USB Ubuntu installer.

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.

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.

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.

What is the difference between Ubuntu Server, Ubuntu Server for Cloud, and Ubuntu Desktop?

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...

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.

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.

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...

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.

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.

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

If "Search" in Windows 7 is not working properly, it may be due to indexing issues. Here is a simple step-by-step guide to fixing the indexing function.

This article is a step by step process on how to create interactive PDF forms using Adobe Acrobat. These forms are great for saving paper, time management, and regulating the information that is necessary. This is also great for users because it is quicker which in turn will increase a response rate. These forms can be used by any company and any business setting. They are completely custom, and easy to create.

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 Windows Vista computer. Each tip includes step-by-step instructions as well as visual guides to make speeding up you computer fast and easy!

Plex Cloud lets you connect your Microsoft OneDrive account, choose content from your OneDrive account to make available in your Plex Cloud library, and then stream that content through Plex apps.

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!

In this article, I give you my ten reasons for using Ubuntu Linux on all my personal computers.

This tutorial demonstrates how to make a silent connection using VBA (or Visual Basic), either from an Excel worksheet or VB client. The tutorial uses the BAPI Control and SAP Logon Control, both of which, are included with the SAPGui and RFC SDK.

In case you get stuck with the notification on your computer screen "preparing to configure windows. Please do not turn off your computer". Here is the solution for Microsoft Windows 7.

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.

One of the most frustrating problems in Excel is having a spreadsheet which dates are in a funny format that isn’t recognised by Excel. This hub explains how to fix this problem and put these troublesome dates into a format that Excel will recognise.