|
||||||||
|
||||||||
|
||||||||
|
|
|
User Tools
2D Graphics
- Fireworks (286)
- Flash (4167)
- Gimp (255)
- Illustrator (1476)
- Paint Shop Pro (54)
- Photoshop (16740)
3D Graphics
- 3DS MAX (2419)
- AutoCAD (84)
- Blender 3d (286)
- Bryce 3d (28)
- Cinema 4D (143)
- Lightwave 3D (38)
- Maya (571)
Web Design & Development
- Adobe Flex (66)
- ASP (378)
- ASP.NET (485)
- ColdFusion (16)
- CSS (575)
- Dreamweaver (388)
- HTML (403)
- Java (731)
- Javascript (926)
- MM Fusion (1)
- MS FrontPage (20)
- Perl and CGI (123)
- PHP (1570)
- Python (69)
- Ruby on Rails (106)
- SEO (185)
- Web Design (315)
- XML (164)
Business Applications
- MS Excel (448)
- MS PowerPoint (169)
- MS Word (154)
- QuarkXPress (8)
Business Development
- Accounting (46)
- eCommerce (77)
- Legal (7)
- Marketing (246)
Databases
Desktop Programming
- C and Cpp (518)
- Delphi (21)
- Visual Basic (339)
- Visual C (30)
Video Editing
- Final Cut Studio (23)
- Premiere (65)
Miscellaneous
- P2P Filesharing (8)
- Web Hosting (159)
Newsletter
User Login
Stats
- Tutorials: 38,110
- Categories: 572
| MS Excel Tutorials : Functions Tutorials | RSS  |
| 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 |
|
|
-
Evaluate a Text Equation
in MS Excel / Functions
2010-07-08
By using an old Excel4 macro function called EVALUATE in a special way, you can easily evaluate text Rating: 
Hits: 
1882 Comments: 
0 Votes: 30 Broken Link? -
Count Words in a Cell or Range of Cells
in MS Excel / Functions
2010-07-08
To get a word count of any cell or range of cells, we'll use a combination of SUBSTITUTE and LEN fun Rating: Hits: 1425 Comments: 0 Votes: 26 Broken Link? -
Create Custom Functions Using Names
in MS Excel / Functions
2010-07-05
Although referencing data by name is convenient, it's sometimes more helpful to store a constant val Rating: 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 Rating: Hits: 1603 Comments: 0 Votes: 28 Broken Link? -
Highlight Every Other Row or Column
in MS Excel / Functions
2010-07-01
You've surely seen Excel spreadsheets that have alternating row colors. For instance, odd-numbered r Rating: Hits: 1667 Comments: 0 Votes: 40 Broken Link? -
Use Replace to Remove Unwanted Characters
in MS Excel / Functions
2010-06-30
Using this tutorial, you can spare yourself the trouble of removing them by hand. Rating: Hits: 1190 Comments: 0 Votes: 31 Broken Link? -
Validation Lists Change Based Selection Another List
in MS Excel / Functions
2010-06-30
Validation needs can vary depending on the context in which the validation is used. However, you can Rating: Hits: 1379 Comments: 0 Votes: 28 Broken Link? -
Support Multiple Lists in a ComboBox
in MS Excel / Functions
2010-06-30
When working with multiple lists, you can force a list to change by using a combination of option bu Rating: Hits: 1231 Comments: 0 Votes: 38 Broken Link? -
Turn Conditional Formatting and Data Validation On and Off with a Checkbox
in MS Excel / Functions
2010-06-30
Turn Conditional Formatting and Data Validation On and Off with a Checkbox Rating: Hits: 1285 Comments: 0 Votes: 38 Broken Link? -
Count or Sum Cells That Meet Conditional Formatting Criteria
in MS Excel / Functions
2010-06-30
Once you can see the results of conditional formatting, you might want to create formulas that refer Rating: Hits: 1300 Comments: 0 Votes: 25 Broken Link?
Total:
