Excel - Chapters 9 & 10 & 11
It looks like
we're biting off a huge chunk this week, but not really. Mainly,
because I'm not going to be emphasizing some of the material in these
chapters. A lot of what you're going to be seeing is "extra" material, like
styles, themes, templates, adapting the Quick Access Toolbar, etc. Some of it will
be important. Chapter 9 won't be on the
test, and you won't be doing any homework assignments from these 3
chapters...just reading and doing the hands-on exercises.
Getting Started: Excel - Chapter 9 - No content will be
covered from this chapter.
Getting Started: Excel - Chapter 10
editing of the same workbook--an integral part of financial forecasting
TRACK CHANGES (as you will see...there are
several Pits associated with the following)
additions, deletions, and formatting changes made in a workbook
accepting, and rejecting changes enable you to review the changes others
you turn off Track Changes:
the workbook is
no longer shared
the history of
changes made is lost
other users who
are sharing the workbook will not be able to save the changes they made
time you close the workbook and reopen, you must enable Highlight Changes
Lists particular types
of changes made to the workbook
dates, times, new, and original values, and other details about the
made to formulas with dependent values are not listed
not track font changes or hiding/unhiding columns or rows
When several people can
simultaneously edit a workbook stored on a network server
a network, the last person to make changes decides which changes to accept
can arise if a user doesnt property close the workbook
multiple users attempt to change the same cell at the same time, a
Conflict Resolution dialog box is displayed for the second user.
Workbooks can be saved
in a variety of Excel version formats
Can also be
saved as a text file, a Web page, a PDF, and a template
clicking the Office button and choosing the Save As option
as a PDF requires an add-in
computer programs that you can add to
enhance the functionality of Excel
completed workbook used to create other workbooks.
contains formulas and formatting or themes but no specific data
process of inserting an object or data into a file
to determine what properties of Excel will be available when you save
the document in an older version of Excel
collection of metadata associated with a file
Excel files for hidden data and personal information
you to grant people access to workbooks while restricting their ability
to print, copy, or edit the workbook
electronic notation in a document to authenticate the contents
you to mark a document as final which:
ribbon commands are disabled
EXCEL OPTIONS DIALOG BOX
Centralized area where you can
change the look, behavior, and calculation options in Excel
Getting Started: Excel - Chapter 11
Back to top
partially completed workbook that is used as a model to create other
workbooks that have the same structure and purpose
contains formulas and formatting but no data or only sample data
resides in a
special folder so the latest templates are available for you to use
different file extension (.xltx) than a regular Excel workbook (.xlsx)
A defined set of colors,
fonts, lines, and fill effects applied to an entire workbook or to
specific items in a workbook.
image placed behind the worksheet data.
set of formatting options applied to cells.
be used in all Excel workbooks
custom style you create will appear in the Custom section of the Cell Styles
Some considerations when
creating a template:
A template should be a
Create formulas so
they will not change.
function to trap errors.
Turn off worksheet
meaningful names; delete worksheets that are not used.
modification of formulas and text but enables you to change values in
worksheets involves two steps: unlock the cells that can be changed, and
then protect the worksheet
in an application or WEB PAGE and serve
three basic purposes:
To display another Web
To display a different
application file, such as a Word file.
To display another
worksheet or different location on a large worksheet in Excel
Preview in browser to
ensure how the worksheet will look on the Internet.
Insert pictures or
graphics to enhance the Web page.
color and font combinations, use graphics sparingly, and use the Save As
option to save a worksheet as a Web page.
Excel to go to a particular Web site to obtain the Web based information
the Web address changes, you must change the Web query and URL to ensure
you have the most accurate information and citation
information about the macro, but do not affect its execution and are
every command you execute
you do once you begin recording a macro becomes part of the macro
Microsoft Office uses a
subset of Visual Basic known as Visual Basic for Applications (VBA). The
VBE (Visual Basic Editor) can be used to debug macros. We won't be
covering VBA, but I teach a course in Visual Basic if you're interested in
extending your Office abilities.