-
How to find duplicates in Excel
You'll need more than one trick up your sleeve to find duplicates in Microsoft Excel.
-
Create an Excel data table to compare multiple results
Suppose you want to view multiple possibilities within an Excel calculation. The answer is to create a data table.
-
Regain hard disk space by using Windows Update Cleanup in Windows 7 and 8.x
Disk Cleanup's Windows Update Cleanup weeds through the WinSxS folder and eliminates unnecessary files. Learn how to use the feature in Windows 7 and 8.x.
-
It's Microsoft Patch Tuesday: January 2014
Here's the information you need to make the right deploy decisions when applying Microsoft's January 2014 patches in your organization.
-
![]()
Restore a Windows XP backup in Windows 8
Learn how to get Windows XP's Backup Utility to run in Windows 8 so that you can restore a backup.
-
![]()
December Office tip mailbag: a complex Excel SUMIFS() function
Susan Sales Harkins helps a reader hash out a SUMIFS() solution with several criteria values across multiple sheets and the obligatory monkey wrench.
-
![]()
Set up a PC as a kiosk using Windows 8.1's Assigned Access
Learn how to use Windows 8.1's Assigned Access feature to configure a local user account to essentially function in kiosk mode.
-
![]()
10+ dos and don'ts for using Office templates
If your attempts to use Office templates usually leave you feeling stumped and frustrated, read these expert tips to gain a better grasp on how to use them.
-
![]()
Hightail: a robust alternative to Dropbox
If you want a share-centric cloud file host service, our reviewer says Hightail delivers the features you need at a great price.
-
![]()
How to replace SkyDrive with Libraries in Windows 8.1
Learn how to move SkyDrive and reinstate Libraries as the primary location for accessing documents and pictures in Windows 8.1.
-
![]()
Add an exit strategy to bullet points in a PowerPoint slide
It's easy to display bullet points one at a time. It's just as easy to get them to disappear, if you know the right properties to alter.
-
![]()
Survey: What's next after Windows XP?
Windows XP support is ending in April, and Tech Pro Research is conducting a survey to find out what companies are planning to do next.
-
![]()
Top 10 Windows articles of 2013
Windows 8 tips about taking screenshots, shutting down, and restoring your hard disk are among the most-read Windows articles in 2013.
-
![]()
Pro tip: Use an optical Recovery Drive in Windows 8.1
If you're wondering whether you can create a Recovery Drive on an optical disc in Windows 8.1, Greg Shultz says the answer is yes and no. Find out what he means.
-
![]()
Pro tip: Dismiss Excel's irksome Auto Fill Options list with these tricks
Learn how to reduce the annoyance factor of Excel's Auto Fill Options list.
-
Poll: Is cost, time, or something else preventing you from dropping Windows XP?
Windows XP is still the prominent operating system in many organizations and we would like to know why.
-
Deal with the SecureBoot isn't configured correctly watermark in Windows 8.1
A pair of very simple PowerShell commands will help you determine why the SecureBoot isn't configured correctly watermark is appearing on your desktop.
-
Quick Tip: Excel 2013 offers flexible data labels
Data labels can display more than values now. Use them to display a message or even the result of a formula not in the chart's underlying data set.
-
October Office tip mailbag: Outlook settings and Excel conditional formatting
Susan Sales Harkins helps a reader find an old setting in a new version of Outlook and provides a unique Excel's conditional formatting rule.
-
![]()
Review: TeamViewer Touch for remote connections
If you are a Windows 8/RT tablet user that wants a tablet-optimized means to access other systems remotely, TeamViewer Touch is worth a try.
-
![]()
Review: ESET Smart Security 7
If you are looking for an all-in-one security package that gives Microsoft's basic protection a run for its money, you might want to consider ESET's Smart Security 7.
-
![]()
Get the ISO you need to create your own Windows 8.1 DVD
Here is the complete procedure for downloading a Windows 8.1 ISO using a Windows 8 product key.
-
![]()
Quick Tip: Change Microsoft live to a local account in Windows 8.1
Since the Windows 8.1 update, I have been asked many times how to change a Microsoft live account into a local account without losing data. Here is how you do it.
-
![]()
Two PowerPoint 2013 user tips for working more efficiently
Improved smart guides and resume reading are two easy-to-use features in PowerPoint 2013.
-
![]()
Step-by-step: Update to Windows 8.1 through the Windows Store
Greg Shultz walks you through the entire Windows 8 to Windows 8.1 upgrade procedure using the Windows Store.
-
![]()
It's Microsoft Patch Tuesday: November 2013
Tony Bradley gathers the information you need to make the right deploy decision when applying Microsoft's November 2013 patches in your organization.
-
![]()
Three simple steps to providing better customer support
Providing customer support is not a piece of cake. It requires patience along with good communication and people skills to run an efficient support business.
-
![]()
How Windows 8 Hybrid Shutdown / Fast Boot feature works
Sleep, hibernate, fast boot, and hybrid shutdown are not all the same thing in Windows 8. Greg Shultz explains how it all works.
-
![]()
Recover from a dead RAID0 with Bootsect and DiskPart
Recovering from a dead hard drive in a RAID0 configuration may require a little old-fashioned command line knowledge.
-
![]()
Pro tip: Calculate the current page number within a section in Word
Microsoft Word fields support most page numbering schemes, unless you want to display the current page number within a section. For that, you'll need this special technique.