How to Leverage MS-Excel in Logistics … SFC eligible
Are you facing limitations in using MS Excel? MS Excel is commonly used in companies. However, many users may be unfamiliar with the variety of tools and techniques to maximize their productivity. Whether it is designing an inventory report, evaluating suppliers or analysing cost, MS Excel is a must-have solution.
This workshop is specially designed for professionals working in the transport and logistics industry. It is an interactive workshop in a computer laboratory where each student uses a desktop with pre-installed program and exercises to facilitate hands-on learning.
The course contents are developed by logistician using real-life examples and case studies. Participants can apply the new skills immediately through the sample exercises. This course thus provides dual benefits – participants can learn new MS Excel skills directly applicable to overcome common issues faced in the workplace.
Note : This is an intermediate level course. Participants are expected to have basic knowledge of MS Office Excel and have used the solution for at least a year. This is not an introductory course on MS Excel. The version used will be MS Office Excel 2016.
- 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
The course is an Approved-in-Principle (AIP) course under the SkillsConnect (Course Code: CRS-N-0022074 valid till 25 Dec 2019) with a support level of $2.00 per training hour for company sponsored participant. More information from Financial/Award Schemes.
Nett course fee effective from 1 Oct 2018. Company-sponsored participants are required to apply for funding via SkillsConnect at least 1 week before course commencement.
|Total Fee (payable to TLA)||$564.96||$671.96||$671.96|
(or available Credit)
* “All Singaporeans aged 25 and above can use their $500 SkillsFuture Credit from the
government to pay for a wide range of approved skills-related courses. Visit the SkillsFuture
Credit website www.skillsfuture.sg/credit to choose from the courses available on the
SFC course directory.”
Payment will only be required after the course is confirmed.
(The status of the course would usually be advised one (1) month before the course start date.)
Payment mode (retail payments facilities are not available) :
Overseas – Telegraphic transfer
Local – Cheque or bank transfer or Corporate PayNow
2 days : 9:00am to 6:00pm
Max Ee is a logistics and transport specialist with extensive experience in the private sector and working with the public sector. Graduated with a Bachelor of Business Administration (Honours) from the National University of Singapore (NUS), Max also has a Masters in Science (Logistics) from Nanyang Technological University (NTU) as well as a Graduate Diploma in Systems Analysis from the Institute of Systems Science (ISS). Previously he worked in Agility Logistics as a project manager, and handles logistics operations for Fuji Xerox Asia Pacific, KFC Singapore and Kao Corporation.
Jorge Ng is a project manager with extensive experience in customer logistics and IT project management. Graduated with a Master of Engineering (research on computer architecture) from the National University of Singapore. Previously he worked in Nokia as the Customization Development Manager and taught the subject on IT for Supply Chain at Republic Polytechnic.
He led several logistics and IT deployment projects. Using Excel and VBA programs, he developed several applications to assists users in automating logistics operations and achieved productivity. Just to illustrate a couple of applications, one that reconcile several product launch plans and another that find customer record text files base on a name list. These applications reduced operations from five days down to a half day of work.
He has two endeavours now, mainly managing project management offices with the DBS bank and a small side business partnership retailing premium seafood, which he deploys web application powered by Python and Google App Engine at almost zero cost of ownership.
External Computer Lab
A 30-minute open-book assessment will be conducted at the end of the seminar to ensure participants’ understanding on the topics. A Certificate of Achievement will be awarded upon successful completion of the assessment and attainment of 75% attendance.
This is a two days course with the syllabus categorized into sections. Each section has a particular theme to offer a structured learning.
Section 1 : Quick Tips and Productivity Secrets
- What’s New in MS Excel 2016
- Elements in a Worksheet
- Naming Cells and Arrays
- Protecting Your Worksheet
- Adding a Validation List
- Applying Conditional Formatting
Section 2 : Mastering Functions
- Formula, Functions, Arguments and Operators
- Understanding Logical Functions (IF, COUNTIF, SUMIF, AND, OR)
- Understanding String Functions (LEFT, RIGHT, MID, LEN, TRIM, CONCANTENATE)
- Understanding Lookup Functions (VLOOKUP, HLOOKUP)
Section 3 : Creating Visual Displays
- Developing Charts
- Adding Controls
- Customizing Charts
- Using Sparklines
Section 4 : Analyzing Data Effectively
- Using Pivot Tables and Pivot Charts
- Finding Optimal Solution through Solver
- Study Relationship by Applying Regression
Section 5 : Automation Techniques
- Downloading Data using MS Query
- Applying Macros
This is a hands-on course where participants will have intensive practical session using MS Excel.