Call Us Now | 03 5131 4978

Email Us at icare@asl-solutions.com

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

 Latest Promotion | ASL Training

INTRO | ASL Training

  • 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.

OBJECTIVE-01

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.

METHODOLOGY-01

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

COURSE OUTLINE-01

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

ASL For Members | ASL Training

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

Register Now | ASL Training

Customize Your Own Training Program

Click button below to tells us what kind of training you need.

Get AWESOME Price Now!

Subscribe now and get your special price from us!

We will never give away, trade or sell your email address. You can unsubscribe at any time.