PCSTATS Main Page Follow PCSTATS on Facebook PCSTATS RSS Feed PCSTATS Twitter Feed + Motherboards
+ Videocards
+ Memory
+ Beginners Guides
News & Advanced Search  Feedback?
[X]   Directory of
Guides & Reviews
The PCstats Forums

Beginners Guides
Weekly Newsletter
Archived Newsletters

Contact the Suite 66 Advertising Agency

Waterfield Designs Muzetto Leather Notebook Satchel Review
  More Waterfield Designs Reviews... and Notebooks.
Kingston SSDNow V300 240GB SATA III SSD Review
Beginners Guide: How To Install / Remove an Intel Socket LGA2011 CPU
Seagate Backup Plus Slim External USB 3.0 2TB Hard Drive Review
Beginners Guides: 99 Performance Tips for Windows

Tips RSS News Feed - PCSTATS
... 0 news stories awaiting approval  
Tech Tip: Enable Concurrent Desktop Sessions in Windows
     Fri, Jan 06 2012 | 1:30P | Tips | PermaLink
Posted by: STAFF
Remote Desktop in server editions of Windows by default supports two concurrent connections to remotely troubleshoot or administer a computer. However, there are a few reasons why concurrent sessions would come in handy for power users not necessarily running a server. For example, if you have a dedicated Media Center PC running in the living room, you'll be able to remotely access all files on the machine without interrupting the person watching TV. Or if you are sharing a computer with other users, concurrent Remote Desktop sessions will allow more than one person use that system under a different or even the same user account, without kicking each other off.

PCSTATS TechTip... Sort an Excel spreadsheet by email domain?
     Wed, Aug 24 2011 | 4:15P | Tips | PermaLink
Posted by: STAFF

PCSTATS TechTip... Sort an Excel spreadsheet by email domain?

Q: I need to update my websites' news mailing list and remove duplicates, how do I sort the email list in Microsoft Excel by the domain names only? By default Excel sorts everything in front of the @ symbol alphabetically, I need to sort alphabetically everything following the @ sign. Help!

A: By using Data > Sort in Excel it is possible to do this, but first we'll need to pre-format the email mailing list somewhat.
First off, assuming all your email address are listed in Column A (one email address per row), create a second Column in the Excel document so we can use a formula to output only the data following the @ sign in Column A;
=MID(A1, FIND("@",A1, 1)+1, 255)
Paste the above formula into the first cell of Column B, as you'll see, this formula outputs only the domain part of the email address. Click on that cell and hover the mouse over the bottom right-hand corner of the box until you see the cursor turn into a "+" sign. Now click and drag the checkered box down to the very last row of data to copy the formula across all rows.

Next, select all your data by highlighting Column A and Column B in the margins, then go to Data > Sort > and under 'column' choose 'column B' and press 'okay'. This will tell Excel to sort all the data, alphabetically by the domain names in Column B, from there you can easily find and remove the duplicates.


Etymotic Research Custom Tips by ACS
     Mon, Apr 18 2011 | 4:00P | Tips | PermaLink
Posted by: STAFF
"Etymotic earphones may already be a pricy proposition for the average consumer, but the discerning listener is aware of the importance of a good seal in obtaining the best sound quality from an in-ear earphone. Is it possible that a mere set of eartips can be worth the $100 asked by ACS and Etymotic for the service? I decided to lay my own ears on the line and find out."

     Tue, Apr 12 2011 | 3:15P | Tips | PermaLink
Posted by: STAFF

In case you missed the PCSTATS Newsletter this week, we're reposting this little TechTip here in the news. You can catch the next PCSTATS Newsletter, if you're still alive, by subscribing here.

This is one of those tech topics we've been meaning to touch on for quite some time, but it's not the cheeriest of subjects..... so let's tackle this with a dose of humour. Prior to the internet things were pretty easy after you kicked the bucket - your photos, home movies, telephone contacts, correspondence, little black book and everything else were solely in a physical form. A quick dig through a closet or shoe box would reveal the mundane and the scandalous, and life was easy for the newly departed.

Crucially, and unlike every online repository today, this collected material could just sit around and happily gather dust for decades. Today these same snippets of life are often digitally stored by third parties on servers with virtual countdown-to-erasure clocks hanging over six digit password protected accounts. Or worse yet, until the IT company goes belly up. At the very least, your own computer may chocked full of family history - you know, the PC that holds everything that only you have the login for?

On the plus side, shoe boxes don't wipe out all your Kodachrome prints if you forget to open them for a couple years, nor cite privacy policies if your relatives go snooping around after you die. Online email accounts, photo and social networking services are certainly the modern equivalent of an empty Converse shoe box, but see how far you get trying to crack a deceased relative's account open.

Get the drift? We store thousands of emails and family photos on the internet, while social networking sites like FB catalog the mundane day-to-day records of our lives. Ditto times ten for home computers and notebooks. All of this is protected while we're alive and kicking by passwords, privacy clauses and encryption nine ways from Sunday.

The key to Managing Your Digital Death is having the foresight pass along these keys to the collected works of YOU, on. Assuming you do, want to pass this information on that is. A list of websites and login details written down on a sheet of paper & kept up to date is usually sufficient. It may be wise to include the lost password questions/answers too... This paper should be stored somewhere very safe along with other important personal papers. Just be sure to tell a trusted family member these details exist and possibly where they're kept.

We'd like to hear what you think about this subject and your suggestions for Managing your Digital Death, so please drop us a line.


Windows 7 Jump Lists Fix and Tricks
     Mon, Feb 14 2011 | 4:34P | Tips | PermaLink
Posted by: STAFF
When Windows 7 made it out the door reactions were mixed about the operating system's revamped taskbar. Now two years later I can personally attest to the improved usability of the new bar and above all else, the magnificent implementation of jump lists. Depending on the application jump lists can be used to get 1-click functionality without recalling a minimized window, easily access common tasks or to quickly open pinned and recent documents, saving you time not having to go through a number of dialogs. In a nutshell, if you are willing to make the most of them, jump lists are a productivity godsend.

Driver Sweeper may prevent you from installing service packs
     Fri, Jan 28 2011 | 4:02P | Tips | PermaLink
Posted by: STAFF
"If you're using Driver Sweeper to clean up drivers on Windows 7, be aware that Driver Sweeper may prevent you from installing service packs. Driver Sweeper wipes Windows 7's built-in display drivers, which are considered as "system files". Service pack 1 and upcoming service packs run integrity check on system files, and if it detects any missing files – it won't let you install and display the following error message: Service Pack Installation Cannot Continue (one or more system components that service pack requires are missing)."

Tech Tip: Speed Up Firefox by Loading Tabs On-demand
     Sat, Jan 08 2011 | 12:00P | Tips | PermaLink
Posted by: STAFF
Firefox users who are used to having fifteen or more tabs open while surfing the web, or perhaps tend to load up their browser with a bunch of open pages from their last session, will surely know the impact this can have in terms of performance. It may not be a major issue on powerful desktop PCs with processing muscle and memory to spare, but you can bet more modest rigs and most laptops will struggle trying to pull up a huge list of pages at the same time. Luckily, there are ways heavy tab users can ease the memory-guzzling effect that their browsing habits can have on their systems – and today we’ll specifically mention two: using the BarTab extension or making a quick about:config tweak.

Tips NEWS PAGE: of 3    
Hardware Sections     11/30/2015 | 12:07PM  
Beginners Guides
RSS Newsletter
RSS News
Mouse Pads
Cases and Access.
Computers / SFF PCs
Cooling - Heatsinks
CPU / Processors
Digital Cameras
Home Theatre
MP3 Players
Technology Content    
Beginners Guides: 99 Performance Tips and Tweaks for Windows
Beginners Guides: 99 Performance Tips and Tweaks for Windows
Feb 25 | Beginners Guides
Beginners Guide: Hi-Resolution Panoramic Images with MSFT ICE
Beginners Guide: Hi-Resolution Panoramic Images with MSFT ICE
Jan 27 | Beginners Guides
Samsung ATIV Book 9-Lite NP915S3G-K01 13.3-inch Touch Screen Notebook Review
Samsung ATIV Book 9-Lite NP915S3G-K01 13.3-inch Touch Screen Notebook Review
Dec 23 | Notebooks
Seagate FreeAgent GoFlex TV HD Media Player Review
Seagate FreeAgent GoFlex TV HD Media Player Review
Nov 25 | Home Theatre
Beginners Guide: Install/Remove Intel Socket LGA1156 CPU and Heatsink
Beginners Guide: Install/Remove Intel Socket LGA1156 CPU and Heatsink
Nov 18 | Beginners Guides
Beginners Guides: Repairing a Cracked / Broken Notebook LCD Screen
Beginners Guides: Repairing a Cracked / Broken Notebook LCD Screen
Oct 02 | Beginners Guides
A broken or cracked LCD screen makes a laptop utterly useless, good thing PCSTATS can show you how to replace that busted laptop screen with a minimum of fuss and for less money than a service center charges. PCSTATS will be fixing a cracked LCD screen on a Lenovo T530 ThinkPad notebook, the general procedures outlined here work for any notebook though.
Gigabyte GA-X79-UD5 Intel X79 LGA2011 Motherboard In-Depth Review
Gigabyte GA-X79-UD5 Intel X79 LGA2011 Motherboard In-Depth Review
Jul 27 | Motherboards
The Gigabyte GA-X79-UD5 is an awesome 'Sandy Bridge-E' motherboard for anyone in the business of content creation, yet still nimble enough to take on multi-videocard gaming and overclocking at the end of a days work.
Seagate Constellation ES 1TB Enterprise Hard Drive Review
Seagate Constellation ES 1TB Enterprise Hard Drive Review
May 29 | Hard Drives
All Constellation ES drives are rated to 6Gb/s SATA III speeds, incorporate 64MB of cache, utilize 7200RPM spindle speeds and offer Native Command Queing. The drives are covered by an impressive 5 year warranty and rated to1.2 million hours MTBF.
MORE » Complete PCSTATS Article and Review Listings...

The best Guides by the best writers on the internet; PCSTATS Beginners Guides explain computers, software, and all those other wonderful things that cause you frustration.

Learn how to use your computer better, master the internet while protecting yourself, and know what to do when your hard drive kicks the bucket.

  1. 10 Steps to a Secure PC
  2. 101 Tips and Tweaks for Windows XP
  3. 104 Killer Tech Tips for Windows XP
  4. 99 Performance Tips for Windows XP
  5. 99 Windows Vista Performance Tips
  6. Annual PC Checkup Checklist
  7. Assembling Your Own PC
  8. Back up and Restore Data in WinXP
  9. Browser Hijacking and How to Stop it
  10. Building a Home Theatre PC / HTPC
  11. Burning CDs and DVDs
  12. Cloning WindowsXP
  13. Converting Videotape Into Video Files
  14. Crash Recovery: The Blue Screen of Death
  15. Creating a Weblog / Blog
  16. Creating MP3 Music Files
  17. Decrypting Lost Document & Zipped File Passwords
  18. Diagnosing Bad Hard Drives
  19. Diagnosing Bad Memory
  20. Downgrading Windows Vista Back To Windows XP
  21. Dual OS Installation of WindowsXP 32-bit/64-bit
  22. Encryption and Online Privacy
  23. Ergonomics & Computers
  24. Flashing a Video Card BIOS
  25. Flash Memory Data Recovery and Protection
  26. Firewalls and Internet Security
  27. Firewall Setup and Configuration
  28. Forgotten Passwords & Recovery Methods
  29. Formatting and Partitioning a Hard Drive
  30. Fundamentals of Upgrading a PC
  31. Hard Drive Data Recovery
  32. Home Networking and File Sharing
  33. How to Install: Intel Socket 775 CPU and Heatsink
  34. How to Install: Intel Socket 1366 CPU and Heatsink
  35. How to Install: Intel Socket 1155 CPU and Heatsink
  36. How to Install: AMD Socket AM3 CPU and Heatsink
  37. How to Install: AMD Socket FM1 CPU and Heatsink
  38. How to Fix Homesite Design Mode to Work in WindowsXP/ Vista
  39. How To Make a Budget Desktop Computer on the Cheap
  40. How to Update a Motherboard BIOS
  41. Installing RAID on Desktop PCs
  42. Installing Windows Vista
  43. Installing Windows XP
  44. Internet Connection Sharing
  45. Legally Copying Software and Music
  46. Linux Part 1: Getting Familiar
  47. Linux Part 2: Installing a PC
  48. Linux Part 3: New Software
  49. Little Known Features of WindowsXP
  50. Making Old Software Compatible with Windows Vista
  51. Making DVD Movies from Video Files
  52. Most Common Ways to Kill a PC
  53. Optical Drives & Recording Formats
  54. Overclocking the CPU, Motherboard & Memory
  55. Overclocking the Videocard
  56. Preventing Data Theft from a Stolen Laptop
  57. Printer Sharing on a Home Network
  58. Quick Guide for Eliminating Spyware and Hijacker Software
  59. RAM, Memory and Upgrading
  60. Registry: Backups, Repairs, and Protection
  61. Remote Access to Computers
  62. RSS Feed Setup & Subscriptions
  63. Safe Mode in Windows Vista For Crash Recovery
  64. Setting up an FTP Server in WinXP
  65. Slipstreaming WindowsXP with Service Pack 2
  66. Spyware Protection and Removal
  67. Stopping Spam
  68. Stopping Vista From Thrashing Hard Disks to Death
  69. Synchronizing Files and Folders
  70. Unattended Windows 2000/XP Installations
  71. Understanding & Creating Batch Files
  72. Understanding & Tweaking WindowsXP Services
  73. Upgrading A Motherboard Without Reinstalling
  74. Upgrading Win98 to Windows XP
  75. USB Memory Drive Projects & Tips
  76. VPNs and Internet Connection Security
  77. Website Hosting From A Home PC
  78. Website Hosting With Apache
  79. Windows Vista Crash Recovery and Repair Install
  80. Windows XP Command Prompt
  81. Windows XP Safe Mode Explained
  82. Wireless Home Networking
  83. Wireless Network Security
"Get the 'Stats and Stay Informed!"

Frostytech's Top 5 Heatsink Comparison Charts

Recommended Tech Resources:

The PCstats Forums
PCstats Network Features Information About Us Contact
PCSTATS Newsletter
ShoppingList Assistance
Tech Glossary
Technology WebSite Listings
PermaLink News
Archived News
Submit News (Review RSS Feed)
Site Map
PCSTATS Wallpaper
About Us
Privacy Policy
Advertise on PCSTATS

How's Our Driving?
© Copyright 1999-2015 www.pcstats.com All rights reserved. Privacy policy and Terms of Use.