Microsoft Excel 2013 Basic and Intermediate


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


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


To register, fill in the form and we will contact you soon.