Tips for Spreadsheet Power-Users
Uncovering useful keyboard shortcuts, working with
formulas, and other standard features of Excel.
Even if you are not into the "heavy" stuff, you
find a wealth of useful spreadsheet tricks here to
make working with Excel easier and a lot more fun.
Getting to Know VBA
Visual Basic for Applications (VBA) is the
Microsoft Office automation language. You won't
need to be a programmer to discover how much time
and effort even some simple recorded macros can be.
The goal here is to give a beginning to
intermediate level treatment to the topic of VBA.
It's a good way to gradually become familiar with
a valuable tool that will become your friend.
For Geeks Only
This is the stuff hardcore developer types love -
where we give attention to applying VBA in Excel
for some advanced solutions. We will examine
challenging scenarios and demonstrate how
to conquer the development problems that happen
out here in the real-world.