Please enter a date range below to find available courses
From to
Provider: 1816
Excel Learning CDs 2003 Advanced
Course aim
This course aims to develop skills using Microsoft Excel to produce and edit spreadsheet documents to an advanced level.
Course outline
THIS COURSE IS DELIVERED VIA LEARNING CD & CONTAINS THE FOLLOWING TRAINING TOPICS: Creating Sample Data • Sample Database • Replicate Ranges • Sort Command • Random Numbers Exporting & Importing Data • Export to Text • Export to Database • Import from Database • import from Text • Import Text Wizard Advanced Filters • Custom AutoFilter • Advanced Filter • Extract a List Subtotals & Outlines • Subtotal • Outline • Nesting Subtotals • Manual Grouping Summarising with a PivotTable • Create a PivotTable • PivotTable Field List • • Manipulate a PivotTable • Format • Group Data • Create a PivotChart • Manipulate a PivotChart • AutoFormat
Publishing Workbooks • Preview Large Document • Freeze Headings • Header • Footer • Preview a Chart • Print a Chart • Static HTML Page • PivotTable Interactivity • Spreadsheet Interactivity • Web Queries Creating Macros • Record Macros • Play Macros • Visual Basic • Edit a Macro • Toggle Macro Adding User Interface • Custom Toolbar • Menu Command • Security Level • Workbook Button