|
|
|
|
Course Number:
|
07XL03 |
 |
Course Title:
|
Microsoft Excel 2007 Advanced |
No classes scheduled.
|
Know someone who
needs this course? |
 |
|
|
Length:
|
1 Day(s)
|
|
Description:
Change your user name and the default color scheme for Excel; set up formula options; change the default font and file format for your workbooks; search for excel documents; use Office Diagnostics; check for updates; download and use Excel viewer; start Excel on Windows boot.
What you will learn:
- Setting Excel Options; Excel and Windows; using Excel Viewer; getting the most from your Data; PivotTables; exploring Scenarios; What If Analysis; Excel and Hyper links; saving Workbooks as Web Pages; getting Data from the Internet; Excel and Office Servers; creating and using Shared Workbooks; using Cutom AutoFill Lists; use VLOOKUP Function; Linking, Consolidating and Combining Workbooks.
Audience:
Advanced Level - comprehension of Foundation and Intermediate Levels
Prerequisites:
- Understanding of Excel 2007 Foundation and Intermediate level concepts.
Outline:
- Section One: Advanced Topics
- Lesson 1.1: Setting Excel Options
- Lesson 1.2: Excel and Windows
- Lesson 1.3: Using the Excel Viewer
- Section Two: Getting the Most from your Data
- Lesson 2.1: Getting the Most from your Data
- Lesson 2.2: PivotTables
- Lesson 2.3: More About PivotTables
- Lesson 2.4: Exploring Scenarios
- Lesson 2.5: What If Analysis
- Section Three: Excel and the Internet
- Lesson 3.1: Excel and Hyperlinks
- Lesson 3.2: Saving Workbooks as Web Pages
- Lesson 3.3: Getting Data from the Internet
- Lesson 3.4: Excel and Office Servers
- Section Four: Advanced Excel Tasks
- Lesson 4.1: Creating and Using Shared Workbooks
- Lesson 4.2: Using Custom AutoFill Lists
- Lesson 4.3: Using the VLOOKUP Function
- Lesson 4.4: Linking, Consolodating, and Combining Workbooks
|
|
|