Microsoft Excel Advance Malaysia

Date :

11 – 12 April 2017

22 – 23 August 2017

Duration :

2 days ( 9am – 5pm )

Venue:

Vistana Hotel, Kuala Lumpur

Medium :

English & Bahasa Malaysia

Register Before:

Please refer the brochure to know more.

Who should attend:

• All managerial Levels
• Secretaries / Personal Assistance
• Human Resources
• Finance Department
• Administrative
• Account Department
• And Anyone Who Would Like To Empower Excel Skills

• This Intermediate Microsoft Excel training class is meant for students who want to advance their skill set by learning to work with advanced formulas, lists, and illustrations.
• Students will also work with charts and advanced formatting including styles.
• Your instructor will point out the minor differences between previous versions where they exist.

Upon completion of this program, the participants should be able to:-

• Learn to use formulas and functions.
• Create and modify charts.
• Convert, sort, filter, and manage lists.
• Insert and modify illustrations in a worksheet.
• Learn to use conditional formatting and styles.

• Interactive Lecture.
• Group Discussion
• Simulations
• Analysis & Presentations
• Templates

DAY 1

Unit 1: Managing workbooks and work-sheets

• Topic A: Viewing large worksheets
• Topic B: Printing large worksheets
• Topic C: Working with multiple worksheets
• Topic D: Linking worksheets with 3-D formulas
• Topic E: Using multiple workbooks
• Topic F: Linking workbooks

Unit 2: Advanced formatting

• Topic A: Using special number format
• Topic B: Working with themes

• Topic C: Other advanced formatting

Unit 3: Outlining and subtotals

• Topic A: Outlining and consolidating data
• Topic B: Creating subtotals

Unit 4: Cell and range names

• Topic A: Creating and using names
• Topic B: Managing names

Unit 5: Data structure and tables

• Topic A: Sorting and filtering data
• Topic B: Working with tables

Unit 6: Web and sharing features

• Topic A: Saving workbooks as Web pages
• Topic B: Using hyperlinks

Unit 7: Documenting and auditing

• Topic A: Auditing features
• Topic B: Comments in cells and workbooks
• Topic C: Protection
• Topic D: Workgroup collaboration

Unit 8: Application settings and templates

• Topic A: Application settings
• Topic B: Working with templates

DAY 2

Unit 1: Advanced functions and formulas

• Topic A: Logical functions
• Topic B: Conditional functions
• Topic C: Financial functions
• Topic D: Text functions
• Topic E: Date and time functions
• Topic F: Array formulas
• Topic G: Calculation options

Unit 2: Lookups and data tables

• Topic A: Using lookup functions
• Topic B: Creating data tables

Unit 3: Advanced data management

• Topic A: Validating cell entries
• Topic B: Advanced filtering

Unit 4: Advanced charting

• Topic A: Chart formatting options
• Topic B: Combination charts
• Topic C: Graphical objects

Unit 5: PivotTables and Pivot Charts

• Topic A: Working with PivotTables
• Topic B: Modifying PivotTable data
• Topic C: Formatting PivotTables
• Topic D: Using Pivot Charts
• Topic E: Power Pivot

Unit 6: Exporting and importing data

• Topic A: Exporting and importing text files

Unit 7: Analytical tools

• Topic A: Goal Seek
• Topic B: Scenarios
• Topic C: Instant data analysis

Download Brochure