Welcome to TED Learning!

  • 12-07, Binjai 8 Premium SOHO, No. 2 Lorong Binjai, 50450 Kuala Lumpur
  • Phone: +603-2742 1828
  • training@ted.com.my

MS Excel Advance 2007/ 2010 - TED Learning

  • Home
  • MS Excel Advance 2007/ 2010
By tedadmin | February 09, 2018

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:

  1. Consolidate data and link cells in different workbooks
  2. Manage tables and data
  3. Discover the advanced functions of Microsoft Excel
  4. Summarize data with Pivot Table
  5. Share and protect data in workbook
  6. Audit data in worksheet
  7. Import and export data with embedded objects

Course Outline

DAY 1

LESSON 1: CONSOLIDATE AND LINK

  1. Consolidate Data
  2. Link Cells in Different Workbooks
  3. Creating A 3-D Formula

LESSON 2: MANAGING TABLES AND DATA

  1. Create and Modify Tables
  2. Sorting Data
  3. Filtering Data
  4. Advance Filter
  5. Subtotals
  6. Data Validation
  7. Handing Text Files
  8. Format Tables

LESSON 3: ADVANCE FUNCTIONS

  1. Logical Functions
  2. Nested If Function
  3. Using Iserror and Iferror Function to

PREVENT ERROR DISPLAY

  1. Vlookup Function
  2. Hlookup Function

DAY 2

LESSON 4: SUMMARIZING DATA WITH PIVOT TABLES

  1. What is a Pivot Table
  2. Creating Pivot Table
  3. Formatting Pivot Table
  4. Pivot Table Options
  5. Pivot Chart

LESSON 5: SHARING AND PROTECTING

  1. Share a Workbook
  2. Set Tracking
  3. Review Tracked Revisions
  4. Inserting comments
  5. Protecting cells, sheets, files
  6. Password protecting a file

LESSON 6: AUDITING WORKSHEETS

  1. Trace Cells
  2. Troubleshoot Errors in Formulas
  3. Watch and Evaluate Formulas

LESSON 7: IMPORTING AND EXPORTING DATA

  1. Creating New Embedded Objects
  2. Embedding Existing Files
  3. Editing Embedded Objects
  4. Embedding Parts of Files

.

.

.

.

.

FEEL FREE TO ENQUIRE ABOUT OUR RANGE OF TRAINING COURSES