Tutorial search

Tutorials
Stuff
Affiliates

Photoshop Templates


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

View all templates

Add character in each cell - Excel tutorial


You have MSExcel sheet with 100 cells filled with 001-100. And you need to add "A" in front all of them. You don't need to work whole day on that. All you have to do is make one Macro
Category: Excel tutorials > Macros - Difficulty:

More cool Excel tutorials:



Copy Forumulas: Fill Right
Copy Forumulas: Fill Right
We can also fill right. We must select the original cell (and the cells to the right) and select from the Edit menu -- Fill and Right.
Category: Excel tutorials > Basics - Difficulty:
How To Change The Chart Legend Font In Excel
How To Change The Chart Legend Font In Excel
This video tutorial shows how to change the font of the chart legend in Excel.
Category: Excel tutorials > Graphs - Difficulty:
VLOOKUP
VLOOKUP
Learn how to use the VLOOKUP function in Excel
Category: Excel tutorials > Functions - Difficulty:
Select a random sample of rows in Excel
Select a random sample of rows in Excel
Use the excel random number generator to get random sample data from a spreadsheet.
Category: Excel tutorials > Functions - Difficulty:
Auditing Toolbar
Auditing Toolbar
The Auditing Toolbar is one if Excel's best kept secrets. It allows you to visualize the cells used in any formula. In particular is allows you to view what cells are being used by a particular formula, what other cells are relying on the cell you have specified, follow links to other spreadsheets and more recent versions of Excel include some error checking capabilities.
Category: Excel tutorials > Basics - Difficulty: