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 its age, however, it is still a really powerful piece of software so it is definitely worth knowing How to Download Adobe Photoshop CS5.

These days Adobe run a subscription based service meaning there is no real need to buy the program outright or for an installer or a setup exe file. Also there are new procedures to follow regarding how to obtain and how to use serial numbers.

Why Install Adobe Photoshop CS5 Free Full Version?

A free download of a full version of Adobe Photoshop CS5 gives you access to a plethora of cool Photoshop features. CS5 has a number of great features and tools including:

• Content-Aware Fill
• Refine Edge
• Mixer Brush
• Bristle Tips
• Puppet Warp

Other community led additions to Photoshop CS5 included:

• Automatic image straightening,
• The Rule-of-Thirds cropping tool,
• Color pickup
• 16-bit image saves as a JPEGs.

Also, for ease of use via improved file management and browsing Adobe Photoshop CS5 also includes the Adobe Mini Bridge, which allows for seamless file management and browsing.

Adobe Photoshop CS5 System Requirements

Windows

• Intel® Pentium® 4 or AMD Athlon® 64 processor
• Microsoft® Windows® XP with Service Pack 3; Windows Vista® Home Premium, Business, Ultimate, or Enterprise with Service Pack 1 (Service Pack 2 recommended); or Windows 7
• 1 GB of RAM
• 1 GB of available hard-disk space for installation; additional free space required during installation (cannot install on removable flash-based storage devices)
• 1024 x 768 display (1280 x 800 recommended) with qualified hardware-accelerated OpenGL graphics adapter, 16-bit color, and 256 MB of VRAM
• Some GPU-accelerated features require graphics support for Shader Model 3.0 and OpenGL 2.0
• DVD-ROM drive
• QuickTime 7.6.2 software required for multimedia features

Mac OS

• Multicore Intel processor
• Mac OS X v10.5.7 or v10.6
• 1 GB of RAM
• 2 GB of available hard-disk space for installation; additional free space required during installation (cannot install on a volume that uses a case-sensitive file system or on removable flash-based storage devices)
• 1024 x 768 display (1280 x 800 recommended) with qualified hardware-accelerated OpenGL graphics adapter, 16-bit color, and 256 MB of VRAM
• Some GPU-accelerated features require graphics support for Shader Model 3.0 and OpenGL 2.0
• DVD-ROM drive
• QuickTime 7.6.2 software required for multimedia features

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 Photoshop CS6 was released back in 2012 and it runs on old systems such as Windows XP, Windows 7, Windows 8 and Mac OS X v10.6.8. You won’t find Adobe Photoshop CS5 anymore. At least not legally.

Don’t worry. Adobe is still going it is just that nowadays it runs as a subscription based service. This means that you don’t need to buy the program anymore and you don’t need an installer or a setup exe file. This also means that you’ll always have the most advanced Adobe Photoshop version ready for your service.

×

Was it Worth it to Download and Install Adobe Photoshop CS6 Full Version?

A download of the full version of Adobe Photoshop CS6 gives you access to a plethora of cool Photoshop features. CS6 has a number of great features and tools including:

• Content-Aware Patch
• Adobe Mercury Graphics Engine
• New and Re-engineered Design Tools
• Intuitive Video Creation
• Blur Gallery

Post-launch patches included additions to Photoshop CS6 such as:

• Vector Shapes
• Updated User Interface
• “Liquify” filter
• Layer styles/Blending Options dialog

Also, the Adobe Photoshop CS6 Extended version included exclusive features like the Mercury Graphics Engine, which is a powerful engine for optimizing 3D imagery; new controls for more efficient 3D workflows and new effects such as reflections and dragable shadows.
So, was it worth it to download Adobe CS6? Yes, yes and ten thousand times yes.

Adobe Photoshop CS6 System Requirements

Windows

• Intel® Pentium® 4 or AMD Athlon® 64 processor
• Microsoft® Windows® XP with Service Pack 3 orMicrosoft Windows 7 with Service Pack 1. Adobe® Creative Suite® 5.5 and CS6 applications also support Windows 8 and Windows 8.1. See the CS6 FAQ for more information about Windows 8 support
• 1 GB of RAM
• 1 GB of available hard-disk space for installation; additional free space required during installation (cannot install on removable flash-based storage devices)
• 1024 x 768 display (1280 x 800 recommended) with 16-bit color and 512 MB (1 GB recommended) of VRAM
• OpenGL 2.0–capable system
• DVD-ROM drive
• This software doesn’t operate without activation. Broadband Internet connection and registration are required for software activation, validation of subscriptions, and access to online service

Mac OS

• Multicore Intel processor with 64-bit support
• Mac OS X v10.6.8 or v10.7. Adobe Creative Suite 3, 4, 5, CS5.5, and CS6 applications support Mac OS X v10.8 or v10.9 when installed on Intel-based systems
• 1 GB of RAM
• 2 GB of available hard-disk space for installation; additional free space required during installation (cannot install on a volume that uses a case-sensitive file system or on removable flash-based storage devices)
• 1024 x 768 display (1280 x 800 recommended) with 16-bit color and 512 MB (1 GB recommended) of VRAM
• OpenGL 2.0–capable system
• DVD-ROM drive
• This software doesn’t operate without activation. Broadband Internet connection and registration are required for software activation, validation of subscriptions, and access to online service

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 leaves your Photoshop functioning better than ever.

After the release of any program bugs will crop up sooner or later. Even if they aren't very serious, they can still hinder your work. Photoshop 7.0.1 is no exception. Adobe Photoshop 7.0.1 Update eliminates these problems and brings improvements such as:
- Fixes scale errors
- Improves compatibility with QuarkXPress
- Accelerate the opening of multiple windows
- Stores JPEG metadata correctly
If you use Photoshop 7.0.1, the Adobe Photoshop 7.0.1 Update is an essential download.

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 to make sure everything is capitalized correctly. The PROPER function works in Google Sheets too.

For example, let's say your company wants to give someone a lifetime achievement award. You've asked your coworkers to enter their nominations for the award into this spreadsheet:

Unfortunately, you can see that not everyone has been careful to capitalize the first and last names of the people they want to nominate, so the spreadsheet looks messy. You could go through the column and correct the names manually, but using the PROPER function will be faster and easier.

In this example, the names of the nominees are in column A, so we'll put our formula in column B. In cell B2, we'll type a formula that tells Excel to capitalize the name in cell A2, which contains the first name on our list. The formula will look like this:

=PROPER(A2)

As you may remember from our Simple Formulas lesson in our Excel Formulastutorial, it's important to make sure you start any Excel formula with an equals sign. Once you've entered the formula, press the Enter key, and cell B2 will display the name from A2 with the correct capitalization: Thomas Lynley.

Now all we have to do is click and drag the fill handle through cell A14, and column B will display all of the names in the list with the correct capitalization:

Great! Now all the names of the award nominees are correctly capitalized in the spreadsheet. There's one problem, though: We still have the original uncapitalized names in column A. We can't delete column A because our formula in column B refers to it. Instead, we can copy the values from column B into a new column by using the Paste Values feature in Excel.

To do this, select cells B2:B14 and click the Copy command (or press Ctrl+C on your keyboard). Then right-click the cell where you want to paste the values (C2, for example), then select the Values button from the menu that appears. If you're using Google Sheets, you can right-click and go to Paste special > Paste values only.

Now we have a column that displays the corrected names but that doesn't depend on a formula or cell reference. This means we can delete our original columns (column A and column B). There we have it: a nice, neat spreadsheet with all the names of the nominees correctly capitalized.

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 in other spreadsheet applications like Google Sheets.

If you'd like to follow along, you can download our example spreadsheet. Note: If you've never used Excel functions before, you may want to check out our Functionslesson from our Excel Formulas tutorial first to learn the basics.

Combining names

Let's say we have a spreadsheet of contact information with last names and first names in separate columns, and we'd like to combine them to get each person's full name. In the image below, you can see that the first names are in column B and the last names are in column A. Our formula will go in cell E2.

Before we start typing the formula, there's one important thing you need to know: CONCATENATE will combine exactly what you tell it to combine, and nothing more.If you want punctuation, spaces, or any other details to appear in the cell, you'll need to tell CONCATENATE to include it. In this case, we want the names to have a space in between them (so it doesn't say JosephineCarter), so we'll need to add an argument that contains a space. This means we'll need three arguments:

• B2 (first name)
• " " (a space in quotation marks)
• A2 (last name)

Now that we have our arguments, we can type the following formula into cell E2:

=CONCATENATE(B2, “ ”, A2)

Just like any function, the syntax is important. Make sure to start with an equals sign, and separate each argument with a comma. Note: Depending on where you live, you may need to separate the arguments with a semicolon (;) instead of a comma.

That's it! When you press Enter, it should display the full name: Josephine Carter.

Now you can click and drag the fill handle down through cell E11, and it should display the full name for each person.

If you'd like an extra challenge, try using CONCATENATE to combine the city and statein column F so it looks like the image below.

Combining numbers and text

You can even use CONCATENATE to combine numbers and text. For example, let's say we're using Excel to keep track of a store's inventory. We currently have 25 apples in stock, but 25 and apples are in separate cells. We want to combine them into one cell so that it looks like this:

To do this, we'll need to combine three things:

• F17 (number in stock)
• " " (space)
• F16 (product name)

Type the following formula into cell E19:

=CONCATENATE(F17, “ ”, F16)

Let's say we want it to say We have 25 apples. We'll just need to add an argument at the beginning that says We have:

=CONCATENATE(“We have ”, F17, “ ”, F16)

If you wanted to, you could add even more arguments to create more complex statements. Just keep in mind that the syntax always needs to be exactly right, or the formula may not work—and it's easier to make a mistake with a longer formula.

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. Even if you've never used SUMPRODUCT before, you'll be able to use it like a pro by the end of this article. The method we're using works with all versions of Excel, and it also works with other spreadsheet applications like Google Sheets.

If you'd like to follow along, you can download our example.

Setting up the spreadsheet

In order to calculate the weighted average, you'll need at least two columns. The first column (column B in our example) contains the grades for each assignment or test. The second column (column C) contains the weights. A higher weight will cause the assignment or test to have a greater effect on the final grade.

You can think of the weight as being the percentage of the final grade. But in this case, the weights actually add up to more than 100%. That's OK because our formula will still work no matter what the weights add up to.

Entering the formula

Now that we have our spreadsheet set up, we'll add the formula to cell B10 (any empty cell will work). As with any formula, start by typing an equals sign (=).

The first part of our formula will be the SUMPRODUCT function. Because the arguments will be in parentheses, go ahead and type an open parenthesis:

=SUMPRODUCT(

Next, we'll add the arguments to the function. SUMPRODUCT can have any number of arguments, but it will usually have two. In our example, the first argument will be the cell range B2:B9—the cells that contain our grades:

=SUMPRODUCT(B2:B9

The second argument will be the cell range C2:C9—the cells that contain the weights. You'll need to use a comma to separate these two arguments. When you're done, type a closed parenthesis:

=SUMPRODUCT(B2:B9, C2:C9)

Now we'll add the second part of our formula. This part will divide SUMPRODUCT by the SUM of the weights. Later, we'll talk about why this is important.

Start by typing a / (forward slash) for division, and then type the SUM function:

=SUMPRODUCT(B2:B9, C2:C9)/SUM(

We just need one argument for the SUM function: the cell range C2:C9. Remember to close the parentheses after the argument:

=SUMPRODUCT(B2:B9, C2:C9)/SUM(C2:C9)

That's it! When you press Enter on your keyboard, Excel will calculate the weighted average. In our example, the final grade is 83.6.

How it works

Let's look at each part of this formula to see how it works, starting with the SUMPRODUCT function. SUMPRODUCT is multiplying (finding the product of) each assignment's grade times its weight, then adding all of the products together. In other words, it finds the sum of the products, which is where it gets its name. So for Assignment 1 it multiplies 85 by 5, and for the Test it multiplies 83 by 25.

If you're wondering why the values needed to be multiplied in the first place, think of it this way: The assignments with a higher weight are counted more times. For example, Assignment 2 is counted 5 times, but the Final Exam is counted 45 times. This is why the Final Exam has a bigger impact on the final grade. By comparison, a "regular" average would count each assignment one time, so each one has the same weight.

If you could look "under the hood" of the SUMPRODUCT function, you would see that this is what it is actually calculating:

=(B2*C2)+(B3*C3)+(B4*C4)+(B5*C5)+(B6*C6)+(B7*C7)+(B8*C8)+(B9*C9)

Luckily, we don't have to write a long formula like this because SUMPRODUCT is doing all of it automatically.

By itself, SUMPRODUCT will give us a huge number: 10,450. This is where the second part of our formula comes in: /SUM(C2:C9). This part brings the value back down to a normal grade range, making the answer 83.6.

The second part of the formula is actually really useful because it allows the formula to automatically correct its calculations. Remember that the weights don't need to add up to 100%? This is because this part of the formula takes care of that for us. For example, if we increase one or more of the weights, the second part of the formula simply divides by a higher number, bringing it back down to the correct answer. We could even make the weights much smaller, giving them values like 0.5, 2.5, 3.0, and 4.5, and the formula would still work perfectly. Pretty neat, huh?

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 out the Functions lesson in our Excel Formulas tutorial. COUNTA works the same in all versions of Excel, as well as other spreadsheet applications like Google Sheets.

You can download our example if you'd like to work along with this article.

Our example

In our example, we're using Excel to plan an event. We've sent out invitations to everyone, and once we receive their responses, we'll type either Yes or No in column C. As you can see, column C still has some empty cells because we haven't heard back from everyone.

Counting responses

We're going to use COUNTA to see how many people have responded. In cell F2, type an equals sign (=), followed by COUNTA:

=COUNTA

As with any function, the arguments will need to go in parentheses. In this case, we only need one argument: the range of cells we want COUNTA to look at. Our responses are in cells C2:C86, but we can actually include a few extra rows in case we decide to invite more people:

=COUNTA(C2:C100)

When you press Enter, you'll see that we've received 55 responses. Here's the best part: We can continue to update this spreadsheet as we receive responses, and our function will automatically recalculate to give us the correct answer. Try entering Yesor No into some of the empty cells in column C, and you should see the value in cell F2 change.

Counting invitees

We can also use COUNTA to calculate the total number of people that were invited. In cell F3, type the following function and press Enter:

=COUNTA(A2:A100)

See how easy it is? All we had to do was type a different range (A2:A100), and it counts all of the first names, giving us an answer of 85. If you type more names at the bottom of the spreadsheet, Excel will automatically recalculate this value. However, if you type anything below row 100, you'll need to update your ranges so any new people are included.

Bonus question!

We now have the number of responses in cell F2 and the total number of invitees in cell F3. It would be great to calculate the percentage of people who have responded. See if you can write a formula in cell F4 that calculates the percentage.

Remember to use cell references; we want the formula to recalculate whenever we update the spreadsheet.

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 in work and life. Let’s get started!

Office Tips

 

Office 2016

 

Office 2013

 

Office 2010

 

Office 2007

 

Office 2003

 

Office XP

 

Office 2000

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 how to create arguments to calculate values and cell references.

Watch the video below to learn more about using functions in Excel.

The parts of a function

In order to work correctly, a function must be written a specific way, which is called the syntax. The basic syntax for a function is an equals sign (=), the function name (SUM, for example), and one or more arguments. Arguments contain the information you want to calculate. The function in the example below would add the values of the cell range A1:A20.

Working with arguments

Arguments can refer to both individual cells and cell ranges and must be enclosed within parentheses. You can include one argument or multiple arguments, depending on the syntax required for the function.

For example, the function =AVERAGE(B1:B9) would calculate the average of the values in the cell range B1:B9. This function contains only one argument.

Multiple arguments must be separated by a comma. For example, the function =SUM(A1:A3, C1:C2, E2) will addthe values of all cells in the three arguments.

Using functions

There are a variety of functions. Here are some of the most common functions you'll use:

• SUM: This function adds all the values of the cells in the argument.
• AVERAGE: This function determines the average of the values included in the argument. It calculates the sum of the cells and then divides that value by the number of cells in the argument.
• COUNT: This function counts the number of cells with numerical data in the argument. This function is useful for quickly counting items in a cell range.
• MAX: This function determines the highest cell value included in the argument.
• MIN: This function determines the lowest cell value included in the argument.

To use a function:

In our example below, we'll use a basic function to calculate the average price per unit for a list of recently ordered items using the AVERAGE function.

1. Select the cell that will contain the function. In our example, we'll select cell C11.
   
2. Type the equals sign (=) and enter the desired function name. In our example, we'll type =AVERAGE.
   
   
   
3. Enter the cell range for the argument inside parentheses. In our example, we'll type (C3:C10). This formula will add the values of cells C3:C10 and then divide that value by the total number of cells in the range to determine the average.
   
   
   
4. Press Enter on your keyboard. The function will be calculated, and the result will appear in the cell. In our example, the average price per unit of items ordered was $15.93.
   
   
   

Your spreadsheet will not always tell you if your function contains an error, so it's up to you to check all of your functions. To learn how to do this, check out the Double-Check Your Formulas lesson.

Working with unfamiliar functions

If you want to learn how a function works, you can start typing that function in a blank cell to see what it does.

You can then type an open parenthesis to see what kind of arguments it needs.

Understanding nested functions

Whenever a formula contains a function, the function is generally calculated before any other operators, like multiplication and division. That's because the formula treats the entire function as a single value—before it can use that value in the formula, it needs to run the function. For example, in the formula below, the SUM function will be calculated before division:

Let's take a look at a more complicated example that uses multiple functions:

=WORKDAY(TODAY(),3)

Here, we have two different functions working together: the WORKDAY function and the TODAY function. These are known as nested functions, since one function is placed, or nested, within the arguments of another. As a rule, the nested function is always calculated first, just like parentheses are performed first in the order of operations. In this example, the TODAY function will be calculated first, since it's nested within the WORKDAY function.

Other common functions

There are many other functions you can use to quickly calculate different things with your data. Learning how to use other functions will allow you to solve complex problems with your spreadsheets, and we'll be talking more about them throughout this tutorial. You can also check out our articles below to learn about specific functions:

• How to Use Excel's VLOOKUP Function
• How to Count Cells with COUNTA
• Use SUMPRODUCT to Calculate Weighted Averages
• CONCATENATE: Excel's Duct Tape
• Use the PROPER Function to Capitalize Names in Excel

Read More