Microsoft^® Excel 2007/2010 – Advanced Level

“Explore the advanced features of Microsoft Excel and become the expert!”

By TED Integrated

PSMB Certified Training Provider

Request for In-house Training	Public program not yet available Register for Public Training
training@ted.com.my	+603-2386-7788

Introduction

Students learn Excel advance skills in worksheets and share Excel data with other application. In Excel advance level, students are able to perform advance functions, manage data using Pivot Table, data consolidation and much more.

Prerequisites

Students should obtain intermediate course skills before enter Advance level class. Thus students should experience with intermediate level formulas and charting technique

Course Objectives

At the end of this course, participants should be able to:

• Consolidate data and link cells in different workbooks
• Manage tables and data
• Discover the advanced functions of Microsoft Excel
• Summarize data with Pivot Table
• Share and protect data in workbook
• Audit data in worksheet
• Import and export data with embedded objects

Course Outline

Lesson 1: Consolidate and Link

• Consolidate Data
• Link Cells in Different Workbooks
• Creating A 3-D Formula

Lesson 2: Managing Tables and Data

• Create and Modify Tables
• Sorting Data
• Filtering Data
• Advance Filter
• Subtotals
• Data Validation
• Handing Text Files
• Format Tables

Lesson 3: Advance Functions

• Logical Functions
• Nested If Function
• Using Iserror and Iferror Function to

Prevent error display

• Vlookup Function
• Hlookup Function

Lesson 4: Summarizing Data with Pivot Tables

• What is a Pivot Table
• Creating Pivot Table
• Formatting Pivot Table
• Pivot Table Options
• Pivot Chart

Lesson 5: Sharing and Protecting

• Share a Workbook
• Set Tracking
• Review Tracked Revisions
• Inserting comments
• Protecting cells, sheets, files
• Password protecting a file

Lesson 6: Auditing Worksheets

• Trace Cells
• Troubleshoot Errors in Formulas
• Watch and Evaluate Formulas

Lesson 7: Importing and Exporting Data

• Creating New Embedded Objects
• Embedding Existing Files
• Editing Embedded Objects
• Embedding Parts of Files

Request for Quotation Now

	+603-2386-7788
	training@ted.com.my