|
|
|
|
Course Number:
|
07XL02 |
 |
Course Title:
|
Microsoft Excel 2007 Intermediate |
No classes scheduled.
|
Know someone who
needs this course? |
 |
|
|
Length:
|
1 Day(s)
|
|
Description:
Navigate with My Computer; perfom basic tasks with My Computer; change views with M Computer; us the My Places toolbar, file formats, file properties and AutoRecovery; upgrade a workbook; open, use, download and create a template.
What you will learn:
- Using My Computer within Excel; saving your files; using Templates; using formulas in Excel; exploring Excel Functions; using Functions in Excel; working with Names and Ranges; working with Array Formulas; working with Tables, Records, Fields, Tables and Filters; using Excel as a Database; customizing your Workbook; working with Text boxes; WordArt; ClipArt; using Objects; protecting your WorkBook; Finishing your Workbook; using Excel in Word, Excel and Access; using Excel with other Programs and Files.
Audience:
Intermediate Level - Comprehension of Foundation Level
Prerequisites:
- Familiar with using Windows 2000/XP Operating System as well as Excel 2007 Foundation level concepts.
Outline:
- 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
|
|
|