Excel-based Expense tracking tool for Ship Management

A ship management company typically is engaged by ship owners to operate their tanker ships within a strict yearly budget. This company approached us to improve their Excel expense tracking tool for a fleet of 20 ships.
Vessel Tanker

Client Problem:

A ship management company typically is engaged by ship owners to operate their tanker ships within a strict yearly budget. This company approached us to improve their Excel expense tracking tool for a fleet of 20 ships. We found the following problems: –

  1. Contained lots of worksheets which confuse the user.
  2. Manual entries caused frequent errors.
  3. A long vendor list which made it frustrating to update accurately.

Our Solution:

We worked closely with the Technical Director to create an Excel based application that makes it easier for the admin staff to enter expense data to reduce errors and time. In addition, a reporting module was created for the director to create separate expense reports for each vessel. Overall, we manage to reduce Excel worktime from 3days to less than 2hours on a weekly basis.

About Aeternus Consulting

Aeternus Consulting is a Microsoft Office consultancy and & digital creative agency. We specialise in Microsoft Office training, VBA application development, Business modeling in Excel, infographic designs, data visualizations and web UX UI.

Related Link: Aeternus Consulting Singapore

Leave a Reply

Your email address will not be published. Required fields are marked *

Contact Us

Drop us a message even when it’s late because the best ideas can come at night.

About Aeternus Singapore

aeternus consulting singapore logo
Aeternus Consulting is the premier consultancy firm for analyst-grade Microsoft Office training courses in Singapore. ACRA: T14LL0891K

Microsoft Office training solutions

corporate training course chair
We work with businesses and individuals who need effective Microsoft Office training solutions.

Analyst-Grade Training Courses

analytics with microsoft excel chart
Premium Training for Business Analysts, Data Analysts & Information Specialists in Singapore.

Our Services Include

Our Microsoft Office-centric services include:
* Full range of Microsoft Excel Training Courses in Singapore.
* Microsoft Office PowerPoint Training Courses.
* Consultancy in Excel, Access, VBA Application Development & PowerPoint Presentation Design Projects.
* Personal coaching & corporate bespoke Microsoft Office training sessions for employees.

Training Course List

Excel Basic, Intermediate, Advanced Levels
Excel PivotTables Inside Out
Data Management & Data Analysis in Excel
VBA Programming with Excel
Advanced VBA Programming with Excel
Essential Microsoft Excel for HR Professionals
Up to Speed with Microsoft PowerPoint
PowerPoint Design & Animation Ideas for Business
Microsoft SharePoint Training Workshop

Instagram (@aeternusconsulting)