Author Description

Product description Excel 97: Advanced ActiveEducation's course, Microsoft Excel 97: Advanced, is designed to enhance the skills acquired in Microsoft Excel 97: Intermediate. This workbook presents features designed to customize your Excel environment, including creating dialog boxes to give feedback to other users, protecting cells and worksheets, analyzing data using Goal Seek and Scenarios, and managing macros. The prerequisites for this course are a strong working knowledge of Excel, and completion of Microsoft Excel 97: Intermediate. Course length: 6-8 hours. Course Objectives Protect and audit workbooks Analyze data Customize Excel Explore macros Lesson Topics Lesson 1: Protecting and Auditing Workbooks Protecting Cells, Worksheets, and Workbooks Using Auditing Tools Working with Data Validation Creating and Using Workspaces Lesson 2: Analyzing Data Working with Goal Seek and Scenarios Workbook Using Custom Views Outlining a Worksheet Consolidating Worksheet Data Lesson 3: Customizing Excel Creating and Changing Toolbars Changing the Startup Options Using Standard Options Creating and Editing Templates Lesson 4: Exploring Macros Using the Personal Macro Workbook Adding Macros to Menus Creating Worksheet Buttons