[Online, NEW] Microsoft Excel Training - Intermediate To Advanced
Course Information
  • 06-Nov-2024
  • Online
  • Fakhrul Syahmi
  • BM/English
  • RM 1,400 RM 1,320
    Until 02 Nov 2024
  • 9:00am - 5:00pm

[01] COURSE INTRODUCTION

This training is specifically tailored for individuals who are familiar with the basics of Excel and are eager to expand their proficiency in this powerful spreadsheet software. Whether you're a business professional, analyst, student, or anyone who works with data, this training will equip you with the necessary tools and techniques to work more efficiently and effectively in Excel.

We have carefully structured the training agenda to cover a wide range of topics, including data manipulation and analysis, formulas and functions, advanced formatting techniques, data analysis tools, data validation, and collaboration features. By the end of the day, you will have gained valuable skills and knowledge that can be immediately applied to your everyday work tasks.

 

[02] METHODOLOGY

• Interactive Presentation

• Group Discussions

• Group Activities

• Role Play

 

[03] COURSE OUTCOMES

• Apply advanced data manipulation techniques:

 ○ Sort and filter data efficiently.

 ○ Utilize advanced filtering options for complex data analysis.

 ○ Work effectively with tables and structured references.

 ○ Implement conditional formatting to highlight data patterns.

• Demonstrate proficiency in using formulas and functions:

 ○ Utilize intermediate-level functions such as IF, VLOOKUP, and SUMIF.

 ○ Apply logical functions (AND, OR, NOT) for complex calculations.

 ○ Nest functions to perform advanced calculations.

• Implement advanced formatting techniques:

 ○ Customize cell formatting to enhance visual appeal.

 ○ Apply styles and themes for consistent formatting.

 ○ Create and modify templates for efficient document creation.

 ○ Utilize conditional formatting to visually represent data trends.

• Utilize data analysis tools effectively:

 ○ Create and modify PivotTables and PivotCharts for data analysis.

 ○ Use slicers and timelines to interactively analyze data.

 ○ Apply What-If Analysis tools (Goal Seek, Scenario Manager) for decision-making.

• Simulation

• Sharing Experience

• Gamification Method

• Case Studies

 

[04] DATE/ TIME/ FEE

Date:         6-7 Nov 2024 (Wed-Thu)

Time:         9.00am - 5.00pm
Venue:      Online/ Interactive

 

Fee:  [HRD Corp Claimable]

   - Early Bird Offer (before 22 Oct 2024)      –      RM1260
   - Special Offer (before 2 Nov 2024)      –      RM1320
   - Normal Fee      –      RM1400

 

- Fee includes Course Notes, 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: Remote Online Training (Public)
Course Code: 10001475087

 

[05] COURSE OUTLINE

DAY ONE - INTERMEDIATE EXCEL SKILLS & TECHNIQUES

Module 1 - Templates

• Using templates

• Creating Excel templates

 

Module 2 - Paste Special Options

• Using Paste Special to add, subtract, multiply & divide

• Using Paste Special ‘values’

• Using Paste Special transpose option

 

Module 3 - Pivot Tables

• Using a Pivot Table.

• Filtering and Sorting Data

• Grouping Data

• Creating and using a pivot table.

• Filtering and sorting data within a pivot table.

• Automatically grouping data in a pivot table and renaming groups

• Manually grouping data in a pivot table and renaming groups

 

Module 4 - Input Tables

• One-input data tables

• Two-input data tables

 

Module 5 - Statistical Functions

• Count

• Countif

• Counta

• Countblank

Q&A Session

End of Day One

 

DAY TWO - ADVANCED EXCEL SKILLS & TECHNIQUES

Module 1 - Tracking and Reviewing Changes

• Enabling or disabling the 'track changes' feature

• Sharing, comparing and merging worksheets

 

Module 2 - Scenarios

• Scenario Manager.

• Scenario summary reports

 

Module 3 - Financial Functions

• FV

• PV

• NPV

• RATE

• PMT

 

Module 4 - Lookup Functions

• VLOOKUP

• HLOOKUP

• XLOOKUP

Module 5 - Database Functions

• DSUM

• DCOUNT

• DMIN

• DAVERAGE

• DMAX

 

Module 6 - Macros

• Using Macros

• Assigning a Macro to a Button on the Quick Access Toolbar

• Deleting Macros

Q&A Session

End of Day One

 

[06] TRAINER PROFILE

FAKHRUL SYAHMI

HRDF Certified Trainer

Muhammad Fakhrul Syahmi is a distinguished professional and dedicated trainer with a profound commitment to knowledge transfer and skill enhancement. Armed with a Bachelor of Economy from the esteemed Universiti Kebangsaan Malaysia (UKM), Fakhrul stands out for his proven track record in delivering impactful training sessions across a spectrum of subjects, including technology proficiency, soft skills, and digital marketing.

Fakhrul's expertise encompasses a wide array of core modules, showcasing a comprehensive skill set. Proficient in Microsoft Excel, Word, and PowerPoint, he imparts essential technological skills. His forte extends to Team Building Leadership and Communication, Ethical Management, Business Management (SME), Data Analysis, and Digital Marketing.

At the heart of Fakhrul's training philosophy is the creation of an engaging and interactive learning environment. He believes in practical application, fostering growth through real-life scenarios, case studies, role-playing, and hands-on exercises. Participants in his sessions not only gain theoretical knowledge but also acquire practical skills that they can immediately apply in their professional endeavors.

Fakhrul's commitment to excellence is underscored by a series of certifications, including the

Certified HRD Corp PSMB Train The Trainer (TTT), Professional Certificate in Supervisory Management, and Professional Certificate in Sales & Marketing Operation. Additionally, he holds the prestigious title of a Certified Speaker of Negeri Sembilan Mufti Department and a JAKIM Certified Instructor.

With a rich background in training, Fakhrul has honed his skills through hands-on experience. His training sessions are characterized by their effectiveness, ensuring participants not only grasp concepts but also gain practical insights that enhance their professional capabilities. Fakhrul is not just a trainer; he is a lifelong learner with a passion for staying abreast of industry trends and emerging technologies. This dedication to continuous learning enriches his training sessions, ensuring participants receive the most relevant and up-to-date information.

 

[07] ENQUIRY/ REGISTRATION

Email: 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)
   - Nisa (019 - 851 5134)