Microsoft Excel™

Complex Worksheet Help With year's of experience with the various versions of Excel ™ , Data Creative can set up complex multiple worksheet Excel ™ files. These can be linked to most sources of data including corporate databases. Customised VBA and Functions We can design new bespoke Excel ™ functions, e.g. for commission calculation. We can also design full Excel ™ / VBA based systems. Visual Basic for Applications (VBA) can be used to add features and integrate all Office™ applications including Excel ™ , Access ™ and Word ™. Combined Excel ™ and Access / SQL Server™ Solutions: There are many advantages in increased productivity and efficiency by combining the functions of Excel ™ with a shared Access or SQL server database. A typical example is time-sheet entry

• Staff use Excel ™ to enter data to a shared Microsoft Access database.
• VBA links Excel ™ to a shared database.
• More users have experience with using Excel ™ and so less user training is required.
• Access used as a shared database where only a few concurrent users.
• SQL server used as the shared database for larger system
• Data can be exported from Access / SQL Server™ to Excel ™ files for further analysis or use away from the LAN e.g. on Laptops.

Automated Reporting Using a combination of Excel ™ and VBA and various sources of data, we have set up systems to automate the production of:

• Sales Analysis Reports
• Customer Audit Reports
• Price Lists

Advantages:

• Accurate / Automated
• Simple to use
• Cost effective
• Reports produced quickly

Let Data Creative Help! Excel ™ is a very powerful but complex software package. We can help you do more with it. Contact us now to discuss your requirements.