Tutorial search

Tutorials
Stuff
Affiliates

Photoshop Templates


Featured Photoshop templates - professional ready to use designs for your next project.

View all templates

Conditional color formatting in Excel - Excel tutorial


Let's say you are making an Excel table where you shall input how many hours did you work for everyday. And you would like to make designation with colors. Red number for less than 8, blue for 8 and green color for more than 8. You can make that process automatic in MS Excel and here's how.
Category: Excel tutorials > Formatting - Difficulty:

More cool Excel tutorials:



Formatting Text
Formatting Text
Spreadsheets can be pretty dry, so we need some tools to dress them up a little. We can use most of the tricks in our word processor to do the formatting of text. We can use : bold face, italics, underline, change the color, align (left, right, center), font size, font, etc.
Category: Excel tutorials > Formatting - Difficulty:
Goalseeking in Excel
Goalseeking in Excel
The Goalseek feature allows you to specify the result you require and which input can change. Then the computer will calculate the required number. Very useful for break even analysis. This clip also shows you how to perform a goalseek straight off a graph.
Category: Excel tutorials > Functions - Difficulty:
Merging two Excel files using VLOOKUP function
Merging two Excel files using VLOOKUP function
Merging two Excel files using VLOOKUP function is very powerful and convenient for Data Analysis when manual matching of two files is very time consuming because of size of data.
Category: Excel tutorials > Functions - Difficulty:
Using the RATE function in Excel
Using the RATE function in Excel
Calculate the interest RATE charged on a constant annuity cash flow.
Category: Excel tutorials > Functions - Difficulty:
Copy Forumulas: Fill Down
Copy Forumulas: Fill Down
Often we have several cells that need the same formula (in relationship) to the location it is to be typed into. There is a short cut that is called Fill Down.
Category: Excel tutorials > Basics - Difficulty: