Microsoft Office Tutorials and References
In Depth Information
Why Excel Is Great for Developers
Figure 1-5: A Web-based spreadsheet from Google.
For developers, Excel’s key features include the following:
h File structure: The multisheet orientation makes it easy to organize an application’s
elements and store them in a single file. For example, a single workbook file can hold any
number of worksheets and chart sheets. UserForms and VBA modules are stored with a
workbook but are invisible to the end user.
h Visual Basic for Applications: This macro language lets you create structured programs
directly in Excel. This topic focuses on using VBA, which, as you’ll discover, is extremely
powerful and relatively easy to learn.