Advanced Excel Business Center
Advanced Excel Business Center is not a technical website where you
just learn about the
functions
and formulas available in
Microsoft®
Excel.
It is for intermediate and advanced Excel Business users who want to become
more effective in using it to
manage customer databases,
preparing management reprots, sales reports,
inventory, analysis, financial modelling, etc.
We are not going to show you just excel formulas and functions.
We would like to show you with examples when and where you could use them in your day
to day work. Microsoft® Excel is a simple and yet POWERFUL tool if you master it.
One example is related to data downloaded from
SAP. When you download data containing
dates from SAP in excel, you may notice that the dates are formatted as text. Most
people will put the blame on Excel, not knowing that it is caused by their computer
setup. But whatever the cause is, Excel does offer a solution to the problem. And if you
want to know what the solution is, go to our page
converting text dates from
SAP into excel dates.
Another of our favorite example is our
Excel calendar, created only with formulas, no
Macros or VBA is involved. And it is more powerful than most of the solutions you can
find on the internet. You can see the 12 months calendar of any year simply by one click
of the mouse button. Not only so, you can enter your own country holidays
into the template and it will be highlighted automatically for you without you having
to do it manually. If you wish to highlight special occassions, such as your spouse and
children's birthdays, family vactions dates, you can just enter them into a cell and the
Excel Calendar will help you colour the calendar automatically. You can now download a
FREE copy of the calendar in our
Excel calendar page.
Another 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.
•
| 
New! Comments
Have your say about what you just read! Leave me a comment in the box below.