Trainer: Mohamed Iqbal
Course Fee: $98
Duration: 12 hours
Venue:@Community Clubs
See Schedules
Personal Coaching Available -WhatsApps 96550159. Moh Iqbal
For Enquiry WhatsApp Mohamed Iqbal



Participants will learn how to use Microsoft Excel to perform calculation and some simple functions, creating chart and understanding the use of spreadsheet.

Course Outline

Getting Started

  • Spreadsheets
  • File Ribbon Tab(Backstage View)
  • Ribbon
  • Quick Access Toolbar

Working with a Workbook

  • Create a Workbook
  • Save a workbook
  • Open a Workbook
  • Entering a Data

Manipulating Data

  • Select Data
  • Copy and Paste
  • Cut and Paste
  • Fill Handle
  • Undo and Redo
  • Flash Fill (New!)

Modifying a Worksheet

  • Insert Cells, Rows and Columns
  • Delete Cells, Rows and Columns
  • Modifying column, row and cells
  • File and Replace
  • Go To Command
  • Spell Check
  • Entering Formulas
  • Function Library


  • Excel Formulas
  • Function Library
  • Relative and Absolute
  • Linking Worksheets

Formatting a Worksheet

  • Convert Text to Columns
  • Modify Fonts
  • Format Cells Dialog Box
  • Add Borders and Colors to Cells
  • Formatting Value
  • Creating a Custom Number
  • Hide or Unhide Rows and Columns
  • Merge Cells
  • Align Cell Contents

Developing a Workbook

  • Format Worksheet Tab
  • Reposition Worksheets in a Workbook
  • Insert and Delete Worksheets
  • Copy and Paste Worksheet

Page Properties and Printing

  • Set Print Titles
  • Create a Header and Footer
  • Set Page Margins
  • Change Page Orientation
  • Set Page Breaks
  • Print a Range


  • Create a Chart
  • Recommended Chart (New!)
  • Modifying a Chart
  • Chart Tools
    • Pie Chart Example
  • Sparklines

Sort and Filter

  • Basic Sorts
  • Custom Sorts
  • Filtering

Customize the Layout

  • Split a Worksheet
  • Freeze Rows and Column
  • Hide and Unhide Worksheets