COURSE
DESCRIPTION FOR
MICROSOFT EXCEL - ADVANCED
This class description basically covers all versions of Excel.
To request the class description and system requirements for your version
of Excel,
send e-mail to the Office Wiz
Do you want to become an Excel wizard? This is the perfect
course for you. You will discover advanced techniques to master your workbooks
and automate routine tasks. It is instructor-led with many hands-on activities.
Topics include:
- Customizing toolbars and creating styles and templates.
- Creating decision-making functions.
- Analyzing worksheet data by creating pivot tables.
- Comparing and contrasting workbook files and file links.
- Outlining and consolidating worksheets and analyzing
worksheet data by using the Scenario Manager.
- Displaying and protecting worksheet data by locking cells.
- Recording and modifying macros by using the Visual Basic
Editor.
- Creating and working with interactive Web documents.
LENGTH
Approximately eight hours. Recommend two four hour sessions.
PREREQUISITES
Excel - Introduction or equivalent
knowledge. Specifically, you should know how to work with worksheets, write
formulas and work with workbooks. You must have a good understanding of
basic Microsoft Windows, file management and personal computers.
SPECIFIC CLASS CONTENT
Lesson 1: Customizing the work area
Working with built-in toolbars
Using custom toolbars
Creating and using styles
Using templates
Lesson 2: Advanced formula construction
Using names
Using the IF function
Using the VLOOKUP function
Using IS functions and the Auditing features
Lesson 3: Using pivot tables
Creating pivot tables
Modifying pivot tables
Grouping and summarizing data in a pivot table
Lesson 4: Working with multiple worksheets
Working with workbooks
Linking cells in different workbooks
Workbook versus links and workspaces
Lesson 5: Consolidating and analyzing data
Consolidating data from more than one worksheet
Using the Goal Seek and Solver utilities
Using Scenario Manager to view a worksheet with different input values
Lesson 6: Using protection and display options
Using comments
Protecting workbooks
Using custom views
Lesson 7: Introduction to macros
Running macros
Recording a macro
Viewing and editing VBA code
Lesson 8: Working with interactive Excel Web documents
Saving Excel worksheets as Web documents
Spreadsheet Web Components
NECESSARY SOFTWARE AND HARDWARE
- 32 megabytes (MB) of Random Access Memory (RAM) necessary
to run Excel. You will need a minimum of 500 MB of hard-disk space available
for Office 2000 after Windows 98 is installed.
- A Pentium 90 or higher processor.
- Windows 95, 98 or Windows NT 4.0 with Service Pack 3
(or higher) installed.
- Microsoft Office 2000.
- A local CD-ROM drive or access to a networked CD-ROM
drive.
- A VGA or higher display adapter.
- Microsoft mouse or compatible pointing device.
- A printer (optional). You must have an installed printer
driver to use Print Preview.
OTHER EXCEL CLASSES
- Mini Power Sessions:
--Create And Manage A Worksheet Database Using Excel
--Integrate Data And Graphs Into Your Word Document Using Excel And MS
Graph
--Make Sense Of Sales And Product Data With Pivot Tables Using Excel
--Save Time With Functions Using Excel
--Showcase Your Data With Charts Using Excel
--Track And Analyze Business Data Using Excel
| 