HRDF Funded Course - Advanced Excel Essential Training

Start mastering Excel, the world's most popular and powerful spreadsheet program. Learn how to best enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data and cells, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools.
Topics include:

• Creating pivot Tables
• Creating formulas and functions
• Finding and replacing data
• Using power functions such as IF and VLOOKUP
• Password-protecting worksheets and workbooks
• Analyzing data with Goal Seek and Solver
• Creating and running macros

HRDF SBL Claimable for Employers Registered with HRDF
If you would like to know more about this course please visit:
https://www.tertiarycourses.com.my/microsoft-excel-essential-training-course-in-malaysia.html

Module 1 Pivot Table

• Creating Pivot Tables
• Sorting and Filtering Pivot Tables 
• Formatting Pivot Tables
• Creating PivotCharts

Module 2: Functions & Formulas

• Formula Shortcut Keys
• If and Related Functions
• Lookup and Reference Functions
• Power Functions
• Statistical Functions
• Math Functions
• Date and Time Functions
• Array Functions
• Text Functions

Module 3: Advanced Charts

• Creating Basic Charts
• Style Charts with Design Tabs
• Fine Tune Chart Elements
• Format Tab

Module 4 Data Analysis

• Installing Data Analysis Tool
• Goal Seeker & Solver
• Histogram
• Linear Regression
• Testing a Hypothesis
• Covariance and Correlation
• Bayesian Analysis

Ramzan has been conducting training and lectures in the IT industry for the past 18 years. She started her career as a college lecturer teaching NCC Diploma Computer Studies. Due to her in-depth experience and breadth of knowledge, Ramzan was selected by the Malaysian Ministry of Education to conduct training for Government School teachers called Program Latihan Penggunaan Peralatan TMK PPSMI 5. She has since then further forayed into academia training engagements with both public and private tertiary education institutions such as University Malaya, University Teknologi MARA, University Tunku Abdul Rahman (UTAR), University of Nottingham Malaysia and The SEGi Education Group.

Being an effective communicator with proven ability to build strong working relationships and generating results, Ramzan ventured into the corporate training field with her core expertise in productivity software suite training ie: Microsoft Office, IBM Lotus Smart Suites, Google Docs and Open Office applications