Microsoft Excel Tutorials
  Microsoft Excel Tutorials
2D Graphics
3D Graphics
Web Design & Development
Business Applications
Business Development
Databases
Desktop Programming
Operating Systems
Video Editing
Miscellaneous
Newsletter
User Login
  • Username
  • Password
Stats
  • Tutorials: 38,109
  • Categories: 572
   Home : MS Excel TutorialsRSS Subscribe to this feed using your favorite reader
Microsoft Excel is an application that helps you create intricate and dynamic spreadsheets. Use this robust application to enter numerical values or data into the rows or columns of a spreadsheet, and to use these numerical entries for such things as calculations, graphs, and statistical analysis.

 
JOIN OUR MS EXCEL DISCUSSION FORUM
 
Total:

448 MS Excel Tutorials

Displaying: 111 - 120
Evaluate a Text Equation
in MS Excel / Functions
2010-07-08
Evaluate a Text Equation MS Excel tutorial
By using an old Excel4 macro function called EVALUATE in a special way, you can easily evaluate text
Rating: Tutorial Rating 2.70Tutorial Rating 2.70Tutorial Rating 2.70Tutorial Rating 2.70Tutorial Rating 2.70
Hits: 1882
Comments: 0
Votes: 30
Broken Link?
Count Words in a Cell or Range of Cells
in MS Excel / Functions
2010-07-08
Count Words in a Cell or Range of Cells MS Excel tutorial
To get a word count of any cell or range of cells, we'll use a combination of SUBSTITUTE and LEN fun
Rating: Tutorial Rating 2.92Tutorial Rating 2.92Tutorial Rating 2.92Tutorial Rating 2.92Tutorial Rating 2.92
Hits: 1425
Comments: 0
Votes: 26
Broken Link?
Identify Named Ranges on a Worksheet
in MS Excel / Formatting
2010-07-08
Identify Named Ranges on a Worksheet MS Excel tutorial
Here is quick method you can use to identify the referenced ranges for each named range.
Rating: Tutorial Rating 2.51Tutorial Rating 2.51Tutorial Rating 2.51Tutorial Rating 2.51Tutorial Rating 2.51
Hits: 888
Comments: 0
Votes: 37
Broken Link?
Dynamic Ranges for Maximum Flexibility
in MS Excel / Formatting
2010-07-08
Dynamic Ranges for Maximum Flexibility MS Excel tutorial
A dynamic named range that resides within another dynamic named range can be very useful for things
Rating: Tutorial Rating 3.00Tutorial Rating 3.00Tutorial Rating 3.00Tutorial Rating 3.00Tutorial Rating 3.00
Hits: 842
Comments: 0
Votes: 28
Broken Link?
Fill All Blank Cells in a List
in MS Excel / Formatting
2010-07-05
Fill All Blank Cells in a List MS Excel tutorial
Many of Excel's functions are designed to be used on lists. For most of these functions to work corr
Rating: Tutorial Rating 2.76Tutorial Rating 2.76Tutorial Rating 2.76Tutorial Rating 2.76Tutorial Rating 2.76
Hits: 847
Comments: 0
Votes: 21
Broken Link?
Create Custom Functions Using Names
in MS Excel / Functions
2010-07-05
Create Custom Functions Using Names MS Excel tutorial
Although referencing data by name is convenient, it's sometimes more helpful to store a constant val
Rating: Tutorial Rating 2.76Tutorial Rating 2.76Tutorial Rating 2.76Tutorial Rating 2.76Tutorial Rating 2.76
Hits: 1593
Comments: 0
Votes: 21
Broken Link?
Make Your Formulas Increment by Rows When You Copy Across Columns
in MS Excel / Functions
2010-07-05
Make Your Formulas Increment by Rows When You Copy Across Columns MS Excel tutorial
Make Your Formulas Increment by Rows When You Copy Across Columns
Rating: Tutorial Rating 2.96Tutorial Rating 2.96Tutorial Rating 2.96Tutorial Rating 2.96Tutorial Rating 2.96
Hits: 1603
Comments: 0
Votes: 28
Broken Link?
Address Data by Name
in MS Excel / Formatting
2010-07-05
Address Data by Name MS Excel tutorial
Although cell numbers are at the foundation of everything Excel does, it's much easier to remember n
Rating: Tutorial Rating 2.95Tutorial Rating 2.95Tutorial Rating 2.95Tutorial Rating 2.95Tutorial Rating 2.95
Hits: 666
Comments: 0
Votes: 19
Broken Link?
Add a Custom List to the Fill Handle
in MS Excel / Formatting
2010-07-05
Add a Custom List to the Fill Handle MS Excel tutorial
Once you have created a few of your own Custom Lists, it can be hard to remember the first item in t
Rating: Tutorial Rating 2.42Tutorial Rating 2.42Tutorial Rating 2.42Tutorial Rating 2.42Tutorial Rating 2.42
Hits: 867
Comments: 0
Votes: 31
Broken Link?
Provide Decreasing Data Validation Lists
in MS Excel / Formatting
2010-07-04
Provide Decreasing Data Validation Lists MS Excel tutorial
Wouldn't it be useful if you could give users a list of options to select that decreases as options
Rating: Tutorial Rating 2.71Tutorial Rating 2.71Tutorial Rating 2.71Tutorial Rating 2.71Tutorial Rating 2.71
Hits: 743
Comments: 0
Votes: 31
Broken Link?





© 2003-2012 by Developer Shed. All rights reserved. DS Cluster 9 - Follow our Sitemap