[01] INTRODUCTION
This course covers the more advanced features of Microsoft Excel. Participants will learn the advanced features of Excel. They will learn to use data analysis tools like Pivot Tables, Goal Seek and Scenarios. They will also master lookup functions, protect valu- able information and automate tasks by recording and running a simple macro.
[02] COURSE OBJECTIVES
Upon completion of this course, participants will be able to understand and learn:
• Master lookup functions, use relevant text functions to clean up data
• Protect valuable information
• Analyze data with Pivot Table
• Tweak charts
• Automate tasks with macro and VBA
[03] COURSE SCOPE
Interactive workshop and practical exercises and quizzes using unique, proven learning methods.
[04] REQUIREMENTS
Attendees who have good knowledge of Excel, preferably Intermediate level users.
The course can be performed in either Excel 2016 or Office 365 Excel Application. Delegates are required to bring along a laptop with sufficient battery power and/or power charger.
[05] WHO SHOULD ATTEND
• People who are ambitious and want to grow faster than their peers
• Anyone who wants to use Excel at its best, e.g. HR managers, project managers, revenue managers, finance managers and administrative personnel who are in the basic to intermediate group wishing to improve their competencies
• This course is helpful for increasing personal productivity, efficiency at work or even developing skills to obtain a better job
[06] DATE, TIME & FEE
Date: 18-19 Dec 2023 (Mon-Tue)
Time: 9.00am - 5.00pm
Mode: Online/ Interactive
Level: Advanced
[HRD Corp Claimable]
Fee:
- Early Bird Offer (before 30 Nov 2023) – RM800
- Special Offer (before 12 Dec 2023) – RM880
- Normal Fee – RM960
Fee includes Course Notes, Certificate of Completion and 6% Service Tax
** OFFER **
- 10% Cashback for SST2u Learner Card+ (SLC+) members. T&Cs applied.
HRDCorp Claimable Course:
Trainer MyCoiD: 429594X
Course Scheme: HRDCorp Claimable Course
Course Type: Remote Online Training (Public)
Course Code: 10001260482
[07] COURSE OUTLINE
DAY 1
Module 1: Quick Review
• Essential shortcuts
• Flash Fill 10.30am Morning Tea Break
Module 2: Data Validation
• Data validation settings & options
• Create drop-down list
• Custom Validation
Module 3 : Lookup Functions
• Vlookup and Hlookup Functions
• Xlookup (Office 365)
Module 4 : Tweak Charts
• Linking cells to chart
• Conditionally format a series
• Using custom data labels
• Identifying the highest/lowest range
• Using shapes/images in a series
End of Training
DAY 2
Module 5: Pivot Tables
• Understand PivotTable terms and layouts
• Adding field row, column, values
• Show Report filter pages
• Explore ‘Summarize Values By’
• Grouping data
• Explore ‘Show Values As’
• Insert Slicers, Timeline
• Pivot Chart
Module 6 : What IF analysis
• Goal Seek
• Scenario Manager
Module 7 : Protecting Data & Structure
• File Encryption
• Protect Worksheet
• Multiple range/user password
• Protect Workbook structure
Module 8 : Form Controls & Macros
• Recording & running a Macro
• Assigning Macros
• Using Form Controls
End of Training
[08] TRAINER PROFILE
BEATRICE V. XAVIER
Microsoft Office Expert, HRD Corp Accredited Trainer
Beatrice is one of the pioneer trainers of Microsoft Office training programs. She is a holder of ICL and NCC Diplomas in Computer Studies, as well as a Microsoft Office User Specialist. She is a certified Microsoft Office training consultant and is accredited by Pembangunan Sumber Manusia Berhad
(PSMB/ HRD Corp).
Over the past 29 years, she has trained countless organizations both within and outside of Malaysia, including in Thailand and Brunei. She has rendered services to MNCs, Governments, SMEs and NGOs.
As a training consultant, she is well experienced in conducting customized, onsite and remote online trainings in both English and Bahasa Malaysia. Her patience, flexibility in tailoring the courses to the needs of the participants have made her training a success and her services much in demand.
[09] ENQUIRY & REGISTRATION
Enquiry: yes@sst2u.com
Contact:
- General - (03 - 8604 7270)
- Teo (011 - 3178 9203)
- Logesh (012 - 503 0346)
- Siti (012 - 383 8603)
- Han (019 - 323 0507)