Quality Dynamics Consultancy Sdn Bhd presents

Sep 14 - 15, 2017 (9am - 5pm) at Holiday Inn Kuala Lumpur Glenmarie

Microsoft Excel - Advanced

(by Mr. Chin Chee Chong )

objectives

1.     Create and use defined names in a workbook
2.     Work with logical function in Excel
3.     Use a variety of data validation techniques
4.     Use a range of lookup and reference functions
5.     Create summaries in your spreadsheets using subtotals
6.     Use the Data consolidation feature to combine data from several workbooks
        into one
7.     Create and work with Scenarios and the Scenario Manager
8.     Import data into Excel and Export date from Excel
9.     Create and use a range  of controls in a worksheet
10.   Create recorded macros in Excel
11.   Import Data in Excel and Export data from Excel

program content

Topic 1:  Linking & Consolidate Data

            1.   Linking and Consolidating Data
            2.   Linking Workbooks
            3.   Creating a Link Formula by Paste Link
            4.   Consolidating Data
            5.   Creating a 3-D Formula

Topic 2:  Tables and Sorting

            1.   Managing Tables and Data
            2.   Tables Overview
            3.   Table Terms
            4.   Tips for Setting up a Table
            5.   Creating Tables
            6.   Sorting Data
            7.   Sorting Data: Sort Button
            8.   Sorting Data: Sort Dialog Box
            9.   To sort according to a custom list
            10. To sort according to a formatting criterion

Topic 3:  Data Management

            1.   Filtering Data
            2.   Using Table Filters
            3.   Using Custom Auto Filter
            4.   Turning off the Auto Filter
            5.   Advanced Filtering
            6.   Using Advanced Filter
            7.   Running an Advanced Filter
            8.   Turning off Advanced Filter
            9.   Copying an Advanced Filter to another Location
            10.  Sub-totals
            11.  Adding Sub-totals
            12.  Adjusting views and sub-totals
            13.  Removing Sub-totals
            14.  Re-sorting the Data
            15.  Data Validation
            16.  Dealing with Text Files
            17.  Text Format Files
            18.  Text To Column

Topic 4:  What – If Analysis

            1.   What if Analysis
            2.   Creating Data Tables
            3.   Creating a One Input Data Table
            4.   Creating a Two-Input Data Table
            5.   Goal Seek
            6.   Scenario Manager
            7.   How to Create A Report from a Scenario

Topic 5:  Using IF, VLOOKUP, HLOOKUP, Formula Auditing & Protections

            1.   Auditing a Worksheet
            2.   Tracing Formulas and Errors
            3.   Trace cells that provide data to a formula
            4.   Trace formulas that reference a particular cell
            5.   Watch Window      
            6.   Protecting your files and worksheets
            7.   Protection Options
            8.   Looking & Unlocking Cells
            9.   Workbook Level Protection
            10. Worksheet Level Protection
            11.  File Level Protection

Topic 6:  Using Macros

            1.   Automating Excel with Macros
            2.   Creating & Recording a New Macro
            3.   Running a Macro
            4.   Suspending & running a Macro
            5.   Deleting a Macro
            6.   Saving a Workbook containing Macros

methodology

Lecture, discussion, individual/group exercise, Question and Answer


who must attend

Executives and non-executives who have an intermediate level of Excel knowledge.



(KINDLY TAKE NOTE:  PARTICIPANTS ARE REQUESTED TO BRING THEIR LAPTOP AND EQUIPPED WITH MICROSOFT EXCEL 2010 AND ABOVE VERSION)

investment fee / early bird by 31/08/2017

Standard: RM650.00 Nett PerDay / Not Available per participant

Group discount: Not Available / Not Available per participant for a minimum of 2 participants from the same company

(Fee inclusive of Refreshment, Buffet Lunch, Training Bag, Handouts,  & Certificate of Completion)

registration & payment


PROGRAMS ARE CLAIMABLE UNDER SBL SCHEME

Please register online through www.qdc.com.my or call 03-78054587 / 03-78044196. Our phone line operation hours are from 8:30am to 6:00pm from Monday to Friday.

All registration MUST be accompanied with PAYMENT.

Completed registration form with CHEQUES should be made in favor of "Quality Dynamics Consultancy Sdn Bhd" and sent to:

(FEE PAID IS NOT REFUNDABLE but replacement may be made at no additional cost. Quality Dynamics Consultancy Sdn Bhd reserves the right to cancel or reschedule the above course and shall inform participants of the changes)

COURSE FACILITATOR - MR. CHIN CHEE CHONG

Mr. Chin Chee Chong has been in the Information Technology industry for the past 19 years starting with PC hardware where he is well-versed in troubleshooting and assembling of PCs. Thereafter, he ventured into IT software applications specializing in IT training and development for Microsoft Office users.

He is one of the certified training pioneers in Malaysia having attained his Microsoft Office Specialist Master Instructor (MOS) as well as a list of certifications stating that he has sound knowledge in Microsoft Word, Excel, PowerPoint, Access and Outlook. He also carries the title Microsoft Certified Trainer (MCT) by Microsoft USA. Having spent the last 9 years in this training field, his vast experience has equipped him with substantial knowledge to excel in the training field.

His extensive tutelage experiences are from conducting training courses for a number of corporate companies. Among his software training clients are American Insurance Group Berhad (AIG), Allianz General Insurance Malaysia Berhad, Citibank Berhad, Favelle Favco Berhad, EC-Council Academy, HSBC Bank Malaysia Berhad, Institute of Bankers Malaysia (IBBM), Jerneh Insurance Berhad, OCBC Bank Berhad, Proton Holding Berhad, Shell Information Technology International, Sime Darby Plantation Sdn Bhd, SP Setia Berhad, Wong Engineering Electronics Berhad and many more.

Besides the corporate sector, Mr Chin also trains the government sector such as Jabatan Pengangkutan Jalan (JPJ Academy Malacca), Keretapi Tanah Melayu Berhad (KTMB), Ministry of Health (MOH), Multimedia Development Corporation Sdn Bhd (MDec), Tentera Laut DiRaja Malaysia (TLDM) as well as local universities like UITM Shah Alam, University Tenaga Nasional (UNITEN) and Multimedia University (Cyberjaya & Melaka Campus).