Microsoft Excel 2013 Foundation

Purchase this product now and earn 250 Points!
0 out of 5 based on 0 customer ratings

 Microsoft-Excel-2013-Foundation-HRDF-Trainings

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

RM1,300.00 RM850.00

Qty:
Request For In-House
If you purchase this product you will earn 850 Points!

Fee: RM 850 per pax


Loyalty Points: 850 Points


Duration: 1 Day


Note: In-house course is available. Request it HERE

 Microsoft-Excel-2013-Foundation-HRDF-Trainings

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

Reviews

There are no reviews yet.

Be the first to review “Microsoft Excel 2013 Foundation”

You're reviewing: Microsoft Excel 2013 Foundation . How do you rate this product? *

Azrulnizam Bin Ahmad
Biodata: Azrulnizam Ahmad has been working in the business industry since 2004 and has been exposed to all the common challenges faced by business personnel. With his years of experience working with business and management, IT services and end users, he understands the importance of business value, infrastructure efficiency and user productivity.He shares his training passion in Microsoft Office 2007 Application - Excel, PowerPoint, and Word; Microsoft Office 2010 Application - Excel, PowerPoint, and Word and also emphasizes on the criticality of this aspect in any implementation.He is an energetic, independent, goal-oriented individual that has a high work standard and is committed to his work. He is also a good planner, is creative and resourceful, has great leadership charisma and works well with others.

Redemption Products

Pin It on Pinterest