Windows Tools, Help & Guides

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 »

It’s not very often we get to see commercial products going freeware. Can you imagine this happening to Adobes Photoshop or Microsoft’s Office ? I think not. There are of course hundreds of freeware programs out there that will give you some or most of the same functionality, and now, we can add three more to the Best Freeware list.

Thanks to freewaregenius for pointing these out to us.

And the newcomers are…

Read the rest of this entry »

Some programs and media come packed with secret “goodies” called Easter eggs. These are fun little additions, added by programmers, that can be found by accident, by completing some tasks, or by hearing about them from other people. In this article we will find some of those Easter eggs. Specifically, we’ll cover:

• What is an Easter Egg?
• What an Easter Egg is Not
• Easter Egg Examples

Read the rest of this entry »

I’m starting a new series here, which involves daily usable tips for different programs. This time I’m going to show you how to create a usable Drop Down Menu in Excel. In this mini-tutorial I am using Excel 2010, but the steps are pretty much the same no matter which Office Version you use. The main difference is where you find the different tools, and where possible I will try to mention where things differ.

Creating a usable Pull-down Menu

If you use Excel on a day-to-day basis filling out forms and information, you might find yourself typing in the same information over and over. Either by typing it in or using copy and paste. When filling in forms you will normally use the same cells over and over (this is where we can use Pull-down Menus). Pull-down Menus can also control your Excel document in different ways like retrieve information or navigate between Sheets and Documents.

Read the rest of this entry »

Microsoft Security Bulletin Advance Notification issued: December 9, 2010
Microsoft Security Bulletins to be issued: December 14, 2010

This is an advance notification of security bulletins that Microsoft is intending to release on December 14, 2010.

This bulletin advance notification will be replaced with the December bulletin summary on December 14, 2010. For more information about the bulletin advance notification service, see Microsoft Security Bulletin Advance Notification.

To receive automatic notifications whenever Microsoft Security Bulletins are issued, subscribe to Microsoft Technical Security Notifications.

Microsoft will host a webcast to address customer questions on the security bulletins on December 15, 2010, at 11:00 AM Pacific Time (US & Canada). Register now for the December Security Bulletin Webcast. After this date, this webcast is available on-demand. For more information, see Microsoft Security Bulletin Summaries and Webcasts.

Read the rest of this entry »

If you have a shared computer in your household or office you may experience that the free space on the hard drive gets smaller and smaller. Especially if you have a Tweens (Teens using the computer filling it up with music, pictures, downloads etc.) using it. There is a way to make sure every user has enough storage space – Disk Quotas.

Here’s How:

Read the rest of this entry »