|
Microsoft Office Excel
2007 Intermediate 1 Day
sample course contents
Section One: Advanced File Tasks
Lesson 1.1: Using My Computer within
Excel
Lesson 1.2: Saving Your Files
Lesson 1.3: Using Templates
Section Two: Working with Functions
and Formulas
Lesson 2.1: Using Formulas in Excel
Lesson 2.2: Exploring Excel Functions
Lesson 2.3: Using Functions in Excel
Lesson 2.4: Working with Names and Ranges
Lesson 2.5: Working with Array Formulas
Section Three: Managing Tables
Lesson 3.1: Working with Tables
Lesson 3.2: Working with Records and Fields
Lesson 3.3: Working with Tables and Filters
Lesson 3.4: Using Excel as a Database
Section Four: Enhancing your Workbook
Lesson 4.1: Customizing your Workbook
Lesson 4.2: Working with Text Boxes
Lesson 4.3: WordArt
Lesson 4.4: ClipArt
Lesson 4.5: Using Objects
Section Five: Finalizing your Workbook
Lesson 5.1: Protecting your Workbook
Lesson 5.2: Finishing your Workbook
Lesson 5.3: Using Excel in Word
Lesson 5.4: Using Excel and Access
Lesson 5.5: Using Excel with other Programs
and Files
Microsoft Office Visio
2007
1 Day
sample course contents
Section One: Getting Started
Lesson 1.1: Starting Out
Lesson 1.2: Interacting with Vista
Lesson 1.3: Working with Files
Lesson 1.4: Using the Getting Started Window
Lesson 1.5: Getting Help in Vista
Section Two: Creating a Basic Drawing
Lesson 2.1: Creating a Basic Drawing
Lesson 2.2: Basic Editing Commands
Lesson 2.3: Formatting Shapes
Lesson 2.4: Adding Text
Lesson 2.5: Formatting Text
Lesson 2.6: Working with Pages
Section Three: Doing More with your
Drawing
Lesson 3.1: Other Ways to Add Shapes
Lesson 3.2: Working with Shapes
Lesson 3.3: More Shape Tasks
Lesson 3.4: Using Layers
Lesson 3.5: Adding Objects
Lesson 3.6: Adding Advanced Objects
Section Four: Working with Visio Files
Lesson 4.1: Using Templates
Lesson 4.2: Using Stencils
Lesson 4.3: Saving Visio Files
Lesson 4.4: Advanced File Tasks
Viewing and Printing your Drawings
Lesson 5.1: Managing your Drawings
Lesson 5.2: Managing Windows
Lesson 5.3: More Visio Windows
Lesson 5.4: Using Print Preview
Lesson 5.5: Printing a Drawing
|