Web Analytics


Windows Guides Feed

Excel Formulas for Summarizing Data across Worksheets

Posted by Rich On March - 15 - 2011

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 »

3 Great “Payware” Programs Are Now Freeware

Posted by Thomas On March - 9 - 2011

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 »

What is a Software Easter Egg? (With Examples)

Posted by Rich On February - 21 - 2011

windows easter eggSome 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 »

EXCEL: Create a PullDown Menu [Quick Tip]

Posted by Thomas On December - 16 - 2010

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 for December 2010

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 »

Enable Disk Quotas [Quick Tip]

Posted by Thomas On November - 27 - 2010

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 »


Computer tips in your inbox
Sign up for the Windows Guides newsletter to get PC tips and access to free Windows books (More details)

Enter your email address:
 

Popular Guides

See which sites have been visited on your PC (even if private browsing mode is used)

Create a Windows 7 System Repair Disc

Best Free Anti-malware

Hibernate vs. Sleep vs. Shut-Down

i3, i5, and i7; Dual, Quad, Hexa Core Processors. How to they Differ?

Intel's Ivy Bridge Processor: new Features

Submit Your Tip
Submit your computer tip to us; receive full credit for all published tips

Windows Guides on Facebook