An overview of Advanced Excel Business Center
Advanced Excel business centre hopes to be the center of choice for Advanced
Excel users who hope to achieve breakthrough in using Excel. We hope fill this
web site with resources that will profit when you learn how to apply Excel functions,
formulas (also known as worksheet functions), tips and tricks on using Excel.
This place is not going to just show you how to enter the formulas.
It is going to show you with examples on how to apply the formulas in your day
to day work. This is because some of these formulas are useless on its own.
But if we are to combine these formulas in a particular situation, they can
become very powerful.
One function which has impressed me is the record a macro function. With this
function, we can create a macro without the need to know about programming.
The codes are generated automatically by Excel or to be more specific, Visual
Basic for Applications. Take a look the web page on macro Excel Visual Basic for
Application (VBA) on how I have used recording a macro to create a cell
formatting macro.
A lot of advanced excel users have misunderstood Visual Basic
for Application for Visual Basic. They are different. Visual Basic
(VB in short) is not an abbreviation (or short form) for Visual Basic
for Application. To be a good Visual Basic programmer, you need to
understand how use those codes in a program. However, to be a good VBA
programmer, you need to know the programming codes as well as the Excel
formulas and functions. Excel VBA has the capability to enhance the power
of the Excel. You can even use VBA to create functions that are not
available in Excel.
| 
