Solumac Ltd Logo - Link to homepage Solumac Ltd animation
technology solutions for real businesses
 
NEW WEBSITE
with our full range of custom solutions
  
 
MS Excel Solutions

MS Excel is probably the most utilised tool available for data analysis. However, very few of us actually use its exceptional features beyond basic. How often do we tediously import data manually from external sources, including cutting and pasting…

Solumac can develop applications that incorporate features like web queries, 3-D cell referencing, standard and user-defined functions to enhance user experience for faster and effective performance. One other important feature of MS Excel is the use of macros. These are simple and easy to customise, yet powerful tools to automate many tasks.

Let Solumac help you to exploit your user's familiarity with MS Excel interface to extend the power and capabilities of your application and achieve better results with advanced spreadsheet models.

key benefits
+ very familiar interface
+ very low maintenance
+ highly customisable
+ easy to migrate to larger more structured solutions
+ automation of common tasks using macros
+ rapid development cycles
+ excellent integration with other MS Office tools
+ excellent data & performance analysis tool

With the release of MS Office 2003, we can now develop Excel and Word solutions for your business as Smart Clients. This will automatically expose your business to added benefits that traditional client/server and browser-based applications currently do not posses.

Migrating MS Excel Solutions

As your business grows, your spreadsheets start to grow in features and complexity: the number of staff also requiring the spreadsheets grow. Before long, the effort to maintain the MS Excel application starts to exceed the business benefits as the files get copied, edited and emailed around.

When this happens it may be time to consider migrating your MS Excel database application to a relational database application such as MS Access or MS SQL Server.  These will make your application more stable as they provide a structured approach to business data.

Solumac can migrate your solutions hassle free for you. You will still be able to analyse your existing data in MS Excel as and when required.

 

t:+44 (0)845 009 1137
Excel Solution Examples

 Employee Attendance  Tracking System

As an office manager your role may include monitoring staff attendance and holiday records. A simple MS Excel application will enable you to manage the process seamlessly, providing you quick access to data such as how many holiday days are left for each member of your staff.

Inventory Tracking System

Simple application that enables you to effectively determine your minimum stock level, which then defines your reordering point.