How to Install Adobe Photoshop CS5 Full Version

If you’re looking for an image editing suite it will not matter whether you’re using Windows or Mac OS on a 32 bit machine or a 64 bit machine, Adobe Photoshop will be your first choice. Photoshop is such a powerful program that even older versions of the program can match most tasks. Adobe Photoshop CS5 was released in 2010 meaning people having been running it on old operating systems like Windows XP, Windows 7 and Windows 8 for years. Despite...

Read More

How to Install Adobe Photoshop CS6 Full Version

If you have arrived here that means that you are looking for an image editing suite. We are sure that there’s 99% chance that you were looking to download a free full version of the great Adobe Photoshop CS6. And we understand that. Adobe Photoshop is the clear choice when you want an image editing suite, no matter if you are using Windows or Mac OS or if you have a 32 bit machine or a 64 bit machine. The bad news is that Adobe...

Read More

Adobe Photoshop 7.0.1 Update

Essential update for Adobe Photoshop 7.0.1 Free DownloadSafe download Photoshop has been the industry leading image editing suite for years. If you’re interested in checking out some of the older versions Photoshop why not check out our introductions to Photoshop 7.0, Photoshop CS5 and Photoshop CS6 articles. Adobe Photoshop 7.0.1 Update is a update package for Photoshop 7.0.1 that corrects bugs and...

Read More

Use the PROPER function to capitalize names in Excel

When you think about Excel functions, you probably think about performing calculations with numbers. While it's true that you can use functions to do lots of handy things with numbers in Excel, some functions can help you format text too. One good example is the PROPER function, which capitalizes the first letter of every wordin a cell. If you have cells containing proper nouns, like names or titles, you can use the PROPER function...

Read More

CONCATENATE: Excel's duct tape

MacGyver used it. The Apollo 13 crew used it. Whenever people are in a bind and need to stick two things together, they reach for the duct tape. But what you may not know is that Excel has a built-in function that does pretty much the same thing: CONCATENATE. CONCATENATE lets you combine two or more things in one cell—and despite the long name, it's actually easy to use. It works the same way in all versions of Excel, as well as...

Read More

Use SUMPRODUCT to calculate weighted averages

Excel makes it extremely easy to calculate the average of several cells: Just use the AVERAGE function. But what if some of the values have more "weight" than others? For example, in many classes the tests are worth more than the assignments. For these situations, you'll need to calculate the weighted average. Although Excel doesn't have a weighted average function, it does have a function that does most of the work for you: SUMPRODUCT....

Read More

How to count cells with COUNTA

You may already know Excel can perform calculations with numbers. But did you know it can also perform calculations with other types of information? One of the simplest examples of this is the COUNTA function. COUNTA simply looks at a range of cells and tells you how many of the cells contain data. In other words, it looks for nonblank cells. This can be useful in a variety of situations. If you've never used Excel functions, check...

Read More

Microsoft Office

Whether you’re completely new to Microsoft Office or are just looking to refresh your skills for a potential job or the one you’re already in, you’re in the right spot. Our lessons offer a mix of text, video, interactives, and challenges to practice what you’ve learned, so you can learn the basics and more of Access, Excel, Outlook, PowerPoint, Publisher, and Word. You’ll also learn tips, tricks, shortcuts, and more to better use these programs...

Read More

Excel Formulas: Functions

Introduction A function is a predefined formula that performs calculations using specific values in a particular order. All spreadsheet programs include common functions that can be used for quickly finding the sum, average, count, maximum value, and minimum value for a range of cells. In order to use functions correctly, you'll need to understand the different parts of a function and...

Read More