Sale!

Microsoft Excel 2013 Intermediate

RM850.00

Objective

Upon completion of this program, participants should be able to:

  • Create formulas and functions, like:
  • COUNTIF Function
  • AVERAGEIF Function
  • SUMIF Function
  • Database Function
  • Manage Table with using Auto Filters
  • Advanced Chart Formatting
  • Apply Simple Conditional Formatting

Prerequisites

Basic knowledge of Microsoft Excel is essential with the following pre-requisites:

  • 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 create basic formulas – Addition, Subtraction, Multiplication and Division
  • Able to use basic functions – AutoSum, Count, Max, Min and Average functions.

Who Should Attend

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.

Methodology

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

Module

  • WORKING WITH FORMULA
    • Lesson 1.1 – Freeze Cell
      • Understanding Relative Cell Reference
      • Understanding Absolute Cell Reference
      • Understanding Mixed Cell Reference
  • WORKING WITH FUNCTION
    • Lesson 2.1 – Using Statistical Function
      • COUNTIF Function
      • AVERAGEIF Function
    • Lesson 2.2 – Using Mathematical Function
      • SUMIF Function
    • Lesson 2.3 – Using Database Function
      • DSUM Function
      • DCOUNT Function
      • DAVERAGE Function
      • DMAX Function
      • DMIN Function
  • MANAGING TABLES
    • Lesson 3.1 – Manipulating Records
      • Quickly Add Records to a Table
      • Cleaning up Duplicate Records
    • Lesson 3.2 – Working with Filters
      • Number Filter
      • Text Filter
      • Date Filter
      • Filtering with Wildcard Characters
  • SHOWING DATA AS GRAPHIC
    • Lesson 4.1 – Conditional Formatting
      • Highlight Cell Rules
    • Lesson 4.2 – Advanced Chart Options
      • Use Recommended Chart
      • Changing the Source Data
      • Working with the Chart Axes and Data Series
      • Saving a Chart as a Template
      • Creating Combo Chart
      • Adding Secondary Axis
      • Fine Tune Charts Quickly
      • Richer Data Labels
  • FINALIZE WORKBOOK
    • Lesson 5.1: Finishing Workbook
      • Publishing to PDF or XPS
      • Protecting the Current Sheet
    • Lesson 5.2 – Working with Different Views
      • Using Custom view
      • Using Page Layout View
      • Express Header & Footer
    • Lesson 5.3 – Managing Multiple Windows
      • Arranging Workbooks
      • Comparing Workbooks Side by Side
      • Synchronous Scrolling and Resetting a Window

Fee: RM 850 per pax

Loyalty Points: 850 Points

Duration: 1 Day

Note: In-house course is available. Request it HERE

Trainer

Siti Suriani Shih Othman

Biodata:
With more than 10 years of working experience to her belt, Siti Suriani is currently doing corporate trainings for various public and private sector, mainly on Microsoft Office Application. She was previously a lecturer with Cosmopoint College of Technology and University Technology MARA, supervised students’ laboratory sessions, prepared lecture notes, modules and materials. Some of the courses taught by her included Multimedia Development Methods, Digital Media For Interactive Application, Computing Fundamentals, Object Oriented Programming II, PC Maintenance, Computer Architecture, Database Management, System Analysis and Design, Java Programming and many more.She has also attended instructors training workshop organized by UPM and was involved in Centralized Exam Paper Marking conducted by UPM. Other short courses that she has also attended are Train The Trainer and soft skills trainings.