Windows Tools, Help & Guides

Microsoft Security Essentials (MSE) has been around for some time and has proved to be a popular, free anti-virus program. In this guide, I’ll show you how to configure MSE, what all the options mean, and some advanced tips to make the program run optimally for you.

Read the rest of this entry »

If you use your laptop or tablet on battery power, you’ll know how annoying it is to lose battery power at the “worst time”. While I can’t guarantee your PC will lose power at a more convenient time, I can offer 14 ways to improve your battery life. Learn, in this guide, how to save power when running on batteries.

Note: This guide is written for Windows 7 but most tips apply for Windows Vista

Read the rest of this entry »

Windows Forums member, Bert_H, asked the following question in our suggestion box:

[I’d like] an explanation on i3, i5, i7 Operating Systems, and how they compare with Core 2 and Quad Core CPUs.

Update: Manuel commented asking the following:

It seems core2 duo CPUs have not been included and where they belong. Are core 2 duo CPUs comparable with i3s or even i5s? thanks.

Scroll down or click here for the answer.

If you’re in the market to buy a PC and you’re looking for the best value for money, you’ve likely asked yourself: “what’s the difference between Dual and Quad Core and which should I buy, i5, or i7?”

This guide offers a basic explanation of these processors and will help you determine the best for your needs.

Read the rest of this entry »

In my last article (An Explanation of the Pros and Cons of Using RAID on Your Computer), we discussed the problem of heat build-up during the very hot Auckland summer months and how a RAID 5 configuration with 4 disks can sustain the failure of a single disk. RAID protections provide one part of what should be an overall strategy to protect your data and your computer from heat.

In this piece we divert a bit from our standard hardware/software fare and look at the computing environment as a whole. We will postulate that a tidy workspace is, in fact, a happy workspace and suggest a few tricks to make your work-space more productive and more comfortable.

The three biggest factors driving the design of my workspace are heat, noise and clutter. If I can minimise these three and maximize my computing power and productivity (all within family budget constraints, of course), I will have archived the objective.

Read the rest of this entry »

In this guest article, Joseph Reese shows us some Excel formulas to help us summarize data across worksheets. Find out more about Joseph at the end of this post.

In this article you will discover a neat way to summarize data across Excel sheets without having to reference each of them. This technique will work even if you add a new sheet.

Defining a Range of Sheets

Consider the following example: The fictitious expense reports for the equally fictitious XYZ Widget Company’s various offices. Each sheet in the workbook contains the expense data for each of the company’s offices. Below you can see the expense data for the New-York office:

The Expenses workbook holds a similar sheet for the Chicago and LA offices.

Read the rest of this entry »

Last week, we shared some commands you can run (from the Run box/Start menu) that can save you time and get you to the tools you need quickly. If you missed it, here it is: Use Start Menu/Run Dialog Commands to Access Windows Programs and Tools.

This week, we’ll point you to some of our previously-written guides that include keyboard shortcuts that you can use in Windows and in a couple of popular programs. If we’re missing any shortcuts or programs with shortcuts, let us know in the comments.

• General Windows Shortcut Keys

Read the rest of this entry »