Excel Formula Efficiency 8: Custom VBA Function Can Be Fast

See how a custom Function (User Defined Function) can speed up calculations. See how to copy VBA code from an online source; go back to Excel and open the VBA editor window with Alt + F11; insert, module; paste VBA code.

USER Defined Function

COUNTU custom function counts unique values in a list.

Learn how to speed up slow calculating spreadsheets with formulas that calculate faster. See many methods to speed up your spreadsheet decrease the amount of time it takes for the formulas to calculate. The tricks you see are from a White Paper called Improving Performance in Excel 2007. In this video series you will see tricks for both Excel 2003 and Excel 2007. Many of the large formulas in this series involve multi-conditional multiple criteria calculations that slow down the spreadsheet (worksheet, workbook).

Category:

Science & Technology

Tags:

• Excel
• Custom
• VBA
• Function
• Fast
• USER
• Defined
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[Jebrone]

haha, this actually helped me find out how to open the module to make new functions, and how to make them to begin with! This video did its job indirectly! now to find out how to get all those tabs on my excel :(

[ExcelIsFun]

Do you mean the tabs at the top, the ribbons/ That is the new interface with Excel 2007.

[hashimhisham]

this is video very good i want more

[ExcelIsFun]

Dear hashimhisham,

More what?

--excelisfun

[Jebrone]

Well i do have excel 2007, bro got it with the microsoft office package. I just dont have all those buttons on top like you have. :( like Developers, pagelayout, add-ins

[ExcelIsFun]

Dear 1Mperios,

EXCELlent!! Laughter and love are amongst the most important things in the universe!

--excelisfun