Microsoft Excel Advanced Training (21-22 Aug 2017)

Jalan USJ 1/1b Taman Subang Mewah Subang Jaya Selangor Malaysia
0 Days
0 Hours
0 Minutes
0 Seconds

Event Expired

Ticket Information

A good skill to possess especially for your career is the usage of Microsoft Excel. Whether you are looking for a job, currently employed, or a business owner, Excel can assist you in various ways. This course aims to provide skills and knowledge of Microsoft Excel which allows you to increase efficiency and simplify your daily tasks. Students will learn Excel from the very basic to extensive functions, formulas, automation macros, and even the advanced features of Microsoft Excel.


This This training package includes: 

  • 2 Full Day Training (16 Hours) at the venue above 
  •  1 Year Access to Mobile App with step by step videos of Excel Advanced exclusively produced by Excel.my in Bahasa Melayu and English. 
  • Listing in Excel.my Certified User Directory
  • Breakfast, lunch and refreshments 
  • Free flow drinks 
  • Notebook, Stationery and Bag 
  • Certificate of Completion 


100% HRDF Claimable for HRDF registered private companies.


Course Content - Day 1 (Basic) 


LESSON 1: INTRODUCTION 
• Topic A: Using the menus
 Topic B: Versions 


LESSON 2: DATA ENTRY 
• Topic A: Formula Bar
• Topic B: Working with dates and times
• Topic C: Format Cells/ Data Formatting
Topic D: Flash Fill Series 


LESSON 3: CREATING FORMULAS 
• Topic A: AutoSum/Average
• Topic B: Days Formula
• Topic C: Formula Wizard
 Topic D: Audit Formulas (Trace precedent/dependent) 


LESSON 4: FORMATTING
 
• Topic A: Inserting shapes, arrows, and other graphics
• Topic B: Adding and deleting rows and columns
• Topic C: Hiding data
• Topic D: Moving, copying, and pasting
• Topic E: Sorting and filtering data
Topic F: Conditional Formatting / Data Bars / Data Icon Sets 


LESSON 5: INSERTS 
• Topic A: Clipping Screens
• Topic B: Images/ Shapes
• Topic C: Recommended Charts
• Topic D: Linking Charts in PowerPoint
Topic E: Advanced Charts / Combo Charts 


LESSON 6: PRINT 
• Topic A: Print Area
• Topic B: Repeat Titles on print
• Topic C: Page Layout / Page Break 


LESSON 7: SECURITY 
Topic A: Allow people to edit selected cells only (Creating Forms) 
• Topic B: Protecting Worksheet & Workbook (Read Only)
• Topic C: Workbook Encryption (Password to open) 


Course Content - Day 2 (Advanced) 


LESSON 1: FORMULAS IN DEPTH 
• Topic A: IF Function
• Topic B: 3D Formulas
• Topic C: CHOOSE/MATCH/INDEX
Topic D: VLookup / H Lookup 


LESSON 2: DEFINE NAMES 
• Topic A: Create your own names
Topic 2: Define Names in formulas and references 


LESSON 3: PIVOTTABLES 
Topic A: Using PivotTables and Filters 
• Topic B: PivotCharts
• Topic C: Creating extended charts / business charts
Topic D: Gantt Charts 


LESSON 4: GOAL SEEK 
• Topic A: PMT Formula (Loan Calculator)
Topic B: Goal Seek 


LESSON 5: SCENARIO MANAGER 
• Topic A: Create various scenarios
 Topic B: Using Scenarios 


LESSON 6: MACRO, RECORD AND PLAY 
Topic A: Record repeated tasks with Macro 
• Topic B: Add new buttons to your Excel to playback Macros
Topic C: VBA and Macro

 
LESSON 7: MICROSOFT OFFICE SPECIALIST (77-420) OVERVIEW

Location Map

Terms and Condition

  • Training will be conducted at training centre MU DOT MY PLT, NO 24-1 FIRST FLOOR JALAN USJ 1/1B, PETALING 47620 SUBANG JAYA, SELANGOR, MALAYSIA.
  • Rescheduling subject to company’s own policy.
Buy tickets now and stand a chance to win vouchers every week!