Shopping Cart

Use MS Excel to integrate a Fuel Management System into Pastel

Sustainable Excel Solutions In Business

The Summit Solutions mission is to empower businesses to implement successful sustainable Excel solutions internally, rather than creating an on-going dependency on us.

Over the past 20 years we’ve fine-tuned our corporate consulting and training offering to achieve exactly that. In some cases, when our Clients know exactly what they want, we skip the training and go straight into solution mode to help build and implement sustainable Excel solutions for their specific requirements.

One such client was SOS contractors who needed a solution to manipulate exported csv data into a specific format that could be imported into Pastel Accounting. This is what their Financial Manager, Tim Laithwaite, had to say:

“I approached Mark at Summit Solutions on the advice of our IT supplier. Our company has a large fleet of vehicles and many diesel bowsers in the Kwa-Zulu Natal midlands. Up until this point, fuel had been captured in a duplicate book that has to be re-captured onto our accounting system by our bookkeeper. As the number of machines and bowsers has increased over the years, capturing this data became very onerous.

We started implementing a fuel management system in 2019 that would record the issues into each vehicle amongst many other features that are useful to management. However, we needed someone with the expertise to be able to integrate the fuel system with Pastel Accounting. We had approached various people who were unable to assist us before meeting Mark from Summit Solutions.

I found that Mark quickly grasped an understanding of what we were trying to achieve and managed to understand enough of the accounting behind the process to begin to find a solution for us. Apart from the initial meeting and the final implementation of the system, everything was done off-site. Although we were not trying to achieve a completely automated system, we have managed to automate about 90% of the process, which cuts down dramatically on data capturing, but also allows us some flexibility and control over the process that is still in its roll-out phase to all the sites within our company.

I have no reservation in recommending Summit Solutions to anyone who is looking for a cost-effective way to automate and integrate various programs and applications. We will definitely use them in the future to further automate our process, or for other similar projects.”

Customer testimonials such as this one remind us why we love doing what we do. Watching a simple Excel Solution shave off hours of manual work on Tasks that are done on a regular basis is incredibly rewarding for both us and our clients! we know just how big a difference Microsoft Excel can make to one’s business.  If you have a specific requirement like Tim that you would like to systematise with an Excel solution, why not give us a call?

Want to learn more?

Receive our Excel tips and news to your inbox!

"*" indicates required fields

Choices*
This field is for validation purposes and should be left unchanged.

Request a Consultation

MS Excel Advanced Course

R 1,750

Course Length: 79 Lessons | 7.5 Hours of Videos

Content Covered

  • Key Essentials
  • Spreadsheet Integrity
  • Cell References
  • Forecasting
  • CSV Import
  • Merging Data
  • Splitting Data
  • Data Validation
  • Worksheet Protection
  • Advanced Formula
  • Text Formula
  • Date Formula
  • Logical Formula
  • Lookup Formula
  • Maths Formula
  • Pivot Tables & Charts
  • Excel Automation (Macros)

MS Excel Intermediate Course

R 1,350

Course Length: 55 Lessons | 5.5 Hours of Videos

Content Covered

  • Key Essentials
  • Series Generation
  • Advanced Copy and Paste
  • Formula
  • Cell Referencing
  • Rounding
  • View Optimization
  • Find and Replace
  • Sort and Filter
  • Graphs
  • Conditional Formatting
  • Ranges vs Tables
  • Pivot Tables
  • VLOOKUP
  • Data Manipulation
  • Keyboard Shortcuts
  • Tips and Tricks

MS Excel Beginner Course

R 750

Course Length: 56 Lessons | 4 Hours of Videos

Content Covered

  • Excel Overview
  • Key Essentials
  • Data Input
  • Excel Autofill
  • Formatting Cells
  • Number Formatting
  • Formatting Worksheets
  • Formulas
  • Printing
  • Basic Sort and Filter
  • Visualizing Data
  • Excel’s Golden Rule
  • Pivot Tables Sneak Peek
  • Keyboard Shortcuts
  • Tips and Tricks