How to Do the Max Function in Excel 2010
Excel 2010 is a very powerful spreadsheet program, and it includes so many features that there are some that even advanced users might not use …
Programs
Assorted guides for various applications including:
You can also visit our Application Guides page for a full list of applications for which we have written guides.
Some of our most popular articles in this category are:
How Do I Get to the iTunes Media Folder
The iTunes media folder is the folder location on your Windows PC where your iTunes media files are stored. If you open this folder, you …
How to Create a Control Panel Icon on the Desktop in Windows 7
The Control Panel is an extremely useful set of tools that you can use to customize nearly every setting or experience on your computer. But, …
How Do I Restore Taskbar to Bottom of Screen in Windows 7?
You may be wondering how to move the taskbar to the bottom of the screen if you have turned on your computer and found that …
How to Hide the Recycle Bin from the Desktop in Windows 7
People use their desktops in Windows 7 in a variety of ways. Some people like to save everything to their Desktop because they know how …
How Do I Combine Multiple Columns Into One Column in Excel 2010
Microsoft Excel 2010 spreadsheets provide a great way for you to separate related data so that you can sort and edit some information without affecting …
Paste Data as a Picture from Excel 2010 to Word 2010
Microsoft Office products, such as Word and Excel, are generally pretty compatible with one another. If you need to get data from one program to …
Reading Pane or Preview Panel is Gone in Outlook 2010
When you use Outlook 2010 throughout most of your workday, you start to get used to the way it appears whenever you open the program …
Change AutoRecover File Location in Word 2010
If you have been using Microsoft Office programs for a while, then you know that certain situations can occur, such as a power outage or …
How to Uninstall a Program in Windows 7
Whether you have been using your Windows 7 computer for a long time, or have just purchased a brand new computer, you will inevitable need …
How to Spell Check Uppercase Words in Powerpoint 2010
Spell check and grammar check tools are so common in programs and applications today that I take them for granted. While I consider myself to …
How to Manually Run Windows Update in Windows 7
The Windows Update feature helps to provide you with updates that are available for your operating system. Typically it will install these updates at convenient …
Download Pictures Automatically in Outlook 2010
Dealing with emails can be a risky proposition. There are a lot of ways that a malicious spammer or malware creator can get your email …
How to Save Powerpoint File as a Word Document
Microsoft Powerpoint and Word each have their own particular strengths. Sometimes, however, the audience for which you are creating a file might want that file …
How to Merge Multiple Word Files in Word 2010
Some people like to work on different parts of a large document as entirely separate documents. This allows for individual parts of the file to …
How to Change the Amount of Memory that Photoshop CS5 Uses
If you have a computer with a lot of memory, then you might be excited to see how well Photoshop performs on it. But if …
How to Remove a Program Icon From the Taskbar
You might have heard the term “taskbar” before if you were trying to solve some problems with your computer, but you might not be familiar …
Change How Your Name Appears in Outlook 2010
You might discover that you need to change your send name in Outlook 2010 if the name that people see when they receive your email …
How to Add a Drop Shadow in Photoshop CS5
If you need to make an advertisement or an image that showcases a physical product, then there are a lot of different ways that you …
How to Turn a Presentation into a Video in Powerpoint 2010
You may find that you need to turn a Powerpoint presentation into a video if you are going to be giving that presentation somewhere and …
Add a Password to a PDF in Photoshop CS5
When you are working in Photoshop CS5 to create images or designs for clients, you might find yourself working with images or information that need …
Fixing Small Text When Composing Emails in Outlook 2010
We’ve all been in situations where we accidentally hit a key or combination of keys on our keyboard and something drastically changed on our screen. …
How to Change a Port Setting in Windows Live Mail
Windows Live Mail is a great free desktop email management program that is included with Windows 7. It is very efficient at configuring popular email …
Stop Windows 7 Laptop Computer from Going to Sleep
While it’s easy to understand why most laptop users would want their computers to automatically go to sleep after a certain time in order to …
How to Use a Gradient as a Background in Powerpoint 2010
Have you ever seen a gradient Powerpoint background and wondered how the slideshow creator got it? While they might have downloaded and set that picture …
Excel Guide to Removing Duplicates from a Spreadsheet
When you are importing data from another source, or you are working with a large spreadsheet that is continuously updated with new records, you can …
Set Selected Cells as Print Area in Excel 2010
Sometimes when you are working with a large spreadsheet you might encounter a situation where you need to print some of the data in the …
Move the Dropbox Folder Location on Your PC
Dropbox is a very popular cloud storage application, and one of the reasons for this popularity is because of the number of devices on which …
Increase AutoRecover Frequency in Excel 2010
Many people that have been using Excel for a significant period of time are likely to have an unpleasant memory where their computer crashed, or …
How to Unlink a Local SkyDrive Folder
Microsoft’s cloud storage application can be configured with your Windows computer so that a folder on your computer syncs with your online storage. But you …
How to Show Page Breaks in Excel 2010
Microsoft Excel 2010 data is typically best viewed on your computer screen. Unfortunately, it just is not always possible to force someone to view it …
Change the Default Gridline Color in Excel 2010
The gridlines in Microsoft Excel 2010, whether the ones that you are printing or the ones on your screen, are a key element in keeping …
How to Make a Picture Bounce in Powerpoint 2010
Powerpoint 2010 is a program where you need to create material to grab your audience’s attention. This is particularly true of audiences that might watch …
Take a Screenshot in Microsoft Word 2010
Screenshots are a helpful way to show someone something on your screen, particularly if it is something that might be difficult to find or recreate. …
How to Restore Default Search Options in Windows 7
The search feature in Windows 7 is very useful, largely because you can customize it to include specific folders or drives, then further customize it …
Stop Automatically Selecting Entire Word in Powerpoint 2010
While Powerpoint 2010 is primarily a visually-focused program, you will need to do some text editing while you are using the application. Thankfully Powerpoint employs …
Change the Color of Highlighted Search Terms in Outlook 2010
When one of your Outlook 2010 folders gets too large, it can be difficult to locate a specific message that you need. Fortunately, Outlook 2010 …
Change the Number of Recent Documents in Excel 2010
Microsoft Excel 2010 provides some convenience features meant to improve the usability of the program. One of these options is the list of documents on …
How to Embed Fonts in Word 2010 Files
Most Windows 7 computers come with a similar list of fonts that are installed on them by default, and this is the list of fonts …
How to Remove Gridlines from View in Excel 2010
If you have been using Excel for a while, then you have probably become accustomed to the way that it looks. The layout of the …
How to Hide Row and Column Headings in Excel 2010
The numbers and letters at the top and left side of your Excel 2010 spreadsheet are called headings. They are a helpful way to identify …
How to Average a Group of Cells in Excel 2010
Microsoft Excel 2010 has a lot of tools that you can use to easily accomplish tasks that Excel users commonly perform. While many of these …
How to Uninstall SkyDrive
Your Microsoft SkyDrive online cloud storage account includes a feature called SkyDrive for Windows that will install a local folder on your Windows 7 computer. …
How to Show the Preview Panel at the Right Side of a Folder
If you are unhappy with the appearance of your folders in Windows 7, then there is no reason to continue using settings that you dislike. …
Configure the Fetch Files Setting in SkyDrive
Microsoft’s SkyDrive cloud storage service is a good solution for storing your files remotely. It has a free option with a lot of storage space, …
How to See the File Size of a Folder in Outlook 2010
When you connect your email account to Microsoft Outlook 2010, the program will start downloading email messages from your email server to your computer. This …
Switch to Full Screen Mode in Photoshop CS5
Effectively using Adobe Photoshop CS5 to edit or create high resolution images will eventually require you to zoom in pretty close to the image. Whether …
How to Split Data in One Column to Two Columns in Excel 2010
Correctly formatted data is very important when you are trying to get information into a database or if you are working with a formula in …
Select a Color Range in Photoshop CS5
There are many options available to Photoshop CS5 users when it comes to making a selection. For example, you can change the default rectangular selection …
How to Feather a Selection in Photoshop CS5
There is a lot you can do with a selection in Adobe Photoshop CS5. We have detailed ways to change the shape of the selection …