Author Description

Excel 2000 Advanced ActiveEducation's course, Microsoft Excel 2000 Advanced, presents advanced techniques for customizing the Excel environment, analyzing workbook data and creating worksheets and charts. The prerequisite for this course is a working knowledge of the operations presented in the previous course, Microsoft Excel 2000 Intermediate. Course length: 6-8 hours. Course Objectives Protect and audit workbooks Analyze workbook data Customize the Excel environment Use collaboration tools Standardize workbooks with templates Use advanced list techniques Lesson Topics Lesson 1: Protecting and Auditing Workbooks Protecting Cells, Worksheets, and Workbooks Auditing Worksheet Content Using Advanced Data Validation Techniques Saving a Workspace Using Passwords to Control Workbook Access Lesson 2: Analyzing Workbook Data Using PivotTables and PivotCharts Working with Goal Seek and Scenarios Consolidating Worksheet Data Creating a Worksheet Online Lesson 3: Customizing the Excel Environment Customizing Toolbars Customizing Excel Views Editing Excel 2000 Defaults Lesson 4: Working with Collaboration Tools Annotating a Worksheet with Comments Monitoring Development with Change Tracking Sharing Workbooks for Group Use Viewing and Editing Workbook Properties Lesson 5: Standardizing Workbooks with Templates Using Built-in Templates Creating a New Template Testing Templates Lesson 6: Advanced List Techniques Manipulating Records in a List Performing Calculations in a List Querying External Databases Creating a Data Map