Microsoft Excel Intermediate

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

4.7

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

Chat with us LIVE to get a

FREE QUOTATION!

COURSE DETAILS

COURSE BENEFITS

ALL IN FROM ONLY

RM0/DAY

*T&C Applies

PARTICIPANT REVIEWS FOR THIS COURSE

4.7

  • 69%
  • 31%
  • 0%
  • 0%
  • 0%
  • TW
    Tan Siew Wei
    Junior Executive, Sales

    5

  • LL
    Lee Siat Lian
    Executive, Accounting and Finance

    5

  • SC
    Seow Hui Chien
    Senior Executive, Sales

    5

  • SC
    Seow Hui Chien
    Senior Executive, Sales

    5

  • KK
    Kasmiah Binti Kamaludin
    Junior Executive, Quality Assurance

    5

  • KW
    Koh Xiu Wen
    Junior Executive, Sales

    5

  • KW
    KEK YONG WEI
    Senior Executive, Others

    5

  • SP
    SITI FATIMAH BINTI PIRAMLY
    Executive, Sales

    5

  • TY
    TAN CHEW YEH
    Junior Executive, Accounting and Finance

    5

  • Al
    Amelia loh sook lin
    Executive, Sales

    5

  • NY
    Normasleha Yasin
    Executive, Quality Assurance

    5

  • SL
    SOO TOH HUI LING
    Assistant Manager, Sales

    5

  • LS
    Lsi Fook Sin
    Manager / Supervisor, Sales

    5

  • TM
    Tee Jin Meng
    Manager / Supervisor, Accounting and Finance

    5

  • LK
    Lee Seng Kit
    Manager / Supervisor, Sales

    5

  • LK
    Lee Seng Kit
    Manager / Supervisor, Sales

    5

  • Nz
    Nurvidyana binti zulkafli
    Senior Executive, HR / Learning and Development

    5

  • AA
    AZRUL HISHAM BIN MOHAMED AMIN
    Manager / Supervisor, Project Management

    5

  • EG
    Ehanthalingam Gopaul
    Senior Manager, Others

    5

  • NN
    Nurhidayah binti Mohd Nadzri
    Junior Executive, HR / Learning and Development

    5

  • MA
    Muhammad Firdaus B Abd Aziz
    Junior Executive, Others

    5

    I like how mrs slvia teach me and delivered the knowledge about excel intermediate
  • ZZ
    ZULFADHLI AINUL HAKIM BIN ZULKARNAIN
    Senior Executive, Sales

    5

  • WF
    Wee Siew Fen
    Executive, Procurement / Purchasing

    4

  • TY
    Tong May Yian
    Executive, Others

    4

  • NK
    NURUL AHLINA BINTI KHALIL
    Executive, Quality Assurance

    4

  • SP
    SITI ZUBAIDAH BINTI PIRAMLY
    Executive, Quality Assurance

    4

  • MK
    Muhammad Mustakim Bin Mohamad Khairi
    Executive, HR / Learning and Development

    4

  • TD
    TAN BEE DIN
    Manager / Supervisor, Procurement / Purchasing

    4

  • CO
    Chow Pooi Onn
    C-Level, Accounting and Finance

    4

  • TK
    Tan Jin Keat
    Manager / Supervisor, Project Management

    4

  • CV
    CHANDRA MOHAN VENKATESHWARAN
    Manager / Supervisor, Others

    4

  • NJ
    Nurul Sufiana Binti Jamian
    Senior Executive, Others

    4

OF 4Next

Courses you may like

Optimized by Optimole

MEMBERS ONLY FEATURE

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

LOGIN

[nextend_social_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

[nextend_social_login]

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?