Author Description

Excel 2000 Intermediate ActiveEducation's course, Excel 2000 Intermediate, presents advanced techniques for creating worksheets and charts, as well as methods for managing databases, creating macros, and sharing Excel files over the Internet. The prerequisite for this course is a working knowledge of the operations presented in the previous course, Introduction to Excel 2000. Course Objectives Work with functions and formats Work with workbook windows Perform advanced chart operations Create and manage databases Create macros Share and distribute Excel files Lesson Topics Lesson 1: Formatting Worksheets Displaying and Formatting Data Outlining and Grouping Data Validating Data Creating and Using Styles Creating Custom Formats Lesson 2: Working with Functions Entering Date and Time Functions Using Financial and Logical Functions Using Absolute and Relative Cell References Using Named Ranges Looking Up Values in a Table Lesson 3: Managing Worksheets and Workbooks Working with Toolbars Opening Windows Working with a Single Window Working with Sheets in A Workbook Linking Workbooks Importing and Exporting Files Integrating Excel with the Internet Lesson 4: Performing Advanced Chart Operations Reviewing Charts Adding Text to a Chart Reformatting Chart Axes Adding Gridlines and Arrows Modifying Chart Data Lesson 5: Crating and Using Excel Databases Creating a Database Modifying a Database Searching for Database Records Sorting Database Records Setting up a Database Filter