Excel Formulas and Functions Tips and Tutorials

Tips & Tutorials

Functions Examples

Edit and Format

Cell Formatting

Data Validation

Charts and Graphics

Formulas and Functions

LookUp Formulas

User Defined Functions

Workbook and Worksheets

Workbook and Worksheets

Cells and Ranges

Workbook and Worksheets

Files and Folders

UserForms and InputBoxes

Excel Formulas and Functions : User Defined Functions

Displaying 1-15 of 15

1. Userdefined functions from other workbooks

2. Extracting text from strings and phrases

3. Methods to Use Custom Functions with Varying Arguments

4. How to Use a Custom Function in Another Workbook

6. Display AutoFilter Criteria

7. Create a Custom Function

8. Writing Your First VBA Function in Excel

9. How to Remove User-Defined Functions from Function Wizard

10. Bond Maturity

11. Creating UDF's - How to create a user defined function in Excel

12. Using and creating array formulae

13. How to Create Functions to Calculate Light Years in Excel 2000

14. Looking Up Names when Key Values are Identical

15. Userdefined functions from other workbooks using VBA in Microsoft Excel

Excel Add-ins

Find duplicates , remove characters , change case , merge cell's text.

Visually display and store in a library cell's formatting.

PowerPoint Add-ins

Easily save and apply the formatting of a shape.

Create a library from your custom animations.

Pick colors from screen for your shapes.

Home Contact Us

PowerPoint, Excel, Word and Access are registered trademarks of the Microsoft Corporation.