Microsoft Office Productivity Specialists

Support, Training & Automation that . . .


Inspires *                                                                Saves time, money & effort                                                             Entertains

PC Tamers outlook training sussex,word training sussex,outlook course sussex,word course sussex,excel course sussex,help with powerpoint sussex,powerpoint course

The scenario



Philips CMS (Country Management Systems) were supplied with several  huge spreadsheets from three separate sources which needed to be collated, modified and reports produced - including a driver statement for each company vehicle driver.

Philips CMS provides manages services for the rest of the Philips divisions, such as Healthcare and Lighting. As such they provide support for the company’s Fleet Department.

The Solution

Macros were created to collate the three spreadsheets into one workbook, modify the formatting so they were identical. Once this was achieved a Pivot Tables was created to allow analysis of the data. Further Pivot Tables were automatically created, one for each of the 2,500+ company vehicle drivers, which resulted in an Excel workbook with over 2,500 worksheets in it.