Sheffield's Excel Consultant
Dr Peter Clayton
Experience gained from working on major projects
round the world, brought to you in Sheffield, the UK and globally.
|
Previous Excel Applications I have created
- Analysis of financial data to create summaries and reports.
- Budgets of $159 million and $92 million plus the creation of
a generic template for future budgets.
- Calculation of election results for Kosovo and Afghanistan.
Worksheets later used for printing and distribution the results
to the worlds media.
- Creation of reporting tools that compile into central data analysis
tool eg gathering data from workers in the field and compiling
the data into one file and analysing it.
- HR spreadsheets - salary payments, days holiday, timesheets,
recruitment tracking, staffing tables.
- Timelines for complex operations.
- Analysing of complex data eg searching for duplicates in list
of voters, error anomolies in election results.
- Analysis of prices and quotes from suppliers to work out which
is the best value.
- Creation of reports and graphs from large data sets.
- Calculators for quantities of materials eg what should the distribution
of election material be for the whole of Afghanistan.
- Tasklists of things that need to be done in a particular sequence.
- Reporting and presenting statistics for the world media.
- Creation of a spreadsheet for printing cheques and envelopes
for paying $2.25 million to 12,000 staff.
- Creation of double data entry tool in Excel.
Training Excel in Sheffield
I have also produced training material for students and managers
and trained people in Excel from the absolute beginner to refresher
courses for busy managers. I previously trained business studies
students in Excel at Sheffield Hallam University.
Dr Peter Clayton
|
Home