[01] INTRODUCTION
This course provides participants with a more in depth knowl- edge of Microsoft Excel. Participants gain knowledge on working with Name Ranges, more complex formulas and functions, Charts, filtering and sorting tables and adding subtotals. Participant will know how to highlight important data using conditional formats. At the end of the course, the participant will be able to demonstrate the ability to perform complex calculation and manage data efficiently with Microsoft Excel.
[02] REQUIREMENT
• Delegates enrolling for this course shall possess basic MS Excel skill
• 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.
[03] PREREQUISITES
Microsoft Excel [Any Version] Introduction or equivalent skills. Must be able to create, open, save, format and print a worksheet. Should be able to use formulas and the SUM function. The ability to copy, move and delete values and formulas is required.
[04] COURSE OBJECTIVES
• Differentiate yourself at work. Quickly and dramatically
• Format sheets and charts professionally
• Understand advanced Excel functions
• Use Cell Styles and format spreadsheets easier and faster
• Learn several hidden Excel tips and tricks
• Become comfortable and familiar with the entire
• Excel dashboard, tabs and ribbons
• Use the most commonly used Excel functions to make powerful calculations
• Create your own Excel charts, graphs and tables
• Create pivot tables and charts for lightening fast sorting and organizing
• Learn tips, tricks and shortcuts along the way to help you master the Excel
[05] WHO SHOULD ATTEND
• People who are ambitious and want to grow faster than their peers
• First time beginner who needs to learn much more than just the basics
• An intermediate Excel user who needs to improve their skills in areas such
as using functions; creating charts, graphs and tables; creating pivot tables and charts; formatting spreadsheets; navigating efficiently within an Excel worksheet and more.
• Those who seek to increase personal productivity, efficiency at work or even developing skills to obtain a better job
[06] DATE/ TIME/ FEE
Date: 23 - 24 September 2024 (Mon - Tue)
Time: 9.00am - 5.00pm
Venue: CPD Academy, RIO Puchong
Fee: [HRD Corp Claimable]
- Early Bird Offer (before 6 Sep 2024) – RM1,070
- Special Offer (before 20 Sep 2024) – RM1,130
- Normal Fee – RM1,190
- Fee includes Course Notes, Meals, Certificate of Completion and 8% 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: Public
Course Code: 10001350349
[07] COURSE OUTLINE
Day 1
Module 1: Back to Basics
• Essential shortcuts
• Basic Formulas and Functions
• Flash Fill
Module 2: More on Formulas
• Absolute, relative and mixed formulas
• Understanding Functions
• Using the Autosum, Average, Count, Max and Min Functions
Module 3 : Name ranges
• Understanding and Defining Named Ranges
• Editing Named Ranges
• Using Named Ranges in Formulas
Module 4 : Detailed Functions
• Text Functions
o Upper, Lower Proper
o Concatenate
o Replace
o Substitute
o Clean and Trim
• Date & Time Functions
o Inserting Current Date and Time
o Date Calculations using
⌑ Datedif
⌑ YearFrac
⌑ Workdays
• Mathematical & Statistical Functions o Countif
o Sumif
o Averageif
⌑ Logical Functions
o If Function
o And /Or Functions
⌑ Lookup Function
o Basic Vlookup & Hlookup
Q&A Session
End of Day One
Day 2
Module 5 : Data Management
• Working with Tables
• Sorting & Filtering data
• Filtering data in a table
• Subtotals
• Conditional Formatting
Module 6 : Charts
• Creating Charts
• Modifying chart
• Printing a chart
• Creating combination charts/dual axis charts
• Creating custom chart templates
Module 7 : Auditing Formulas
• Tracing Formula Precedents and Dependents
• Showing Formulas
• Evaluating Formulas
• Using the Watch Window
Q&A Session
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 accredit- ed 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:
- Whatsapp Only (012 - 824 8874)
- General - (03 - 8604 7270)
- Teo (011 - 3178 9203)
- Logesh (012 - 503 0346)
- Siti (012 - 383 8603)
- Han (019 - 323 0507)
- Nisa (019 - 851 5134)