Microsoft Excel 2013 Foundation

Quorse - Your Training Wholesaler

  • Enjoy discounts up to 60% off!
  • Chat with us Live to get a Quotation to see it for yourself!
  • All courses are HDRF Claimable

Private Class from


(2 Days)


  • Give participant a systematic understanding of a spreadsheet ad its benefits
  • Equip participant with essential skills of effectively utilizing spreadsheet software in a day-to-day business environment

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

  • Create a spreadsheet with simple formatting
  • Create basic formulas – Addition, Subtraction, Multiplication and Division
  • Use basic functions – AutoSum, Count, Max, Min and Average functions.
  • Create a basic chart
  • Print a spreadsheet with headers and footers added
  • Use Auto Filter command
  • Use Freeze Pane command


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.


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

  • Able to maneuver with the mouse – Point, Click, Drag and Double Click
  • Able to configure the desktop
  • Able to use the Control Panel
  • Able to move and re-size Application Windows
  • Able to switch between task applications


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

Welcome To Excel 2013
Lesson 1.1 – Starting Excel 2013
  • Excel Start Screen
  • What’s New in Excel 2013?
  • Templates

A Tour Of The Excel Interface

Lesson 2.1 - The Quick Access Toolbar and File Tab

  • The Default QAT Commands
  • Tabs and Groups
  • Adding Commands
  • Removing Commands
  • Dialog Box Launcher
  • The File (Backstage View) Tab

Lesson 2.2 – What is in your Workbook?

  • Using Worksheets
  • Various types of Pointer in Excel
  • The Active Cell
  • Identifying Cell Address
  • Selecting single cell
  • Selecting a range
  • Exploring a Worksheet
  • Zooming a Worksheet

Lesson 2.3 - About Workbooks

  • Creating a New Workbook
  • Opening a Workbook
  • Saving a Workbook
  • About Excel File Types
  • Closing a Workbook

Excel Basics

Lesson 3.1 - Working with Excel

  • Columns, Rows, Cells, and Ranges
  • Creating Worksheet Labels
  • Entering and Deleting Data

Lesson 3.2 - Basic Excel Features

  • AutoFill Fill Data
  • AutoComplete Data Entry

Lesson 3.3 - Moving your Data

  • Dragging and Dropping Cells
  • How to Cut, Copy, and Paste Cells
  • How to Cut, Copy, and Paste Multiple Cells
  • Using the Clipboard
  • Using Paste Special
  • Inserting and Deleting Cells, Rows, and Columns
  • Using Undo and Redo

Workbook Editing

Lesson 4.1 - Modifying Cells and Data

  • Changing the Size of Rows or Columns
  • Creating Custom Number and Date Formats

Lesson 4.2 - Editing Tools

  • Using AutoCorrect
  • Using Spell Check
  • Using Find and Replace
  • Adding Comments

Basic Formulas & Functions

Lesson 5.1 – Understanding with Basic Mathematical Operators

  • Addition Formula
  • Subtraction Formula
  • Multiplication Formula
  • Division Formula

Lesson 5.2 – Working with Basic Functions

  • Auto Sum Function
  • Count Function
  • Max Function
  • Min Function
  • Average Function

Enhancing Your Worksheet

Lesson 6.1 – Formatting Worksheet

  • Adding Patterns and Colors
  • Adjusting Cell Alignment
  • Rotating Text
  • Adding Borders
  • Working with Styles
  • Working with Themes

Lesson 6.2 - Cell Formatting

  • The Format Painter
  • Cell Merging
  • Cell AutoFit

Setting Up A Worksheet For Printing

Lesson 7.1 – The Page Setup

  • Setting Margins
  • Setting the Page Orientation
  • Setting the Paper Size
  • Inserting Headers
  • Inserting Footers

Lesson 7.2 – Excel Views

  • Normal View
  • Print Preview
  • Page Break Preview

Lesson 7.3 - Printing your Workbook

  • File Print Commands
  • Print Settings

Auto Filter A Database

Lesson 8.1 – Using Sort and Auto Filter

  • Sorting Data
  • Category Selection Filter
  • Multiple Category Selection Filter
  • Freezing a Pane
Working With Charts

Lesson 9.1 – Creating a Chart

  • Creating a Chart
  • Changing Chart types
  • Changing Chart Colour
  • Using Chart Quick Layout