Untitled document
The student will:
1. Use names by creating cells names, naming formulas, checking
references, and working with ranges
2. Work with functions such as NOW, DATE, VLOOKUP, IF, PMT, and FV
functions
3. Work with formatting features such as time, fraction, and scientific
format
4. Apply outlines by creating, collapsing, expanding, and removing them
5. Find and replace text and numeric data
6. Format and change zero and negative values
7. Set up print options with titles, gridlines, and print areas
8. Preview and print multiple worksheets and workbooks
9. Protect worksheet data by creating, displaying, hiding, and editing
comments
10. Assign and remove passwords
11. Manipulate the screen display by displaying and navigating among
open workbooks
12. Freeze worksheet panes, rows, and columns
13. Share worksheet data by importing, exporting, and linking
14. Automate work by customizing templates, working with macros, and
creating custom lists
Untitled document
1. Review the basics from Module 1
2. Using names
A. Name cells, create cell names, and use them in formulas
B. Name formulas
C. Check and list names and references
D. Create 3-dimensional names
E. Work with ranges by creating, naming, formatting, clearing,
copying and moving ranges
3. Working with functions
A. Using the NOW function
B. Using the DATE function
C. Using the VLOOKUP function
D. Using the IF function
E. Using the PMT function
F. Using the FV function
4. Working with formatting features
A. Using number formats such as the time format, fraction format,
and scientific format
B. Create custom number formats
C. Apply outlines by creating, collapsing, expanding, and removing
outlines
5. Locating and updating data
A. Find and replace text and numeric data
B. Control recalculation
6. Using special format and print options
A. Format zero values by displaying zero values as blank cells and
as text
B. Change the display of negative values
C. Use print options by printing titles and gridlines setting print
areas, printing multiple worksheets, and previewing and printing
workbooks
7. Protecting worksheet data
A. Creating, displaying, hiding, editing, and deleting comments
B. Use worksheet and range protection
C. Hiding and displaying data
D. Use password protection by assigning and removing passwords
8. Manipulating the screen display
A. Work with multiple workbooks by displaying them and navigating
among them
B. Freezing worksheet panes by freezing rows, clearing frozen panes,
freezing columns, freezing rows and columns simultaneously
C. Adjusting the zoom setting
D. Work with toolbars by displaying and hiding toolbars, moving
them, and customizing them
9. Sharing worksheet data
A. Importing text files by opening a text file in Excel and
importing a text file into a refreshable range
B. Exporting data to other applications
C. Linking workbooks by creating links and updating links
10. Automating your work
A. Work with existing templates, customize templates, and create
workbooks based on templates
B. Create templates
C. Work with macros by recording, executing, and editing them
D. Create custom lists
Untitled document
Excel, Module II, ComputerPrep, 1998
