Excel 2007 Level 3 (Advanced)

Course Length: 6hrs (1 Day)
 

In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications.

Learning Objectives:
You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.

Course Outline:
Section 1: Advanced Topics
Lesson 1.1: Setting Excel Options
Lesson 1.2: Excel and Windows
Lesson 1.3: Using the Excel Viewer

Section 2: Getting the Most From Your Data
Lesson 2.1: Getting the Most From Your Data
Lesson 2.2: Pivot Tables
Lesson 2.3: More About Pivot Tables
Lesson 2.4: Exploring Scenarios
Lesson 2.5: What If Analysis

Section 3: 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 4: 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, Consolidating, and Combining Workbooks

Section 5: Macros, VBA, and Excel Programming
Lesson 5.1: Macros
Lesson 5.2: More Macro Tasks
Lesson 5.3: Visual Basic and Macros

Price: $315.00

Guaranteed to Run

Time: 9:00 am - 4:00 pm
Duration: 1 Day
Language: English

Register Now

Cancellation Policy

What You Get:

Training includes 1 course manual, a Certificate of completion, and a voucher for 30 days of After Training Support

What You Need:

Excel 2007 Level 2 or equivalent knowledge