[Online, 2-Day] Microsoft Excel Intermediate
Course Information
  • 04-Mar-2024
  • Online
  • Beatrice V. Xavier
  • English
  • RM 850 RM 800
    Until 26 Feb 2024
  • 9:00am - 5:00pm

[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:       4-5 Mar 2024 (Mon-Tue)

- Time:       9:00am - 5:00pm

- Mode:     Online/ Interactive

 

 

Fee:  [HRD Corp Claimable]

    - Early Bird Offer (before 12 Feb 2024)             -         RM 750

    - Special Offer (before 26 Feb 2024)             -         RM 800

    - Normal Fee         -         RM 850

 

- 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: 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

 

Email: yes@sst2u.com

Contact:

- General (03 - 8604 7270)

- Teo (011 - 3178 9203)

- Logesh (012 - 503 0346)

- Siti (012 - 383 8603)

- Han (019 - 323 0507)