Microsoft Excel 2013 Foundation
Private Class From
RM1100
/day
(2 Days)
COURSE OBJECTIVES
  • 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
AUDIENCE

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.

PREREQUISITES

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
METHODOLOGY

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

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


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


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


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



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


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


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


Lesson 8.1 – Using Sort and Auto Filter

  • Sorting Data
  • Category Selection Filter
  • Multiple Category Selection Filter
  • Freezing a Pane

Lesson 9.1 – Creating a Chart

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