Microsoft Excel 2013 Foundation

Objective

• 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

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

Who Should Attend

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.

Methodology

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

Module

• WORKBOOK EDITING
  • Lesson 4.1 – Modifying Cells and Data
    • Changing the Size of Rows or Columns
    • Creating Custom Number and Date Formats
• 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
    • How to Cut, Copy, and Paste Cells
    • Using the Clipboard
    • Inserting and Deleting Cells, Rows, and Columns
    • Using Undo and Redo
• A TOUR OF THE EXCEL INTERFACE
  • Lesson 2.1 – The Quick Access Toolbar and File Tab
    • The Default QAT Commands
    • Tabs and Groups
    • 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
    • Closing a Workbook
• WELCOME TO EXCEL 2013
  • Lesson 1.1 – Starting Excel 2013
    • Excel Start Screen
    • What’s New in Excel 2013?
• 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 FunctionMax Function
    • Min Function
    • Average Function
• ENHANCING YOUR WORKSHEET
  • Lesson 6.1 – Formatting Worksheet
    • Adding Patterns and Colors
    • Adjusting Cell Alignment
    • Adding Borders
• 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 – Printing your Workbook
    • File Print Commands
    • Print Settings
• WORKING WITH CHARTS
  • Lesson 8.1 – Creating a Chart
    • Creating a Chart
    • Changing Chart types
    • Changing Chart Colour
    • Using Chart Quick Layout