This fast-paced half day course is for those who already have a basic knowledge of any Windows spreadsheet package. It covers the topics of both Excel Beginner and Intermediate. Topics include creating a chart, embedding a chart, modifying a chart, formatting a chart, adding graphical objects, filtering data using multiple-conditions, introduction to macros, consolidating data using pivot tables. Excel 97 Advanced class or equivalent knowledge. Learn to build Excel macros that will help you make your spreadsheet applications more productive by automating routine tasks, repetitive tasks, and complex processes.
Class covers first half of workbook.
Introductory topics include database concepts and terminology, database planning, creating a table using the Table Wizard, creating a table in Design View, primary keys, entering new data, modifying existing data, modifying the table design, finding and editing data, deleting data, copying data, filtering and sorting records, AutoReport. Class covers second half of the Beginner workbook. Beginner workbook recommended but not required. This fast-paced half day course is for those who already have a basic knowledge of any Windows database package. It covers the topics of both Access Beginner and Intermediate.