IT & Computing

35%OFF
Microsoft Powerpoint 2013 Foundation ,
 Microsoft Powerpoint 2013 Foundation-HRDF-Trainings

Objective

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

  • Create and format presentation
  • Change and Reset the slide Layout
  • Apply Bullets and Numbers
  • Create Sections in a presentation
  • Apply Themes to a presentation
  • Change the Slide Variant
  • Format the Slide Background
  • Apply header and footer to a presentation
  • Print Notes and Handouts

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 application

Who Should Attend

This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who wants to know, understand and want to further enhance their knowledge and practical uses of Microsoft PowerPoint.

Methodology

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

Module

  • THE BASICS
    • Getting Started
    • Signing In
    • Saving a Presentation
    • Opening a Presentation
    • Creating a New Presentation
  • CREATING SLIDES
    • Adding Slides to a Presentation
    • Selecting, Moving, and Deleting Slides
    • Changing and Resetting the Layout
    • Working with Sections
    • Viewing the Slide Show
  • FORMATTING TEXT
    • Changing the Font Face, Size, and Color
    • Changing Character Spacing
    • Applying Text Effects
    • Working with the Font Dialog
    • Using the Format Painter
    • Clearing Formatting
  • YOUR FIRST PRESENTATION
    • Selecting Text and Objects
    • Using Cut, Copy, and Paste
    • Using Undo and Redo
    • Checking Your Spelling
  • WORKING WITH TEXT
    • Using Find and Replace
    • Applying Bullets and Numbers
    • Changing Text Alignment
    • Formatting Text as Columns
    • Changing Line Spacing
    • Changing Text Direction
  • FORMATTING THE PRESENTATION
    • Choosing a Theme
    • Choosing a Variant
    • Changing the Slide Size
    • Formatting the Slide Background
    • Adding Headers and Footers to Slides
  • VIEWING AND PRINTING YOUR PRESENTATION
    • Viewing the Slide Show
    • Using Views
    • Using Zoom
    • Printing a Presentation
    • Printing Notes and Handouts

 

Learn More

RM1,300.00 RM850.00

  • Availability: in stock
35%OFF
Microsoft Powerpoint 2013 Intermediate ,
 Microsoft-Powerpoint-2013-Intermediate-HRDF-Trainings

Objective

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

  • Insert Table into a Presentation
  • Insert Chart into a Presentation
  • Insert SmartArt into a Presentation
  • Insert Equation into a Presentation
  • Apply Basic Animations
  • Copy Animation with Animation Painter
  • Apply Transitions
  • Customize Transitions
  • Publish a presentation to PDF or XPS format
  • Protect a Presentation with a Password

Prerequisites

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

  • Have attended Microsoft PowerPoint – Foundation Level; OR
  • Able to switch between task applications
  • Able to Create and format presentation
  • Able to Change and Reset the slide Layout
  • Able to Apply Bullets and Numbers
  • Able to Create Sections in a presentation
  • Able to Apply Themes to a presentation
  • Change the Slide Variant
  • Able to Format the Slide Background
  • Able to Apply header and footer to a presentation
  • Able to Print Notes and Handouts

Who Should Attend

This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who wants to know, understand and want to further enhance their knowledge and practical uses of Microsoft PowerPoint.

Methodology

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

Module

  • INSERTING ART AND OBJECTS
    • Inserting Tables
    • Inserting Charts
    • Inserting SmartArt
    • Inserting Equations
  • ADVANCED SLIDE TASKS
    • Creating a Basic Animation
    • Customizing Animations
    • Using the Animation Painter
    • Using the Animation Pane
    • Setting Effect Options
    • Modifying Duration and Delay
    • Setting Animation Options
    • Changing the Order of Animations
    • Adding a Transition
    • Customizing Transitions
  • SAVING YOUR PRESENTATION
    • Saving a Presentation as PDF or XPS
    • Protecting a Presentation with a Password

 

Learn More

RM1,300.00 RM850.00

  • Availability: 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: 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: in stock
35%OFF
Microsoft Powerpoint 2013 Advanced ,
 Microsoft-Powerpoint-2013-Advanced-1-day-HRDF-Trainings

Objective

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

  • Insert video
  • Edit video
  • Use the Slide Master
  • Work with Comments
  • Record Narration
  • User the Presenter View
  • Create a Video from a Presentation
  • Create a PowerPoint Show
  • Work with multiple shows
  • Compress Media in PowerPoint

Prerequisites

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

  • Have attended Microsoft PowerPoint – Foundation & Intermediate Level; OR
  • Able to switch between task applications
  • Able to Insert Table into a Presentation
  • Able to Insert Chart into a Presentation
  • Able to Insert SmartArt into a Presentation
  • Able to Insert Equation into a Presentation
  • Able to Apply Basic Animations
  • Able to Copy Animation with Animation Painter
  • Able to Apply Transitions
  • Able to Customize Transitions
  • Able to Publish a presentation to PDF or XPS format
  • Able to Protect a Presentation with a Password

Who Should Attend

This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who wants to know, understand and want to further enhance their knowledge and practical uses of Microsoft PowerPoint.

Methodology

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

Module

  • ADDING VIDEO
    • Inserting Videos
    • Editing Video Files
  • USING SLIDE MASTERS
    • Opening Slide Master View
    • Creating Slide Layouts
    • Working with Placeholders
    • Changing the Slide Layout
    • Preserving Slide Masters
    • Updating Master Slides
    • Using Multiple Slide Masters in a Presentation
    • Removing Masters from a Presentation
  • WORKING WITH COMMENTS
    • Inserting Comments
    • Viewing Comments
    • Navigating Through Comments
    • Replying to Comments
    • Deleting Comments
  • ADVANCED PRESENTATION TECHNIQUES
    • Recording and Narrating a Show
    • Setting Narration Options
    • Using Presenter View
    • Creating a Video from a Presentation
    • Creating a Show-Only File
    • Presenting Your Slides Online
  • CREATING A CUSTOM SHOW
    • Hiding a Single Slide
    • Creating a Custom Show
    • Editing a Custom Show
    • Presenting a Custom Show
    • Deleting a Custom Show
  • MANAGING POWERPOINT FILES
    • Optimizing Media Compatibility
    • Compressing Media
    • Working with Versions
    • Recovering Unsaved Files
Learn More

RM1,300.00 RM850.00

  • Availability: 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: 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: 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: in stock
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: 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: 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: in stock
54%OFF
Microsoft Powerpoint 2013 Foundation ,
 Microsoft Powerpoint 2013 Foundation-2-days-HRDF-Trainings

Objective

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

  • Create and format presentation
  • Change and Reset the slide Layout
  • Apply Bullets and Numbers
  • Create Sections in a presentation
  • Apply Themes to a presentation
  • Change the Slide Variant
  • Format the Slide Background
  • Create Speaker Notes
  • Apply header and footer to a presentation
  • Print Notes and Handouts
  • Customize the Ribbon and Quick Access Toolbar
  • Create, Save, Edit and Use a presentation template

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 application

Who Should Attend

This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who wants to know, understand and want to further enhance their knowledge and practical uses of Microsoft PowerPoint.

Methodology

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

Module

  • THE BASICS
    • Getting Started
    • Signing In
    • Saving a Presentation
    • Opening a Presentation
    • Creating a New Presentation
  • CREATING SLIDES
    • Adding Slides to a Presentation
    • Selecting, Moving, and Deleting Slides
    • Changing and Resetting the Layout
    • Working with Sections
    • Viewing the Slide Show
  • FORMATTING TEXT
    • Changing the Font Face, Size, and Color
    • Changing Character Spacing
    • Applying Text Effects
    • Working with the Font Dialog
    • Using the Format Painter
    • Clearing Formatting
  • YOUR FIRST PRESENTATION
    • Selecting Text and Objects
    • Using Cut, Copy, and Paste
    • Using Undo and Redo
    • Checking Your Spelling
  • WORKING WITH TEXT
    • Using Find and Replace
    • Applying Bullets and Numbers
    • Changing Text Alignment
    • Formatting Text as Columns
    • Changing Line Spacing
    • Changing Text Direction
  • FORMATTING THE PRESENTATION
    • Choosing a Theme
    • Choosing a Variant
    • Changing the Slide Size
    • Formatting the Slide Background
    • Adding Headers and Footers to Slides
    • Adding Notes
  • VIEWING AND PRINTING YOUR PRESENTATION
    • Viewing the Slide Show
    • Using Views
    • Using Zoom
    • Printing a Presentation
    • Printing Notes and Handouts
  • CUSTOMIZING THE INTERFACE
    • Changing Ribbon Display Options
    • Customizing the Quick Access Toolbar
    • Hiding and Showing Ribbon Tabs
    • Creating Custom Ribbon Tabs
    • Resetting Interface Changes
  • WORKING WITH TEMPLATES
    • Creating a Template
    • Saving a Template
    • Using a Template
    • Editing a Template

 

Learn More

RM2,600.00 RM1,200.00

  • Availability: in stock

Showing 1–12 of 19 results