Microsoft Excel 2003 (Levels 1-2-3)
|
|
||||||||||
- You will be able to apply this knowledge in the workplace
- You will have an appreciable understanding of the subject matter
- You will be trained in a systematic manner designed to get you up to speed on the subject matter in a short period of time
Assessment
Testing as part of the course through exam simulation engines
Course Details
Level 1 - Overview Course Introduction Entering and Editing Data Data Entry Tools Using Office Tools Inserting Graphics Using the AutoFilter Tool Data Sorting Tools Inserting Formulas Using Advanced Functions Formatting Cells Row and Column Styles Applying Templates Editing and Moving Cell Content Working with Worksheets Links and Hyperlinks Arrange Window Layout Print Page Setup Using Print Preview Summary Level 2 - Overview Manipulating and Analyzing Data Using Advanced Filters Data Validation Tools Creating and Modifying Lists Using Scenarios Automated Data Analysis Tools Using Goal Seek Automated Data Analysis Tools Using Solver Setup PivotTables Reference Functions Working with Database Functions Error Tracking Tools Setting Up Named Ranges Working with Data Formats Conditional Formatting Summary Level 3 - Overview Displaying and Sharing Data PivotCharts Collaboration Tools Protection Features Tracking Changes Managing Changes Importing and Exporting Data Consolidating Data Publishing to the Web Working with XML Data Customizing Excel Create and Edit Macros Summary
Contact Hours: 24
