Microsoft Excel Intermediate

All versions available. Outline version below is Microsoft Excel 2019. If you need assistance just chat with us LIVE.

4.8

Course Objectives

  • Create simple to complex formulas and functions, like:
  1. COUNTA & COUNTIFS Function
  2. AVERAGEA &AVERAGEIFS Function
  3. SUMIF & SUMIFS Function
  4. IF Functions
  5. Nested Functions
  6. Database Function
  • Validate data in a Worksheet
  • Filter data using Auto & Advanced Filters
  • Advanced Chart Formatting
  • Clean Duplicate Records
  • Visualizing Data as a Graphics

Target Audience

This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know and understand and want to further enhance their knowledge and practical uses of Microsoft Excel.

  • Have attended Microsoft Excel – Foundation Level; OR
  • Able to switch between task applications
  • Able to create a spreadsheet with simple formatting
  • Able to create a basic chart
  • Able to print a spreadsheet with headers and footers added
  • Able to use Auto Filter command
  • Able to apply Freeze Pane command
  • Able to create basic formulas – Addition, Subtraction, Multiplication and Division
  • Able to use basic functions – AutoSum, Count, Max, Min and Average functions.
 

Methodology

This program will be conducted with interactive lectures, PowerPoint presentation, discussions and practical exercise.

Course Modules

  • Module 1: Referencing Calculations

    Topic A: Formula Reference

    Topic B: Apply Range Names

  • Module 2: Working with Functions

    Topic A: Data Summary with Function

    Topic B: Conditional Data Summary 1

    Topic C: Conditional Data Extraction

    Topic D: Conditional Data Summary 2

  • Module 3: Organizing Dynamic Data Range with Tables

    Topic A: Create and Modify Tables

    Topic B: Sort and Filter Data

    Topic C: Use Subtotal to Calculate Data

    Topic D: Data Validation

  • Module 4: Data Visualization

    Topic A: Conditional Formatting

    Topic B: Create Charts

    Topic C: Modify and Format Charts

    Topic D: Adding Sparklines

    Topic E: Editing Sparklines

  • Module 5: Setting Up Reports as Pages

    Topic A: Working with Different Views

    Topic B: Managing Multiple Windows

Get To Know The Trainer

Trainer Jarina

 4.5

Managing and maintaining a Microsoft Windows Server 2003 Environment - educate the IT professionals who implement, manage, and troubleshoot existing network and system environments based on the Windows Server 2003 platform. Implementation responsibilities include installing and configuring parts of systems. Management responsibilities include administering and supporting systems

Trainer Shalina

 4.5

Shalina has   20   years   of experience in IT related fields including 11 years in conducting public courses. She specializes  in  Corporate  IT  infrastructure  planning  (networking,  troubleshooting and  system  integration),  conducts  applications  training  programs  such  as Microsoft,  Adobe,  Lotus  and  COMPtia  products  as  well  as  organizes  and conducts exhibitions and seminars.

Trainer Izham

 4.5

Izham has 14 years of teaching background with 4 years in the academic department of a public university followed by corporate clienteles in the later years. Since becoming a corporate trainer, Izham has been helping office workers all over cope with data and document volumes in digital form to become efficient and come out being smart office workers.

Trainer Slyvia

 

Sylvia has been in the IT Training Industry for the past 20 years She began her career as a Corporate Trainer and her personal areas of expertise are wide; encompassing Microsoft and Adobe applications. In addition to that; she also specializes in corporate coaching for government, multi-national companies to local SMEs

Trainer Beatrice

 4.5

Beatrice has been in the training industry for the past 27 years being one of the pioneer trainers of Microsoft Office training programs. She has vast experience having trained many people from various corporate sectors. She is a certified Microsoft Office training consultant and is accredited by Pembangunan Sumber Manusia Berhad (PSMB/HRDF).

  View more trainers

Chat with us LIVE to get a

FREE QUOTATION!

COURSE DETAILS

COURSE BENEFITS

ALL IN FROM ONLY

RM949/DAY

RRP RM2,500/DAY   SAVE RM1,551

*T&C Applies

PARTICIPANT REVIEWS FOR THIS COURSE

4.8

  • 85%
  • 15%
  • 0%
  • 0%
  • 0%
  • NM
    Nur suhaily binti Muhamad
    Executive, Others

    5

  • JS
    Judith Molly S.Cyrillus
    Executive, Operations

    5

  • NY
    NUR LIYANA BINTI YUSOF
    Executive, Accounting and Finance

    5

    Enjoyable Excel Training
    En Azrul was very patient and let us explore Ms excel. always ask us if we understand the task or topic discuss. loud and clear.
  • MA
    MUHAMMAD AKRAM BIN ABDUL AZIZ
    Executive, Operations

    5

    Very good, mantabbb choiii, speaker sangat bagus
    A++ well done to speaker and team
  • Na
    Nooriani Binti aesa
    Executive, Accounting and Finance

    5

    No coment
  • LM
    Leong Chin Mooi
    Assistant Manager, HR / Learning and Development

    5

  • NB
    Nur Iryani Binti Baharom
    Executive, Others

    5

    MS Office Excel Intermediate
  • MA
    Mohd Fazriee Bin Awang
    Executive, Engineering

    5

    Excellent
    Mantappp chooii
  • NI
    Nora Ismail
    Senior Executive, Quality Assurance

    5

    Good training course
    Join the training, you will start work efficiently.
  • MR
    MUHAMMAD QUYYUM BIN RUSLAN
    Junior Executive, Research and Development

    5

  • MM
    MUHAMMAD NURAZRI BIN ABDUL MALIK
    Junior Executive, Operations

    5

  • MZ
    MUHAMMAD AFIQ BIN ZAINAL
    Executive, Warehousing / Logistics

    5

    Comfirm akan pandai
    Clear explaination
  • SH
    SITI NUR DAYANA BINTI HAMDAN
    Executive, Warehousing / Logistics

    5

    Great Class!
    Trainer are very engaging. Good exercises to apply what we learn on the spot.
  • MM
    MUNIR IQBAL BIN AHMAD MUNIR
    Junior Executive, Engineering

    5

  • MH
    MADIHAH BINTI HASHIM
    Junior Executive, Engineering

    5

    Excel training
  • JS
    Jeyarani Sinniah

    5

  • NH
    Noorhazera Binti Hamdan

    5

  • AS
    Ashman S

    5

  • EE
    Elanganesan Elanggovan

    5

    Awesome
    Such a great time
  • MF
    Mohamed Aslam Bin Mohamad Fawzi

    5

    Good trainer
  • TP
    Thahrah Binti Pakwanteh

    5

    Excel Training (intermediate)
  • SS
    SHARMINI A/P SOOSAI

    5

    Intermediate Excel Training
    The trainer Ms Slyvia was extremely patient with us and really guided us throughout the training. The info share will be very useful in our daily task.
  • JG
    Jasmine Alicia Gregory

    5

  • AS
    Alvin Sobhan Rao Subramaniam

    5

    5 stsr
  • NA
    Nurhassan Bin Aziz

    5

  • JC
    Jacinta Chandrasekaran

    5

  • AA
    Adilah Yasirah binti Azli

    5

    Good, keep it up!
    Thank you so much Slyvia, you did a great job, keep it up !
  • NM
    Nageswarie A/p Mahindran

    5

    Excel training
    Good job
  • NK
    Nor Azrin Mohd Kamal
    Junior Executive, Administration / Secretarial

    4

    Excel Intermediate
    Great training with good knowledge and many new information on Excel. Thank you.
  • RS
    Rossimah Mohd Saad
    Junior Executive, Operations

    4

    Satisfied
    Satisfied
  • BL
    BOON YIAN LEE
    Junior Executive, Operations

    4

    No comment
    No comment
  • Nh
    Nur liyana hanani bt hassan
    Executive, Warehousing / Logistics

    4

    Good experience
  • AK
    Aaron Chan Min Kitten

    4

OF 4More

Courses you may like

MEMBERS ONLY FEATURE

Kindly sign-up or log-in to get access.

LOGIN

Login with your social account

or

Don’t have an account with us?

FREE FOR LIFE

Sign Up to Bookmark your Favourite Course
or Request for a Quotation instantly

Sign in with your social account

or

By signing up, you agree to our Terms of Use and Privacy Policy

Have an account with us already?