How to Leverage MS-Excel in Logistics

Select Industry/Course: Select Course Diploma in Integrated Logistics Management Diploma in International Freight Management DG Management : Applications & Processes Emergency Response Plan for LSP How to Leverage MS-Excel in Logistics Logistics Execution Systems Higher Diploma in Supply Chain Management Standard Trading Conditions Delivering Superior Customer Service Effective Presentation Skills International Trade & Effective Handling / Processing of Letter of Credit Managing Challenges on Airfreight Forwarding Seafreight Forwarding Operations Supply Chain Security - Risk Assessment Analysis Supply Chain Security - Introduction to Logistics Operation Security Supply Chain Security - Operations Risk Management Supply Chain Security - Security and Safety for Freight Logistics PSA/SLA Dangerous Goods Course

Target Audience

- Logistics Account Managers and Executives
- Operations / Warehouse / Distribution Supervisors and Officers
- Customer Service Officers
- Material Planners and Buyers
- Quality Assurance Officers
- Inventory Management / Control Officers

Basic knowledge on MS-Excel would enable participants to greatly benefit from the workshop.

Course Overview

This workshop is specially designed to allow participants to appreciate the usefulness of Microsoft Excel in their daily work. Whether it is analyzing data, preparing reports, querying information to answer customers, Excel is a powerful tool that is widely available and flexible to use. Through this workshop, participants will understand the common functions and how to leverage Excel to maximize productivity and perform their tasks more effectively and efficiently.

This workshop is different from other available Excel courses because the teaching focuses on logistical reports and related work. Common problems in logistics are discussed and solutions using Excel are highlighted. Thus, participants enjoy double benefits – learning a software tool as well as immediate application of the tool to work.

Course Duration

1 day : 9am to 6 pm (8 hours)

Course Outline

• Navigation
- Basic introduction to toolbars, labels, formula and worksheets

• Data Input
- Data Entry and Validation

• Data Presentation
- Charts, Filters and Formats

• Data Processing
- Using formula and commands to sort and group data
- Commands cover ABS / MOD / OR / AND / IF / CONCANTENATE / LOOKUPS
- Formulations cover Subtotal / Count /Pivot Table
- Practical : Create a Stock Take Report using the above concepts

• Data Analysis
- Sensitivity Analysis / Goal Seek / Regression Analysis
- Practical : Forecast Stock Demand for FMCG

• Data Extraction
- Introduction to Database Structures (Tables and Relationships)
- Using MS Excel Query
- Preparing Reports
- Practical : Create an Ageing Report

Course Location

Obtech Asia Pacific Pte Ltd
22 Cross Street
#03-54/61 South Bridge Court
Singapore 048421

Methodology

This is a hands-on course where participants will have intensive practical session using MS Excel.

Certification

A Certificate of Achievement will be awarded upon successful completion of the course.

Price

• Price (Includes GST)
  Full Course Fee:
  -$256.80 (For SLA Member / Self-Sponsored)
  -$310.30 (For Non-Member)
  Nett Course Fee (after SDF training subsidy) :
  -$241.80 (For SLA Member)
  -$295.30 (For Non-Member)
  

Funding Info

The course is an Approved-in-Principle (AIP) course under the SDF EasyNet with a support level of $2.00 per training hour. (Please note that the AIP status is subjected to renewal by the Skills Development Fund.) Sponsoring companies who fulfill the following criteria, are required to pay only the unsupported portion of the course fee to association :

- Participants must be Singaporeans or Permanent Residents or 3-year Work Permit Holders.
- Companies must be registered in Singapore and bear the full training cost.
- Only company cheques are allowed for payment of course fees.

As the association endeavour to qualify the course for renewal of AIP status each year, all sponsoring companies are required to sign a letter of undertaking in which they will undertake to bear the portion supported by the Skills Development Fund to the association should their sponsored staff fail to achieve 75% attendance and/or are absent from the examination.

Enquiry

Type of enquiry Corporate Individual

Company Name

Name *

Contact No *

Email *

Preferred Contact Email Telephone Call Morning Noon Evening

Questions & Comments

Enter characters displayed

* Mandatory fields

Our Partners