Liner Semiconductor
Date :
To Be Confirm (Please Contact Us For More Detail 03-51314978)
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