Millions of users create and share Excel spreadsheets every day, but few go deeply enough to learn the techniques that will make their work much easier. Yet there are many ways to take advantage of Excel’s sophisticated capabilities without spending hours on advanced study.
Due to the nature of my job in Hedge Fund industry, I have opportunities in exploring many different formulas and functions to expedite my work processes. In many instances, formulas and function provides provide the logic that powers spreadsheets. Managing programming logic is always a challenge, but keeping track of programming logic across multiple cells, sheets, and workbooks can be particularly difficult, especially as spreadsheets grow and are reused.
Using Excel's built-in language, VBA (Visual Basic for Applications), you can bring a lot of automating power to your spreadsheets and become more productive by delegating many time-consuming and task using Excel programming.
The intent of this webpage is to show some useful Excel Function and VBA (Visual Basic for Applications) examples that I have picked up in the process of creating my own applications.
Come and visit to learn...
excelfanatic.com
excelfanatics.com
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment