Microsoft Office Tutorials and References
In Depth Information
• New worksheet functions: Excel 2013 supports dozens of new worksheet functions.
• Backstage: The Backstage screen has been reorganized and is easier to use.
• New add-ins: Three new add-ins are included (for Office Professional Plus only): PowerPivot, Power View,
The Object Model Concept
If you've dealt with computers for any length of time, you've undoubtedly heard the term “object-oriented pro-
gramming” (OOP). An object essentially represents a software element that a programmer can manipulate.
When using Excel, you may find it useful to think in terms of objects, even if you have no intention of becom-
ing a programmer. An object-oriented approach can often help you keep the various elements in perspective.
Excel objects include the following:
• Excel itself
• An Excel workbook
• A worksheet in a workbook
• A range in a worksheet
• A button on a worksheet
• A ListBox control on a UserForm (a custom dialog box)
• A chart sheet
• A chart series in a chart
Notice the existence of an object hierarchy: The Excel object contains workbook objects, which contain work-
sheet objects, which contain range objects. This hierarchy is called Excel's object model. Other Microsoft Office
products have their own object model. The object model concept proves to be vitally important when develop-
ing VBA macros. Even if you don't create macros, you may find it helpful to think in terms of objects.
The Workings of Workbooks
The core document of Excel is a workbook. Everything that you do in Excel takes place in a workbook.
Beginning with Excel 2007, workbook “files” are actually compressed folders. You may be familiar with com-
pressed folders if you've ever used a file with a .zip extension. Inside the compressed folders are a number of
files that hold all the information about your workbook, including charts, macros, formatting, and the data in its
If you're the curious type, make a copy of an XLSX workbook file and add a .zip exten-
sion to the filename. Then unzip the file to see what's inside.
An Excel workbook can hold any number of sheets. The four types of sheets are