- Plymouth, GB
- £7 /hr
- Available now
I have over 10 years professional experience working with the full Microsoft package range including the Excel bolt ons (SPC XL, VBA, DOE KISS, SQA pack).
I have a diplommamore...I have over 10 years professional experience working with the full Microsoft package range including the Excel bolt ons (SPC XL, VBA, DOE KISS, SQA pack).
I have a diplomma in statistics, and extensive knowledge of Minitab and Excel database's.
My key skills are around the day to day functions within excel (Pivot tables, Formulae, Graphing and Macro automation).
I have designed, created and maintained a variety of databases and spreadsheets for various companies and my work is always timely, robust, well presented and most importantly functional.
Area Covered: Remotely
Work Experience Summary: Academic:
My background is mostly statistical and analytical, I have a green belt in six sigma and a diploma in statistics.
I have successfully undertaken advanced Microsoft excel e- learning courses and have a good experience of Visual basic and Macro programming.
I have worked for 2 worldwide manufacturing engineering companies helping to design, create and implement KPI reports and analysis using Excel and VBA.
I have designed, created and set up an automated manufacturing resource planning database which automatically advises the amount of stock required to order by calculating current stocks, order projections, parts in transit and safety levels. The database will also take into account order sizes and shipping times and give the user an easy to use requirement list and ordering date. This takes less than a minute a day to refresh using the built in Macros compared to the 3 hours a week when this process was manually done.
I have also created and put into place a custom timetabling database with an auto-generating tool for a small school with a 1to1 pupil to teacher requirement. Their needs were quite specific and had twice been let down by previous people attempting to fulfil their needs.
I have built and distributed a football results, league table and score predicting database for a client who runs a Sunday league football team. This can be manipulated, updated and amended to suit and is now widely used on the circuit.
I take pride in my work, and actually enjoy the challenge. Your Excel nightmare is my satisfaction. Please feel free to get in touch to discuss any questions you may have relating to excel / visual basic related work.
Education Summary: MS Access trained to level 3
Green belt six sigma
Advanced Microsoft Excel 2007
Diploma in statistics
Excel & visual basic developer programmer.