Project Description

Microsoft Excel 2013 Advanced

This course covers tasks such as consolidate data from multiple worksheets/workbooks; working with auto-filters, data validation, conditional formatting, pivot table and built in functions.

  • Difference of cell and range references used in formulas.
  • Making an exact copy of a formula and creating own formula.
  • Converting formulas to values, preventing formulas from viewing and the type of formula errors.
  • Various ways of creating cell and range names.
  • Using name to store formulas.
  • Working with arrays in formula.
  • Have a deep understanding on how functions work Develop killer formulas hence creating powerful spreadsheet.

Module 1: Managing Data

  • Custom Lists
  • Sorting Data
  • Subtotals

Module 2: Manipulating View

  • Outlining
  • Views

Module 3: Functions

  • IF
  • Count Function
  • CountA Function
  • CountIF, CountIFs function
  • SumIF, SumIFs function
  • VLookup and HLookup functions
  • Lookup Functions

Module 4: Data Validation

  • Applying Data Validation
  • Types of Data Validation
  • Display Error Messages

Module 5: Worksheet Protection, Workbook Protection and Shared Workbook

  • Protect worksheet with password
  • Protect workbook Structure with password
  • Create a Shared Workbook
  • Remove forgotten Worksheet and Workbook password using Notepad

Module 6: Advanced Conditional Formatting

  • Applying Formulas in Conditional Formatting

Module 7: Filtering a List

  • AutoFilter
  • Advanced filter
  • Computed criteria
  • Database functions

 Module 8: Linking Workbooks and Consolidating Data

  • Linking workbooks
  • Consolidate by position
  • Consolidate by category
  • Create links to update data

 Module 9: Pivot Table

  • Creating PivotTables
  • Working with PivotTable Components
  • Analysing Multidimensional Data with PivotTables

This course is highly recommended for those who want to understand the features of spreadsheets and want to demonstrate the ability to expertly use a spreadsheet application.

  • Expert Input, Instructions
  • Comprehensive Notes, Workbook & Handouts
  • Group Discussions, Presentations
  • Group & Individual Exercises
  • Video Clips, Brainstorming Sessions
  • Practical Hands On Sessions
  • Demonstrations

1. Miriam

Miriam has over 10 years of experiences as Freelance Trainer / VBA Consultant & Project development / Course Development.

Educational Background

Master of Computer Science

Master of Computer Science fully research at title “classification of lichen species using artificial neural networks”

University of Malaya

B.Sc. (Hons.) Computing

University of Portsmouth, United Kingdom

Adv Diploma in Computer Studies – Informatics KL

NCC Diploma in Computer Studies – Informatics PJ

Informatic Groups

Courses Conducted

  1. Trained on Microsoft Office Applications
  2. Trained on Excel VBA, Excel VBA with Microsoft Access Database
  3. VB/C# Visual Studio 2005
  4. Front page 2003 and Web Expression
  5. Project 2003/2007
  6. C# for Outlook programming
  7. Crystal Report
  8. Perl
  9. Java and etc

Certification

  • Sun SL-275 Java Programming Language Instructor
  • Sun SL-275 Java Programming Language Certificate
  • Cisco Certified Network Associate (CCNA)
  • Advanced Java Certificate of Attendance by IEC (Infortech Sdn Bhd)

2. Mohamad Ridzuan bin Abdul Rashid

Born in 1972. Received early education in Kuantan, Pahang and graduated Diploma in Information Technology in Kuala Lumpur. Experienced in IT since 1986 and started to be an in-house Microsoft Office trainer for Oil & Gas multi-national foreign company since 1997. Moved into IT Corporate training as a freelance trainer since 2007.

Educational Background

  • SPM – Science (1989)
  • Diploma – Information Technology (2007)
  • Licentiate Wedding and Portrait Photographers of Asia (2013)
  • CCIG Accredited Event Photographer (2016)

Certifications

  • Microsoft Certified Trainer
  • Microsoft Office Specialist Double Master
  • Word Expert
  • Excel Expert
  • PowerPoint
  • Outlook
  • Access
  • Certified Shell IT Trainer
  • Exempted HRDF SBL Khas

Courses Conducted

  1. Word
  2. Excel
  3. PowerPoint
  4. Outlook
  5. Office 365
  6. Excel Power Apps
  7. Power BI
  8. Access
  9. VBA
  10. Project
  11. OneNote
  12. Publisher
  13. Other Trainings
  14. G Suite (Google)
  15. Digital Photography

Work Experience

  • Oil Palm Plantation – Accounts and Admin (1990 – 1995)
  • Golf & Resort – Accounts and Admin (1995 – 1997)
  • Oil & Gas – Materials Controller and Procurement (1997 – 2005)
  • Freelance IT Consultant and Trainer (2007 – Present)

3. SHOBAH YOGA 

Shobah is a trainer who can put participant at ease and strike a conversation easily. She wants the trainees to feel good after attending her training class. She’s a very passionate trainer and willing to compensate more than what is required to be taught. She hopes to make a positive impact in each trainee that attends her training programme.

Educational Background

NCC DIPLOMA IN COMPUTER STUDIES Stamford College, PJ

Basic Computer Principles, Computer, Programming (Basic & COBOL), Rel. Math &

Stats, Accounting Methods, Business Organization, Business Communication, WordStar, Lotus 1-2-3, Dbase 3+

Courses Conducted

  • Microsoft Office Specialist Master Instructor – Microsoft Office 2000
  • Microsoft Office Specialist Master Instructor – Microsoft Office XP
  • Microsoft Office Specialist: Excel 2007 – (Certiport)

Work Experience

Freelance Trainer

July 2004 to Present

  • Have been training at a Training Centre in Boulevard, Midvalley and on site at organizations like HSBC, Great Eastern, OCBC, Sony, Citibank, Standard Chartered, Mah Sing, MIMOS, and Bank of Tokyo
  • Provide software and hardware training to members of administration, faculty, staff and students
  • Technical writer – develop and re-design step-by-step training materials for end-users
  • Have been training extensively in Excel, Word, Power Point & Access

TRAINER/COMAT TRAINING SERVICES SDN. BHD. 

March 2000 to July 2004

  • Prepare lessons for lab tutorials and design class examples for hands-on instruction
  • Instruct students on use of complete MS Office package
  • Repair and troubleshoot software and hardware problems

ADMINISTRATIVE ASSISTANT/SMPD MGMT CONSULTANT S/B

June 1998 to February 2000

  • Reproduce books using Microsoft Word’97
  • Proofreading books prepared by administrative clerks
  • Extract and input all cases from Industrial Law Report and Current Law Journal into Industrial Court, High Court or Court of Appeal using in-house software.
  • Attend to all CEO needs in the absence of the Secretary.
  • Prepare brochures and scan picture to create book covers.
  • Knowledge in Labour Law Wizard (created and marketed by SMPD), which includes updating the latest questions/answer, documentation and section.

LECTURER/PDX COMPUTERS SDN BHD

June 1998 to January 1997

  • Conduct in-house and on-site training for clients from multi-national companies and financial institution.
  • Develop IT manual, exercise and outline

TRAINING EXEC/TRAINING COORDINATOR/GRAPHIC ARTIST/HSS INTESYS SDN BHD

May 1995 to January 1997

  • Conduct in-house training for staffs
  • Develop IT manual, exercise and outline
  • Diagnose and troubleshoot software and hardware problems
  • Responsible for opening and closing computer labs
  • Assist and train students with use of computers
  • Create artwork for advertisement using Adobe Photoshop

TRAINER/IT CAT SDN BHD

June 1994 to February 1995

  • Instruct students on use of complete MS Office package

CLERK/SIME DARBY MRKT CTR SDN BHD

January 1991 to February 1995

  • Typing Liquor Agreement using Professional Write
  • Preparing Purchase Order for Embassy Liquor Purchase
  • See to all the needs of the Sales Executive in the department

Enquiry for In-House Training

Company Name *

Address *

Your Name *

Tel *

Email Address *

Training Requirements *