MalekTips: 10-12-2007
 
Welcome to the latest issue of the MalekTips newsletter, providing computer and technology help and tips. We appreciate your subscription!
 
We have 30 new tips found below in the latest issue of MalekTips. Just scroll down this web page to view and click on the tips!
 
* Tweak how Internet Explorer 7 opens websites requested by other software. Tired of hearing sounds when RSS newsfeeds are noticed on a webpage - turn them off! Plus, consider printing web pages in landscape mode.
 
* We have more tips for Microsoft Excel 2003. Count the number of cells that meet a given condition. Sum values only if a desired condition exists. Plus, perform trigonometric functions and convert numbers to Roman numerals.
 
* Diagnose errors when playing QuickTime movies on Windows systems. Are movies or music files stuttering? Does a white space appear instead of a movie? Also, change the types of files that, when double-clicked, automatically open QuickTime.
 
* Problems with Windows Media Player 11? Are DRM (Digital Rights Management) content files failing? Is multimedia streaming poorly over the Internet? Or what if you just need to downgrade back to Windows Media Player 10?
 
* Toggle various folder-related options in Windows XP. Change a folder's type. Toggle labels in the Toolbar. Toggle popup tooltip descriptions. Toggle thumbnail caching. Plus, learn how to order online prints from photos inside a given folder.
 
* Tweak mouse settings in Windows Vista. Having trouble finding the mouse? Is the mouse wheel scrolling too slow or not fast enough? Tired of seeing your mouse pointer disappear as you type?
 
Remember - if you have a computer question, be sure to visit the MalekTips forums at http://www.malektips.com/forums
 
Andrew Malek
MalekTips.Com
 
* Tell a Friend! *
 
Don't keep all these great tips to yourself - be sure to tell a friend about what's available, at no cost, on MalekTips.Com, and please pass this newsletter along! Let them know they can sign up to receive notifications regarding new tips added to the site.
 
Point them to the following web address to sign up and read past newsletters online: http://malektips.com/maillist
 
* New Tips News Feed! *
 
Is your e-mailbox getting full?
 
Instead of getting new MalekTips tip announcements via e-mail, you can get them on your AOL, Google, MSN, or Yahoo! personalized homepage! Or, view the new tip announcements in your RSS reader or RSS-supported web browser!
 
For more information, visit:
 
http://malektips.com/rss/
 
* Tips! *
 
Microsoft Internet Explorer 7 : Change How Links from Other Programs Are Opened
Configure in Internet Explorer if links from other applications are opened in tabs or new windows.
 
Microsoft Internet Explorer 7 : Increase Accessibility by Ignoring a Website's Design
Having trouble browsing webpages in Internet Explorer 7 because you cannot read the text? Accessibility options may help.
 
Microsoft Internet Explorer 7 : Toggle Resetting the Zoom Level to 100%
Configure whether or not Internet Explorer 7 should reset the zoom level on new windows and tabs.
 
Microsoft Internet Explorer 7 : Switch Page Layout to Landscape
Print web pages from Internet Explorer 7 in landscape mode.
 
Microsoft Internet Explorer 7 : Toggle Playing Sounds When RSS Feeds Are Found
Toggle whether Internet Explorer 7 plays a sound when it finds feeds related to the current webpage.
 
Microsoft Excel 2003 Functions and Formulas : Using Excel to Convert to Roman Numerals
Need to convert MM to 2000? Use this Excel function.
 
Microsoft Excel 2003 Functions and Formulas : Trigonometric Functions
Use Excel to perform sine, cosine, tangent, and other trigonometric functions.
 
Microsoft Excel 2003 Functions and Formulas : Exponentiation
Two ways to raise numbers to powers inside Microsoft Excel 2003 spreadsheets.
 
Microsoft Excel 2003 Functions and Formulas : Count the Number of Cells That Meet a Condition
Count the number of cells in a range that meet a specified criterion.
 
Microsoft Excel 2003 Functions and Formulas : Find a Conditional Sum
Use Microsoft Excel 2003 to find the sum of numbers that meet a certain condition.
 
QuickTime for Windows : Movies Play too Jerky
Perform this tweak if QuickTime movies play haphazardly, stopping and starting too often.
 
QuickTime for Windows : Manually Check for Updates
Manually check to see if any updates are available for QuickTime for Windows.
 
QuickTime for Windows : Movies Display a White Screen or Error Message
If QuickTime or iTunes movies show up as a white screen or with an error message, try these tips.
 
QuickTime for Windows : Change File Types Opened by QuickTime
Change the list of file types that will cause QuickTime for Windows to be opened automatically.
 
QuickTime for Windows : Sound Stutters or is Distorted
If audio played in QuickTime for Windows or iTunes sounds stuttered, try this tweak.
 
Windows Media Player 11 : Streaming Media Playing Poorly?
If streaming media files in Windows Media Player 11 start and stop constantly, try this tip.
 
Windows Media Player 11 : Play Media Randomly
Activate the Shuffle playback mode in Windows Media Player 11.
 
Windows Media Player 11 : Rolling Back to Windows Media Player 10
Want to downgrade your Windows XP machine to Windows Media Player 10?
 
Windows Media Player 11 : Clear the Player History
Clear the history of files opened by Windows Media Player 11.
 
Windows Media Player 11 : Cannot Play DRM (Digital Rights Management) Protected Content
The following articles may assist if you are having difficulty playing protected DRM content in Windows Media Player 11.
 
Windows Vista - Mouse : Change Settings Related to the Mouse
Access the Mouse Properties to change mouse-related behavior on your Windows Vista system.
 
Windows Vista - Mouse : Toggle Pointer Trails
Toggle whether the mouse pointer should display trails, which may make the mouse pointer easier to see.
 
Windows Vista - Mouse : Find the Pointer Easily with a Keypress
Having difficulty locating the mouse pointer on a Windows Vista system? This tweak may help.
 
Windows Vista - Mouse : Wheel Scrolls Too Fast or Not Fast Enough
Toggle the scrolling speed of wheel mice on Windows Vista systems.
 
Windows Vista - Mouse : Toggle Hiding the Mouse Pointer When Typing
Configure Windows Vista to hide the mouse pointer as you type, or disable this behavior.
 
Windows XP and Explorer : Change the Folder Type
Configure Windows XP to provide special functions for folders containing pictures, music, video, or general documents.
 
Windows XP and Explorer : Remove / Add Labels to/from Toolbar Functions
Explain what the toolbar buttons in Windows XP Explorer folders do, or if you're an expert, remove all such descriptor text.
 
Windows XP and Explorer : Show / Hide Popup Tooltip Descriptions for Folders and Desktop Items
Show or hide text Windows XP displays when hovering over folders or items on your desktop.
 
Windows XP and Explorer : Order Online Prints from Photos
You can order prints of photos inside Windows XP Explorer folders.
 
Windows XP and Explorer : Toggle Caching Thumbnails And Creating Thumbs.db Files
Toggle whether or not you want Windows XP caching thumbnails for pictures inside Explorer folders, creating thumbs.db files in the process.
 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
* Copyright Notice *
 
This newsletter can be redistributed, in electronic or print, provided that no changes are made to this document and this notice is left intact. If you wish to redistribute just pieces of this newsletter, such as certain articles, contact Andrew Malek for information.
 
The MalekTips newsletter is published by Envision Programming:
 
Envision Programming attn: MalekTips PO Box 11592 Knoxville, TN 37939-1592
 
This issue of MalekTips is Copyright 2007 Andrew Malek of Envision Programming. All other copyrights and trademarks are properties of their respective companies.

Note that due to tip recategorization, some of the URLs mentioned in the newsletter may have changed. If you have any problems finding a particular tip, use the MalekTips "Search" feature to conveniently find what you are looking for.

New in MalekTips: