Microsoft Excel Intermediate Training

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

• Participants will learn how to create and edit charts; modify chart options; format chart objects; work with multiple worksheets and workbooks, and working with formulas and functions. Students will also gain hands-on experience using styles, custom formats, and conditional formatting.

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

• Create and apply templates
• Create and modify charts, and graphs
• Gaining in web business application
• Calculate with advance formulas
• Sort and filter data
• Using Excel as a decision making

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

DAY 1 

LESSON 1 – Introduction to Excel:  What is a Spreadsheet? 

• Introduction to Spreadsheets
• Introduction to Microsoft Excel
• The File Menu
• Modifying a Worksheet
• The Page Setup Command
• Cell ranges
• Copy Command
• Move Operation
• Formatting
• Format Cells Command

LESSON 2 – Gaining Proficiency:  The Web and Business Applications 

• Enhance Excel Application
• Excel and the Internet
• Web Queries

LESSON 3 – Graphs and Charts:  Delivering a Message 

• Chart Types
• Creating a Chart
• Multiple Data Series
• Object Linking and Embedding

DAY 2

LESSON 4 – Using Spreadsheets in Decision Making:  What If?

• Spreadsheets in Decision Making
• Data Table
• Other Functions
• Working with Large Spreadsheet

LESSON 5 – Autofilter Command

LESSON 6- Consolidating Data:  Worksheet References and File Linking

• Consolidating Data
• The Three-Dimensional Workbook
• Worksheet References

LESSON 7- Linking Workbooks

LESSON 8- List and Data Management:  Converting Data to Information 

• Implementation in Excel
• List and Data Management
• The Text Import Wizard

Data versus Information

Download Brochure