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

1100/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

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

Trainers