fbpx

Microsoft Excel Intermediate

RM250.00 RM265.00 (after 6% SST)

Duration: 1 day (9:00 am – 5:00 pm)

Category: Tag:

Description

COURSE OBJECTIVES

Upon completion of the course, participant should be able to:

  • Perform reference calculation
  • Using function for data calculation and extraction
  • Organize and filter data in worksheet
  • Create and modify graph in worksheet
  • Managing multi windows of workbook in the same worksheet

TARGET AUDIENCE

This course is suitable for participant such as Admin, Clerk, Manager, data analysis, and others who are using Microsoft Excel for their day-to-day job.

PREREQUISITES

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

  • Have already attended Microsoft Excel Foundation, OR
  • Able to navigate the worksheet user interface
  • Able to use the basic calculus and formula on worksheet
  • Able to manipulate the row and column in worksheet
  • Able to change cell format

METHODOLOGY

  • This course will be conducted with lectures, PowerPoint Presentation, demonstration on lab, and practical exercise.

 

MORE INFO

Training Content

Module 1: Referencing Calculations

Topic A – Formula Reference

  • Relative References
  • Absolute References
  • Mixed References

 

Module 2: Working with Functions

Topic A: Data Summary with Function

  • COUNTA
  • AVERAGEA

Topic B: Conditional Data Summary 1

  • COUNTIF
  • AVERAGEIF
  • SUMIF

Topic C: Conditional Data Extraction

  • IFERROR
  • IF
Module 3: Organizing Dynamic Data Range with Tables

Topic A: Create and Modify Tables

  • Create table
  • Styles and Quick Style Sets
  • Removing Duplicate Values

Topic B: Sort and Filter Data

  • Sorting Data
  • Filtering Data
  • Advanced Filtering

Topic C: Use Subtotal to Calculate Data

  •  Total Row with SubTotal Functions

 

Module 4: Visualizing Data as a Graphics

Topic A: Conditional Formatting

  • Highlight Cell Rules
  • Using Data Bars
  • Using Icon Sets
  • Creating New Rules with Formula

Topic B: Create Charts

  • Charts
  • Chart Types
  • Chart Insertion Methods
  • Resizing and Moving the Chart
  • Adding Additional Data
  • Switching Between Rows and Columns

Topic C: Modify and Format Charts

  • Difference Between Modifying and Formatting
  • Chart Elements
  • Minimize Extraneous Chart Elements
  • The Chart Tools Contextual Tabs
  • Formatting the Chart with a Style
  • Adding a Legend to the Chart

 

Module 5: Setting Up Reports as Pages

Topic A: Managing Multiple Windows

  • Arranging Workbooks
  • Comparing Workbooks Side by Side
  • Synchronous Scrolling and Resetting a Windows