Advanced Microsoft Excel Training

Advanced Microsoft Excel Training Advanced Microsoft Excel Training
By TED Integrated
PSMB HRDF Claimable
Course Title:
Microsoft® Excel 2007/2010 – Advanced Level
Training Category:
Information Technology
Target Audience:
This course is suitable for intermediate Microsoft Excel users who want to explore the advanced features of Excel, such as Pivot Table, consolidation of data, data import and export and so on.
Duration:
2 Days
Public Program* Now Available! »
Jan 2017 ›
Venue:
Binjai 8, KLCC, Kuala Lumpur, Malaysia
Schedule:
Thu 12 Jan 2017 - Fri 13 Jan 2017
9:00AM - 5:00PM

Fee Per Person:
RM900.00
Promotions:
  • 10% discount for group registration of 3 paxs or more from the same organization.
Register Now!

* Other terms & conditions apply.
Mar 2017 ›
Venue:
Binjai 8, KLCC, Kuala Lumpur, Malaysia
Schedule:
Wed 22 Mar 2017 - Thu 23 Mar 2017
9:00AM - 5:00PM

Fee Per Person:
RM900.00
Promotions:
  • 10% discount for group registration of 3 paxs or more from the same organization.
Register Now!

* Other terms & conditions apply.
For In-house Training »
Request for Quotation Request for Quotation
For Customization & Other Inquiries »
Contact TED Integrated
Contact customer service +603-2386-7788
Email customer service [email protected]
Delivery Methods
  • Language: English
  • Workshop
  • Computer Lab Work
  • Internet Access
  • Case Studies
  • Certificate of Participation
Ad by Google
*Terms & Conditions
Microsoft Excel Training Series:

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 TrainingRequest for In-house Training
Register for Public Training Public program not yet available
Register for Public TrainingRegister for Public Training
Email Customer Service [email protected] Contact Customer Service+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

DAY 1

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

DAY 2

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

For In-house Training:

Request for Quotation

Request for Quotation Now

For Content Customization & Other Inquiries:

Contact TED Integrated

Contact Customer Service

+603-2386-7788

Email Customer Service [email protected]

Ad by Google

Related Training Courses:

More Other Training Courses:

Published by: ,