MICROSOFT EXCEL FOR ADVANCE

Course Synopsis

In this course, students will learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, and protect worksheets and cells

Course Objectives

Upon successful completion of this course, students will be able to:

• Increase productivity and improve efficiency by streamlining your workflow.
• Analyze data using pivottables and pivotcharts.
• Data and worksheets protections

 Pre-requisite: Usage of Excel Intermediate Level

 Method of Instruction: 80 % Hands on training and 20% theory

 Language : Bahasa Melayu and English

Course Content

 Module 1: Using IF Function

• Simple IF examples
• How to get started
• More IF examples
• Nested IF example
• Common problems
• AND function
• OR function
• COUNTIF function

 Module 2: VLOOKUP & HLOOKUP function

• Using VLOOKUP
• Using HLOOKUP
• Using nested VLOOKUP & HLOOKUP function

 Module 3: Intro to PivotTables

• Pivoting data
• Filters
• Slicers
• To add a slicer
• PivotCharts
• To create a PivotChart

 Module 4: Create a macro

• Record a macro
• Run a macro
• Assign a macro to an object, graphic, or control
• Savea macro enable file

 Module 5: Track Changes and Comments

• Understanding Track Changes
• To turn on Track Changes
• To list changes on a separate worksheet
• Reviewing changes
• To add a comment
• To edit a comment
• To show or hide comments
• To delete a comment

 Module 6: Inspecting and Protecting Workbooks

• Introduction
• Document Inspector
• Protecting your workbook

Iskandar has been a trainer in the IT industry since 1993 but became fully active in training
since 2000. He had obtained a LCCI Diploma in data processing in 1998 and graduated in
Bachelor in Human Resource Development in 2005 and Master in Human Resource
Development in 2016 from University Putra Malaysia. He too has obtained a professional
certificate in human resource management from OUM in 2013. Since then has been doing
various training for corporate and individuals needs. He is also a certified A+ instructor,
Microsoft Office Associate Powerpoint 2019, Microsoft Office Associate Word 2016,
PowerPoint 2007 & 2010, Access 2007, Microsoft Office user specialist (MOUS) PowerPoint
2000 and full ICDL certified. His areas of expertise includes Office packages and
automations, Web design and Internet, computer maintenance and Google applications.

No. of Days:	1
Total Hours:	8