Microsoft Office Tutorials and References
In Depth Information
Chapter 21: Almost Ten Ways to Make Office 2010 Easier to Use
Almost Ten Ways to Make Office
2010 Easier to Use
If you haven’t noticed by now, there are plenty of features buried in Office
2010 that you probably don’t need most of the time. However, if you’re a
die-hard Office 2010 power user, you may want to peek at some of the more
advanced features buried inside the operating system.
Although these advanced features may take time to learn and master, you
may find the effort worth it to make Office 2010 behave exactly the way you
want it to. Best of all, you can learn these new features by playing with them
at work — so that way, you can learn something new and get paid for doing it
at the same time.
Learning Visual Basic for
If you’re like most people, you probably just want to use a program, make it
do what you need it to do, and then go home afterwards. However, if you find
yourself wishing Office 2010 could do something more, then you might want
to take some time to learn Visual Basic for Applications (VBA) programming.
The VBA programming language is what Office 2010 uses every time you
create a macro in Word, Excel, PowerPoint, or Access. While VBA might look
a bit strange at first, it’s based on the BASIC programming language, which
was specifically designed to make programming easy for beginners. Unlike
other programming languages like C++ that resemble chicken scratchings,
VBA actually looks like normal English commands.
The simplest way to learn how VBA works is to create your own macros and
then see how Office 2010 created a VBA program to make your macro work.