Microsoft Office 2000 - Excel for Power Users
Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Overview/Description
To bring proficient users of Excel 2000 to an advanced level of competence in using macros and sharing, displaying, formatting, and analyzing data
Target Audience
End-users seeking proficiency in the use of Microsoft Excel 2000 at an advanced level; end-users seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2000 at Expert level
Prerequisites
The Microsoft Office 2000: Beginning Excel 2000 learning path; familiarity with the Windows 95/98 or NT 4.0/2000 user environments
Expected Duration (hours)
4.3
Lesson Objectives Microsoft Office 2000 - Excel for Power Users
plan and create macros in Excel.
record and run a macro in Excel.
link multiple workbooks, update links, and create a workspace file.
create a workspace file and link two Excel workbooks.
differentiate between and use the different methods for importing data from text files into Excel.
import a text file into Excel using the Text Import Wizard.
use Microsoft Query to to import data from other applications into Excel.
import data from an Access database into an Excel spreadsheet.
import data from web pages into Excel.
import data from a table on a web page into an Excel spreadsheet.
convert data in an Excel worksheet to an Access database.
use Microsoft Query to import data selectively from external sources.
customize an Excel spreadsheet by applying conditional formatting and by hiding rows and columns.
sort data in an Excel spreadsheet.
use grouping and outlines to hide a column in a worksheet, and perform a multiple sort.
use data forms to create records, update records, and search for data.
filter data and create data validation alerts in Excel.
configure an Excel workbook to filter data and display a data validation alert.
create and modify a PivotTable report.
publish a PivotTable report on a web page.
create and format a PivotTable and publish an interactive PivotTable report on a web page.
distinguish between PivotCharts and regular charts, and create a PivotChart.
distinguish between and use Goal Seek and Solver.
use the Solver tool to predict changes.
use and merge scenarios in Excel.
Course Number: 111287_eng