OUTLINE FOR Excel 7.0 Level III

Computer Training

OUTLINE FOR EXCEL2000 FOR Windows 98 LEVEL III

Contents: Introduction
Advanced data entry and formatting techniques
· restricting cell entries to specific numbers, dates or times
· restricting cell entries to specific entries in a list
· applying number formats to cell entries
· creating a custom number format
· applying conditional formatting to a worksheet
Naming ranges
· defining a range name, using a range name in a formula
· moving the cell pointer to a named range
Using lookup functions
· using the Vlookup function, using the Hlookup function
Working with a template
· creating a template, modifying the default template style
· basing a new workbook on a custom template
Auditing a worksheet
· tracing precedents and dependents in a worksheet
· tracing errors in a worksheet
Linking multiple workbooks
· entering a formula to link multiple workbooks, creating a workspace
Working with a database
· what is a database, sorting database records
· totaling database entries, filtering database records
· specifying a criteria range in a filter operation
· using a data form to enter database records
· querying an external database
Analyzing data (Part 1)
· creating a pivottable report
· resetting a summary function in a pivottable report
· creating a pivotchart report, creating a pivottable report for the WWW
Analyzing data (Part 2)
· using the solver, outlining a worksheet
· additional data analysis topics
Importing and exporting data
· importing data from other applications into Excel
· importing data in a text file into Excel,
· importing a table in an HTML file into Excel
· exporting Excel data into other applications
Using Excel workgroup features
· tracking changes in a workbook, inserting comments in a worksheet
· accepting and rejecting proposed changes/reviewing comments
· protecting a shared workbook, protecting an unshared workbook
· additional workgroup topics
Final case study
· importing elements of another web site into a FrontPage web
· linking a page to a Microsoft Word file
· performing a copy and paste operation

Duration:1 day