IT & Computing

35%OFF
Collaborating with Office 365

RM1,300.00 RM850.00

Collaborating with Office 365 , .
 Collaborating-with-Office-365-HRDF-Trainings

Objective

This one-day instructor-led course provides students with the knowledge and skills to productively utilize Office 365.

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

  • Understand ‘The Cloud’ and Office 365 Applications
  • Understand how to access applications and documents through a browser
  • Use Skype for Business to communicate, set up and join meetings
  • Understand how to work collaboratively with Office 365 through OneDrive
  • Use Office Online Apps: the online companions to Word, Excel and PowerPoint
  • Save and share documents from within Office 2013 via Office 365

Prerequisites

It is assumed that attendees on this course are familiar with Office 2013 and Outlook

In-depth exposure to any of the Office products is not required

Who Should Attend

This course is intended for information workers who have used Microsoft Office and basic navigation skills. This course is also intended to provide Technology-Influencing Business Decision Makers (TIBDM) in need of gaining an understanding of how Office 365 can increase employee productivity, share information easily and complete tasks faster.

Methodology

Hands on creation and lab Exercises with simple case study.

Module

  • OFFICE 365 PREVIEW
    • Introducing Cloud Computing
    • Identify and Outline the Component Products in Office 365 including Outlook Web App, Office Outline Apps, OneDrive and Skype for Business
    • Navigating around Office 365
    • Customizing the Office 365 Navigation Bar
    • Updating your Profile in Office 365
  • USING THE OUTLOOK ONLINE APPLICATION
    • Overview of Outlook Online
    • Working with Email and Folders
    • Outlook People and IM Contacts
    • Using the Calendar
    • Shared Calendars
    • Outlook Tasks in the Web App
    • Setting Outlook Options, Signatures, Automatic Replies and Rules
  • USING SKYPE FOR BUSINESS
    • Overview of Skype for Business
    • Viewing and Setting Presence Status
    • Using Instant Messages in Business
    • Integration with Outlook
    • Using Skype for Business for Online Presentations including Content Sharing, Polls and a Virtual Whiteboard
  • WORKING WITH ONEDRIVE FOR BUSINESS
    • What is OneDrive for Business?
    • Navigating around OneDrive
    • Accessing Content in OneDrive
    • Using the Office Online Apps
    • Sharing Documents and Collaborating
    • Connecting Microsoft Office to OneDrive
    • Creating Office Documents and Saving Directly to OneDrive
  • ADVANCED CHART TECHNIQUES
    • Introduction to Groups
    • Collaborating using Groups
    • Getting to Content using Delve
Learn More

RM1,300.00 RM850.00

  • Availability: 0 in stock
58%OFF
Introduction to Minitab And Its Statistical Application , , .
 Introduction-to-Minitab-And-Its-Statistical-Application-2-Days-HRDF-TrainingsEnhancing-Your-Presentation-Skills-hrdf-trainings

Introduction

Manufacturing Organizations use 6-sigma tools to drive continual improvement in Manufacturing and Production Operations. In the present work environment everyone involved in continual improvement should be equipped or armed with the know how in utilizing 6-sigma tools. However, we will focus on key 6-sigma tools. This course will improve the analytic skill effectiveness in problem solving and implementation of the appropriate tools in the continual improvement process using Minitab 15.

 How Will You Benefit

On completion of the Program, participants will be able:

  • Understanding Minitab Application
  • Understand and apply the quality planning tools
  • Identify and apply the quality control tools
  • Identify and utilize quality improvement tools
  • How to carry out their process capability studies
  • Understand Basic Statistics and Anova (Analysis of Variance)

Who Should Attend

QA/QC Managers, Executives, Supervisors and Engineers involved in process improvement preferably graduates in Science or Engineering fields. This course involves many calculations and mathematical modeling.

Methodology

Lectures, Workshop Activities, Discussions & Calculations

Module

  • INTRODUCTION – STATISTICAL PRINCIPLES
  • DESCRIPTIVE STATISTICS AND NORMALITY TESTS
  • WAY ANOVA AND 2-WAY ANOVA
  • STATISTICAL APPLICATIONS IN QUALITY IMPROVEMENTS
  • COMPARING TWO GROUPS (T TEST)
Learn More

RM2,600.00 RM1,100.00

  • Availability: 0 in stock
35%OFF
Microsoft Excel 2007 Foundation

RM1,300.00 RM850.00

Microsoft Excel 2007 Foundation , .
 Microsoft-Excel-2007-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 a chart
  • Print a spreadsheet with headers and footers added

Prerequisites

Basic knowledge of Windows is essential with the follow 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

  • GETTING STARTED
    • Lesson 1.1 – About Workbooks
      • Creating a New Workbook
      • Opening a Workbook
      • Saving a Workbook
      • About Excel File Types
      • Closing a Workbook
    • Lesson 1.2 – Exploring your Workbook
      • Using Worksheets
      • The Active Cell
      • Selecting Cells
      • Exploring a Worksheet
      • The Zoom Feature

 

  • THE NEW INTERFACE
    • Lesson 2.1 – The Quick Access Toolbar
      • The Default Buttons
      • Adding Buttons
      • Removing Buttons
      • Customizing the Toolbar

 

  • EXCEL BASICS
    • Lesson 3.1 – Working With Excel 2007
      • Columns, Rows, Cells, and Ranges
      • Creating Worksheet Labels
      • Entering and Deleting Data
    • Lesson 3.2 – Basic Excel Features
      • What is AutoFill?
      • What is AutoSum?
      • What is AutoComplete?
      • Working with Basic Formulas
    • 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 and Items
      • How to Use Paste Special
      • How to Insert and Delete Cells, Rows, and Columns
      • Using Undo, Redo, and Repeat

 

  • EDITING YOUR WORKBOOK
    • Lesson 4.1 – Modifying Cells and Data
      • Changing the Size of Rows or Columns
      • Adjusting Cell Alignment
      • Rotating Text
      • Creating Custom Number and Date Formats
    • Lesson 4.2 – Cell Formatting
      • The Format Painter
      • Cell Merging and AutoFit
    • Lesson 4.3 – Enhancing a Worksheet’s Appearance
      • Adding Patterns and Colors
      • Adding Borders
      • Working with Style
    • Lesson 4.4 – Working With Charts
      • Creating a Chart
      • Formatting a Chart
      • Modifying Charts with the Layout Ribbon
      • Manipulating a Chart

 

  • PRINTING AND VIEWING YOUR WORKBOOK
    • Lesson 5.1 – Using the View Ribbon
      • Using Normal View
      • Using Full Screen View
      • Using Page Layout View
      • Page Break Preview
    • Lesson 5.2 – Printing your Workbook
      • Opening Print Preview
      • Using the Print Preview Ribbon
      • Quick Printing
      • The Print Dialogue
      • Using Page Setup
Learn More

RM1,300.00 RM850.00

  • Availability: 0 in stock
50%OFF
Microsoft Excel 2007 Intermediate

RM2,600.00 RM1,300.00

Microsoft Excel 2007 Intermediate , .
 Microsoft-Excel-2007-Intermediate-2-days-HRDF-Trainings

Objective

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

  • Create simple to complex formulas and functions, like:
  • IF Functions
  • Nested Functions
  • Database Function – DSUM, DCOUNT
  • Validate data in a Worksheet
  • Filter data using Auto & Advanced Filters
  • Apply workbook protection

Prerequisites

Basic knowledge of Microsoft Excel is essential with the follow pre-requisites:

  • Have attended Microsoft Excel – Foundation Level; OR
  • Able to switch between task applications
  • Able to create a spreadsheet with simple formatting
  • Create a chart
  • Print a spreadsheet with headers and footers added

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

  • WORKING WITH FUNCTIONS AND FORMULAS
    • Lesson 2.1 – Using Formulas in Excel
      • Understanding Relative and Absolute Cell References
      • Basic Mathematical Operators
      • Using Formulas with Multiple Cell References
      • The Formula Auditing Buttons
      • Fixing Formula Errors
      • Displaying and Printing Formulas
    • Lesson 2.2 – Exploring Excel Functions
      • What are Functions?
      • Finding the Right Function
      • Some Useful and Simple Functions
    • Lesson 2.3 – Using Functions in Excel
      • Inserting Functions
      • Using Functions and AutoFill to Perform Difficult Calculations
      • Using the IF Function
      • Working with Nested Functions
    • Lesson 2.4 – Working with Names and Ranges
      • What Are Range Names?
      • Defining and Using Range Names
      • Selecting Nonadjacent Ranges
      • Using AutoCalculate
    • Lesson 2.5 – Working with Array Formulas
      • What are Array Formulas?
      • Using Basic Array Formulas
      • Using Functions with Array Formulas
      • Using the IF function in Array Formulas
  • TEMPLATES
    • Lesson 1.1 – Using Templates
      • Opening a Template
      • Downloading a Template
      • Using a Template
      • Creating a Template
  • MANAGING TABLES
    • Lesson 3.1 – Working with Tables
      • What is a Table?
      • Creating Tables
      • Modifying Tables
      • What is the Total Row?
    • Lesson 3.2 – Working with Records and Fields
      • What are Records and Fields?
      • Adding Fields by Inserting Columns
      • Adding Records by Inserting Rows
      • Quickly Adding Records to a Data Table
      • Deleting Records or Fields
    • Lesson 3.3 – Working with Tables and Filters
      • Sorting Data in a Table
      • What is an AutoFilter?
      • Custom AutoFilters
      • Using an Advanced Filter
      • Copying Filtered Records
    • Lesson 3.4 – Using Excel as a Database
      • Filtering with Wildcard Characters
      • Validating Your Data
      • What are Database Functions?
  • FINALIZING YOUR WORKBOOK
    • Lesson 4.1 – Protecting your Workbook
      • Protecting your Workbook
      • Protecting your Worksheets
      • Unlocking Cells
      • Protecting your Excel Files
      • Marking a Workbook as Final
    • Lesson 4.2 – Finishing Your Workbook
      • Find and Replace Formatting
      • Conditional Formatting
      • Using the Document Inspector
      • Using the Compatibility Checker
    • Lesson 4.3 – Advanced Chart Options
      • Changing the Type of Chart
      • Changing the Source Data
      • Working with the Chart Axis and Data Series
      • Saving a Chart as a Template
    • Lesson 4.4 – Using Excel in Word
      • Inserting Excel Data in Word
      • Linking Excel Data in a Word Document
      • Modifying Excel Data after Insertion
      • Insert an Excel Chart into a Word Document
    • Lesson 4.5 – Using Excel With other Programs and Files
      • Opening an Excel File in a Different Format
      • Importing Data from a Text File
      • Publishing a Workbook as a PDF File
Learn More

RM2,600.00 RM1,300.00

  • Availability: 0 in stock
35%OFF
Microsoft Excel 2013 Advanced

RM1,300.00 RM850.00

Microsoft Excel 2013 Advanced , .
 Microsoft-Excel-2013-Advanced-HRDF-Trainings

Objective

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

  • Create Subtotal Using The Subtotal Function
  • Analyze data Using Pivot Tables
  • Perform What If Analysis using:
  • Goal Seek
  • Solver
  • Input Table
  • Scenarios
  • Use VLOOKUP function to extract data
  • Nesting INDEX and MATCH Function
  • Combining & Consolidating Data
  • Record and Run a Macro

Prerequisites

REQUIRED PREREQUISITES:

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

  • Have attended Microsoft Excel – Foundation & Intermediate Level; OR
  • Able to switch between task applications
  • Able to create simple to complex formulas and functions, like:
  • COUNTA, COUNTIF & COUNTIFS Function
  • AVERAGEA, AVERAGEIF & AVERAGEIFS Function
  • SUMIF & SUMIFS Function
  • IF Functions
  • Nested Functions
  • Database Function
  • Able to validate data in a Worksheet
  • Able to apply Filter data using Auto & Advanced Filters
  • Able to clean Duplicate Records

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

  • OUTLINING AND GROUPING DATA
    • Using Automatic Outlining
    • Displaying and Collapsing Levels
    • Grouping Data Manually
    • Creating Subtotals
  • WHAT IF ANALYSIS?
    • Lesson 2.1: Exploring Scenarios
      • What is a Scenario?
      • Creating a Scenario
      • Saving Multiple Scenarios
      • Creating a Scenario Summary Report
  • PIVOTING DATA
    • Lesson 3.1: Getting Started with PivotTables
      • What is a PivotTable?
      • Creating a PivotTable
      • Using the PivotTable Tools Tabs
      • Adding and Removing Data with the Field List
      • Changing the Field List Layout
      • Pivoting Data
    • Lesson 3.2: Working with PivotTable Data
      • Expanding and Collapsing Data
      • Filtering Data
      • Sorting Data
      • Grouping Data
      • Refreshing Data
      • Editing the Data Source
    • Lesson 3.3: Formatting a PivotTable
      • Modifying Fields and Labels
      • Modifying Values
      • Using the Layout Group on the Design Tab
      • Applying a Style to a PivotTable
      • Changing PivotTable Style Options
      • Manually Formatting a PivotTable
      • Using the PivotTable Options Dialog
  • CHARTING PIVOTED DATA
    • Lesson 4.1: Getting Started with PivotCharts
      • Creating a PivotChart from Existing Data
      • Adding Data to your Chart
      • Pivoting Data
      • Using the Analyze Tab
  • ADVANCED EXCEL TASK
    • Lesson 5.1: Using the VLOOKUP Function
      • Understanding VLOOKUP and HLOOKUP
      • Using VLOOKUP to Find Data
      • How to Find an Exact Match with VLOOKUP
      • Finding an Approximate Match with VLOOKUP
    • Lesson 5.2: Using the Advanced Function
      • Using the INDEX Function
      • Using the MATCH Function
      • Combining the MATCH and INDEX functions
Learn More

RM1,300.00 RM850.00

  • Availability: 0 in stock
67%OFF
Microsoft Excel 2013 Advanced

RM2,600.00 RM850.00

Microsoft Excel 2013 Advanced , .
 Microsoft-Excel-2013-Advanced-2-Days-HRDF-Trainings

Objective

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

  • Create Subtotal Using The Subtotal Function
  • Analyze data Using Pivot Tables
  • Perform What If Analysis using:
  • Scenarios
  • Use VLOOKUP function to extract data
  • Nesting INDEX and MATCH Function

Prerequisites

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

  • Have attended Microsoft Excel – Foundation & Intermediate Level; OR
  • Able to switch between task applications
  • Able to perform IF Functions
  • Able to perform NESTED Functions
  • Able To define And use Range Names
  • Able To use Auto And Advanced Filter

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

  • GETTING THE MOST FROM YOUR DATA
    • Lesson 1.1: Outlining and Grouping Data
      • Using Automatic Outlining
      • Displaying and Collapsing Levels
      • Grouping Data Manually
      • Creating Subtotals
  • PIVOTING DATA
    • Lesson 2.1: Getting Started with PivotTables
      • What is a PivotTable?
      • Recommended PivotTables
      • Creating a PivotTable
      • Using the PivotTable Tools Tabs
      • Adding and Removing Data with the Field List
      • Changing the Field List Layout
      • Pivoting Data
    • Lesson 2.2: Working with PivotTable Data
      • Expanding and Collapsing Data
      • Filtering Data
      • Sorting Data
      • Grouping Data
      • Refreshing Data
      • Editing the Data Source
    • Lesson 2.3: Formatting a PivotTable
      • Modifying Fields and Labels
      • Modifying Values
      • Using the Layout Group on the Design Tab
      • Applying a Style to a PivotTable
      • Changing PivotTable Style Options
      • Manually Formatting a PivotTable
      • Using the PivotTable Options Dialog
    • Lesson 2.4: Advanced PivotTable Tasks
      • Use Slicer with Pivot Tables
      • Slicer Tools Tab
      • Timeline to show Data for Different Time Periods
  • CHARTING PIVOTED DATA
    • Lesson 3.1: Getting Started with PivotCharts
      • Creating a PivotChart from Existing Data
      • Adding Data to your Chart
      • Pivoting Data
      • Using the Analyze Tab
  • WHAT IF ANALYSIS?
    • Lesson 4.1: Using Data Analysis Tools
      • Using a One or Two Input Data Table
      • Using Goal Seek
    • Lesson 4.2: Exploring Scenarios
      • What is a Scenario?
      • Creating a Scenario
      • Saving Multiple Scenarios
      • Creating a Scenario Summary Report
    • Lesson 4.3: Using Solver
      • Understanding Solver
      • Generating Reports and Scenarios with Solver
      • Changing Solver Values
      • Managing Solver Constraints
      • Using Solver as a Goal Seek Tool
  • ADVANCED EXCEL TASK
    • Lesson 5.1: Working with Array Formulas
      • What are Array Formulas?
      • Defining Basic Array Formulas
      • Using Functions within Array Formulas
      • Using the IF Function in Array Formulas
      • Using IFERROR with Array Formulas
    • Lesson 5.2: Using the VLOOKUP Function
      • Understanding VLOOKUP and HLOOKUP
      • Using VLOOKUP to Find Data
      • How to Find an Exact Match with VLOOKUP
      • Finding an Approximate Match with VLOOKUP
      • Using VLOOKUP as an Array Formula
      • Lesson 5.3: Using the Advanced Function
      • Using the INDEX Function
      • Using the MATCH Function
      • Combining the MATCH and INDEX functions
      • Logical Functions AND/OR
      • Using Nested Logical Functions (IF (OR…, AND))
    • Lesson 5.4: Linking, Consolidating, and Combining Data
      • Linking Workbooks
      • Consolidating Workbooks
      • Combining Worksheets
    • Lesson 5.5: Excel and Hyperlinks
      • What is a Hyperlink?
      • Inserting Hyperlinks
      • Editing Hyperlinks
      • Formatting Hyperlinks
      • Using Hyperlinks in Excel
    • Lesson 5.6: Creating and Using Shared Workbooks
      • Sharing a Workbook
      • Opening and Editing a Shared Workbook
      • Tracking Changes
      • Resolving Conflicts in a Shared Workbook
Learn More

RM2,600.00 RM850.00

  • Availability: 0 in stock
35%OFF
Microsoft Excel 2013 Foundation

RM1,300.00 RM850.00

Microsoft Excel 2013 Foundation , .
 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
Learn More

RM1,300.00 RM850.00

  • Availability: 0 in stock
35%OFF
Microsoft Excel 2013 Intermediate , .
 Microsoft-Excel-2013-Intermediate-HRDF-Trainings

Objective

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

  • Create formulas and functions, like:
  • COUNTIF Function
  • AVERAGEIF Function
  • SUMIF Function
  • Database Function
  • Manage Table with using Auto Filters
  • Advanced Chart Formatting
  • Apply Simple Conditional Formatting

Prerequisites

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

  • Have attended Microsoft Excel – Foundation Level; OR
  • Able to switch between task applications
  • Able to create a spreadsheet with simple formatting
  • Able to create a basic chart
  • Able to print a spreadsheet with headers and footers added
  • Able to create basic formulas – Addition, Subtraction, Multiplication and Division
  • Able to use basic functions – AutoSum, Count, Max, Min and Average functions.

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

  • WORKING WITH FORMULA
    • Lesson 1.1 – Freeze Cell
      • Understanding Relative Cell Reference
      • Understanding Absolute Cell Reference
      • Understanding Mixed Cell Reference
  • WORKING WITH FUNCTION
    • Lesson 2.1 – Using Statistical Function
      • COUNTIF Function
      • AVERAGEIF Function
    • Lesson 2.2 – Using Mathematical Function
      • SUMIF Function
    • Lesson 2.3 – Using Database Function
      • DSUM Function
      • DCOUNT Function
      • DAVERAGE Function
      • DMAX Function
      • DMIN Function
  • MANAGING TABLES
    • Lesson 3.1 – Manipulating Records
      • Quickly Add Records to a Table
      • Cleaning up Duplicate Records
    • Lesson 3.2 – Working with Filters
      • Number Filter
      • Text Filter
      • Date Filter
      • Filtering with Wildcard Characters
  • SHOWING DATA AS GRAPHIC
    • Lesson 4.1 – Conditional Formatting
      • Highlight Cell Rules
    • Lesson 4.2 – Advanced Chart Options
      • Use Recommended Chart
      • Changing the Source Data
      • Working with the Chart Axes and Data Series
      • Saving a Chart as a Template
      • Creating Combo Chart
      • Adding Secondary Axis
      • Fine Tune Charts Quickly
      • Richer Data Labels
  • FINALIZE WORKBOOK
    • Lesson 5.1: Finishing Workbook
      • Publishing to PDF or XPS
      • Protecting the Current Sheet
    • Lesson 5.2 – Working with Different Views
      • Using Custom view
      • Using Page Layout View
      • Express Header & Footer
    • Lesson 5.3 – Managing Multiple Windows
      • Arranging Workbooks
      • Comparing Workbooks Side by Side
      • Synchronous Scrolling and Resetting a Window
Learn More

RM1,300.00 RM850.00

  • Availability: 0 in stock
38%OFF
Microsoft Excel 2013 Intermediate

RM2,600.00 RM1,600.00

Microsoft Excel 2013 Intermediate , .
 Microsoft-Excel-2013-Intermediate-2-Days-HRDF-Trainings

Objective

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

  • Create simple to complex formulas and functions, like:
  • COUNTA, COUNTIF & COUNTIFS Function
  • AVERAGEA, AVERAGEIF & AVERAGEIFS Function
  • SUMIF & SUMIFS Function
  • IF Functions
  • Nested Functions
  • Database Function
  • Validate data in a Worksheet
  • Filter data using Auto & Advanced Filters
  • Advanced Chart Formatting
  • Clean Duplicate Records

Prerequisites

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

  • Have attended Microsoft Excel – Foundation Level; OR
  • Able to switch between task applications
  • Able to create a spreadsheet with simple formatting
  • Able to create a basic chart
  • Able to print a spreadsheet with headers and footers added
  • Able to use Auto Filter command
  • Able to apply Freeze Pane command
  • Able to create basic formulas – Addition, Subtraction, Multiplication and Division
  • Able to use basic functions – AutoSum, Count, Max, Min and Average functions.

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

  • WORKING WITH FORMULA
    • Lesson 1.1 – Freeze Cell
      • Understanding Relative
      • Understanding Absolute Cell References
      • Understanding Mixed Cell References
    • Lesson 1.2 – Name Manager
      • What are Range Names?
      • Naming range
      • Define Name button
    • Lesson 1.3 – Formula Auditing
      • Understanding the Formula Auditing Buttons
      • Fixing Formula Errors
      • Modifying Error Checking Options
      • Displaying and Printing Formulas
  • WORKING WITH FUNCTIONS
    • Lesson 2.1 – Using Statistical Function
      • COUNTA Function
      • COUNTIF Function
      • COUNTIFS Function
      • AVERAGEA Function
      • AVERAGEIF Function
      • AVERAGEIFS Function
    • Lesson 2.2 – Using Mathematical Function
      • SUMIF Function
      • SUMIFS Function
    • Lesson 2.3 – Using Logical Function
      • IFERROR Function
      • IF Function
      • Nested If Function
    • Lesson 2.4 – Using Database Function
      • DSUM Function
      • DCOUNT Function
      • DAVERAGE Function
      • DMAX Function
      • DMIN Function
  • MANAGING TABLES
    • Lesson 3.1 – Working with Tables
      • What is a Table?
      • Creating Tables
      • Modifying Tables
      • Using the Table Tools – Design Tab
      • Adding a Total Row
      • Using Flash Fill
      • Using Quick Analysis
    • Lesson 3.2 – Manipulating Records
      • Quickly Add Records to a Table
      • Cleaning up Duplicate Records
    • Lesson 3.3 – Using Custom Lists
      • Creating a Custom AutoFill List
      • Using a Custom AutoFill List
      • Modifying a Custom AutoFill List
      • Deleting a Custom AutoFill List
      • Sorting with Custom List
    • Lesson 3.4 – Working with Filters
      • Number Filter
      • Text Filter
      • Date Filter
      • Filtering with Wildcard Characters
    • Lesson 3.5 – Working with Advanced Filters
      • Using an Advanced Filter
      • Using an Advanced Filter with Logical Statements
      • Copying Filtered Records
    • Lesson 3.6 – Data Validation
      • Validating your Data
      • Data Validation using Lists
      • Data Validation using Date
      • Data Validation using Formulas
  • SHOWING DATA AS GRAPHIC
    • Lesson 4.1 – Conditional Formatting
      • Highlight Cell Rules
      • Using Data Bars
      • Using Icon Sets
      • Creating New Rules with Formula
    • Lesson 4.2 – Advanced Chart Options
      • Use Recommended Chart
      • Changing the Source Data
      • Working with the Chart Axes and Data Series
      • Saving a Chart as a Template
      • Creating Combo Chart
      • Adding Secondary Axis
      • Fine Tune Charts Quickly
      • Richer Data Labels
    • Lesson 4.3 – Adding Sparklines
      • What are Sparklines?
      • Adding Sparklines
      • About the Sparkline Tools Tab
      • Editing Sparkline Data
      • Removing Sparklines
    • Lesson 4.4 – Editing Sparklines
      • Showing and Hiding Data
      • Changing the Style
      • Changing the Sparkline and Marker Color
      • Setting Sparkline Options
  • FINALIZE WORKBOOK
    • Lesson 5.1 – Finishing Workbook
      • Publishing to PDF or XPS
      • Protecting Current Sheet
      • Protecting Workbook
      • File Protection
    • Lesson 5.2 – Working with Different Views
      • Using Custom view
      • Using Page Layout View
      • Express Header & Footer
    • Lesson 5.3 – Managing Multiple Windows
      • Arranging Workbooks
      • Comparing Workbooks Side by Side
      • Synchronous Scrolling and Resetting a Window
Learn More

RM2,600.00 RM1,600.00

  • Availability: 0 in stock
37%OFF
Microsoft Office 101- Beginner To Basic Course , .
 Microsoft-Office-101- Beginner-To-Basic-Course-HRDF-Trainings

Objective

  • Upon completion, participants can do business proposal, cash flow projection document & store files on the cloud with OneDrive

Prerequisites

  • Basic knowledge of using computers & internet browser

Who Should Attend

  • This course is designed for business owners, Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who never or rarely uses Microsoft office but want to further enhance their knowledge and practical uses of Microsoft Office.

Methodology

  • This program will be conducted with interactive lectures, PowerPoint presentation, discussions and practical exercise.
  • This program consists of two-days from 9am-5pm

Module:

  • WORKING WITH WORD
    • Choosing templates
    • Formatting text
    • Insert tables, images & graphs
    • Sub-headers & footers
    • Creating templates
  • WORKING WITH EXCEL
    • Choosing Templates
    • Navigating tabs & sheets
    • Cell formatting
    • Table Creation & Page Formatting
    • Basic Formulation
    • Printing, Publishing & Exporting
  • WORKING WITH ONE DRIVE
    • Setting Up Microsoft account
    • Creating document
    • Sharing files & folder
    • Synchronize
    • Using on the go
    • Using in the browser
  • BUSINESS APPLICATION OF MICROSOFT OFFICE
    • Case studies
    • Proposals
    • Ordering forms
    • Inventory list
Learn More

RM2,600.00 RM1,650.00

  • Availability: 0 in stock
50%OFF
Microsoft Outlook 2010 Intermediate , .
 Microsoft-Outlook-2010-Intermediate-2-Days-HRDF-Trainings

Objective

At the end of this course, participants will be able to:

  • Manage folder in Outlook
  • Use the favorites list
  • Use search folder
  • Create Simple rule to move messages
  • Use quick steps command
  • Setup categories
  • Manage junk email
  • Configure RSS Feeds
  • Set up an Exchange Mailbox
  • Set Permissions on Your Mailbox
  • Configure Delegate Access

Prerequisites

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

  • Have attended Microsoft Outlook – Foundation Level; OR
  • Able to maneuver with the mouse – Point, Click, Drag and Double Click
  • Able to switch between task applications
  • Able to send and receive emails
  • Able to reply and forward emails
  • Able to add, open, preview and save attachments
  • Able to use the draft folder
  • Able to create and edit contacts
  • Able to create and edit appointments
  • Able to create and edit tasks
  • Able to create and edit notes
  • Able to arrange and organize emails, task and notes

Who Should Attend

Clerks, Officers, Supervisors, Administrators, Executives, Managers and all personnel involved in Outlook.

Methodology

This stimulating program will maximizes the understanding and learning through Classroom lecture, Group activities, Group discussion & presentation, Group pilot project, Case study and Pre and post test

Module

  • ORGANIZING YOUR E-MAIL, PART ONE
    • Lesson 1.1: Managing Folders
      • Creating Folders
      • Renaming Folders
      • Moving Folders
      • Deleting Folders
      • Moving Messages to Folders
    • Lesson 1.2: Using the Favorites List
      • Adding Folders to the Favorites List
      • Reordering Favorite Folders
      • Removing a Folder from Favorites
      • Expanding and Collapsing the Favorites List
      • Enabling and Disabling the Favorites List
    • Lesson 1.3: Using Search Folders
      • Creating Default Search Folders
      • Creating Custom Search Folders
      • Using Search Folders
      • Modifying Search Folders
    • Lesson 1.4: Searching in Outlook
      • Using the Search Box
      • About the Search Tools Tab
      • Setting Search Options
      • Searching for Contacts
      • Filtering E-mail
  • ORGANIZING YOUR E-MAIL, PART TWO
    • Lesson 2.1: Using Rules and Cleanup Tools
      • Creating a Simple Rule
      • Modifying Rules
      • Using the Rules and Alerts Wizard
      • Marking a Message for Follow-Up
      • Cleaning up a Folder or Conversation
    • Lesson 2.2: Using Quick Steps
      • Using Quick Steps
      • Creating Quick Steps
      • Managing Quick Steps
      • Resetting Quick Steps
    • Lesson 2.3: Configuring Categories
      • Setting up Categories
      • Assigning a Category to an Item
      • About Quick Click
      • Upgrading Categories
      • Using Categories in a View
      • Creating Category Search Folders
    • Lesson 2.4: Managing Junk Mail
      • Using the Junk E-Mail Filter
      • Receiving Junk Mail
      • About the Phishing Filter
      • About Automatic Downloads
      • Managing Blocked and Safe Senders Lists
  • A WORD PRIMER
    • Lesson 3.1: Basic Text Tools
      • Cutting, Copying, and Pasting Text
      • Using the Office Clipboard
      • Using Find and Replace
      • Checking Your Spelling
    • Lesson 3.2: Formatting Text
      • Changing Font Face, Size, and Color
      • Applying Text Effects
      • Highlighting Text
      • Changing Text’s Case
      • Using the Font Dialog
      • Clearing Formatting
    • Lesson 3.3: Applying Advanced Text Effects
      • Using the Format Painter
      • Applying a Quick Style
      • Changing the Style Set
      • Using Themes
      • Understanding Mail Formats
    • Lesson 3.4: Formatting Paragraphs
      • Aligning and Justifying Text
      • Indenting a Paragraph
      • Changing Paragraph Spacing
      • Creating a Bulleted, Numbered, or Multilevel List
      • Adding Borders and Shading
      • Using the Borders and Shading Dialog
    • Lesson 3.5: Adding Word Elements, Part One
      • Adding Tables
      • Adding Pictures and Clip Art
      • Adding Screenshots
      • Adding Shapes
      • Step-By-Step
      • Skill Sharpener
    • Lesson 3.6: Adding Word Elements, Part Two
      • Adding Text Boxes
      • Adding WordArt
      • Adding SmartArt
      • Adding Charts
  • UNDERSTANDING E-MAIL ACCOUNTS
    • Lesson 4.1: Setting up a Basic E-Mail Account
      • Overview of E-mail Account Types
      • Setting up a POP3, IMAP, or HTTP E-mail Account
      • Using Your Mailbox
      • Understanding the Send/Receive Tab
      • Setting Send/Receive Options
    • Lesson 4.2: Configuring SMS Accounts
      • Setting up a Mobile Service Account
      • Viewing Text Messages
      • Creating a Text Message
      • Removing the Account
    • Lesson 4.3: Configuring RSS Feeds
      • Setting up an RSS Feed in Outlook
      • Setting up an RSS Feed with Internet Explorer
      • Reading and Managing Feed Items
      • Sharing a Feed with a Friend
      • Removing an RSS Feed
      • Getting Help with RSS Feeds
  • MICROSOFT EXCHANGE SERVER
    • Lesson 5.1: About Microsoft Exchange Server
      • Understanding Microsoft Exchange Server
      • Setting up an Exchange Mailbox
      • How an Exchange Mailbox Works
      • Supported Versions of Exchange Server with Outlook 2010
      • About Outlook Web Access
    • Lesson 5.2: Managing Your Mailbox
      • Setting Permissions on Your Mailbox
      • Configuring Delegate Access
      • Viewing Another User’s Mailbox
      • Setting up the Out of Office Assistant
      • Using the Global Address Book
    • Lesson 5.3: Managing Tasks and E-mail Messages
      • Recovering Deleted Items
      • Recalling Messages
      • Sending a Task Sharing Request
      • Responding to a Task Sharing Request
      • Viewing Another User’s Tasks
    • Lesson 5.4: Managing Your Calendar
      • Sharing a Calendar
      • Responding to a Calendar Sharing Request
      • Viewing Another User’s Calendar
      • Using Schedule View
    • Lesson 5.5: Scheduling Meetings with Exchange Server
      • Scheduling a Meeting
      • Using the Scheduling Assistant
      • Responding to a Meeting Request
      • Tracking Responses
      • Adding and Removing Attendees
      • Contacting Attendees
      • Cancelling a Meeting
Learn More

RM2,600.00 RM1,300.00

  • Availability: 0 in stock
35%OFF
Microsoft Outlook 2013 Foundation , .
 Microsoft-Outlook-2013-Foundation-HRDF-Trainings

Objective

At the end of this course, participants will be able to:

  • Open, Reply, Forward and Delete emails
  • Create new emails
  • Perform spelling check in an email message
  • Create new Contacts
  • Change the Contact View
  • Create Contact Group

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

Clerks, Officers, Supervisors, Administrators, Executives, Managers and all personnel involved in Outlook.

Methodology

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

Module

  • STARTING OUT
    • Lesson 1.1: Getting Started
      • What is Microsoft Office Outlook 2010?
      • What’s New in Microsoft Office Outlook 2010?
      • Starting Outlook
      • The Outlook Interface
      • About the Notification Icon
      • Closing Outlook
    • Lesson 1.2: Receiving E-Mail
      • Types of E-Mail Accounts
      • Setting up an E-Mail Account
      • Modifying E-Mail Account Settings
      • Sending and Receiving E-Mail
    • Lesson 1.3: Working with E-Mail Messages
      • About Outlook Folders
      • Opening Messages
      • Editing Messages
      • Deleting Messages
    • Lesson 1.4: Printing E-Mail Messages
      • Print Commands
      • Choosing Print Options
      • Choosing a Print Preview View
      • Navigating Through Print Preview
  • UNDERSTANDING AND CUSTOMIZING THE OUTLOOK INTERFACE
    • Lesson 2.1: Getting Acquainted
      • Using the File Menu (Backstage View)
      • Using the Status Bar
      • Using the Mini Toolbar
      • Using Dialog Boxes
      • Using Right-Click Menus
      • Keyboard Shortcuts
    • Lesson 2.2: The Quick Access Toolbar
      • Using the Quick Access Toolbar
      • Adding and Removing Buttons
      • Moving the Quick Access Toolbar
      • Customizing the Toolbar
  • TAB OVERVIEW (MAIL INTERFACE)
    • Lesson 3.1: The Home Tab
      • New Commands
      • Delete Commands
      • Respond Commands
      • Quick Steps Commands
      • Move Commands
      • Tags Commands
      • Find Commands
  • SENDING E-MAIL
    • Lesson 4.1: Composing E-Mail
      • Creating a New Message
      • Adding Recipients
      • Typing a Subject Line
      • Creating Your Message
    • Lesson 4.2: Answering Mail
      • Replying to Messages
      • Forwarding Messages
      • Opening and Saving Attachments
      • Using the Attachment Previewer
    • Lesson 4.3: Doing More with E-Mail
      • Adding Attachments
      • Creating Hyperlinks
      • Attaching Outlook Items
      • Using Themes
    • Lesson 4.4: Using the Drafts Folder
      • Opening the Drafts Folder
      • Saving a Message as a Draft
      • Opening and Editing a Draft
      • Sending a Draft
      • Deleting a Draft
  • INFORMATION MANAGEMENT
    • Lesson 5.1: The Calendar
      • Opening the Calendar
      • Understanding the Home Tab
      • Understanding the Calendar Tools Tab
      • Creating and Editing Appointments
      • Using the Daily Task List
      • Using the Calendar Navigation Pane
      • Customizing Calendar Views
    • Lesson 5.2: The Contacts Folder
      • Opening the Contacts Folder
      • Understanding the Home Tab
      • Creating a New Contact
      • Editing Contacts
      • Using the Contacts Navigation Pane
      • Customizing Contacts Views
Learn More

RM1,300.00 RM850.00

  • Availability: 0 in stock

Showing 1–12 of 19 results

Pin It on Pinterest