Click here for client list and testimonials

Previous PowerPoint, Word and Excel Consultant Work:

1. Creating a dynamic Project Initiation document that allowed data entry in specific places and ways, and that completed later parts of the document automatically.
2. Creation of automatic mail merge from Excel into Microsoft Word based on filters, creating different documents based on user-selected options.
3. Analysis of financial data to create summaries and reports for accountants, operational managers and stockbrokers.
4. Creation of management spreadsheets to analyse time lost from production line breakdowns.
5. Spreadsheets for analysis and presentation of fitness and injury data for Premiership football clubs.
6. Operational budgets of $159 million and $92 million for election management plus the creation of a generic template for future budgets.
7. Calculation of election results for Kosovo and Afghanistan. Worksheets later used for printing and distribution the results to the worlds media.
8. 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.
9. HR spreadsheets - salary payments, days holiday, timesheets, recruitment tracking, staffing tables.
10. Timelines for complex operations, such as planning the election operations for refugees living in 14 countries..
11. Analysing of complex data eg searching for duplicates in list of voters, error anomolies in election results.
12. Analysis of prices and quotes from suppliers to work out which is the best value.
13. Creation of reports and graphs from large data sets.
14. Calculators for quantities of materials eg what should the distribution of election material be for the whole of Afghanistan.
15. Tracking and management of task lists of hundreds of items.
16. Reporting and presenting statistics for the world media.
17. Creation of a spreadsheet for printing cheques and envelopes for paying $2.25 million to 12,000 staff.
18. Creation of double data entry system in Excel for accurate data entry.
19. Timesheets for staff clocking in and out, with calculations of monthly hours.

Contact me to discuss your full requirements

Previous client list and testimonials

PowerPoint Training & coaching

I also do training & coaching for medium and advanced users of PowerPoint such as managers who already know how the basics and want to make more powerful use of it. This might be generally or for a specific project. I have previously trained many managers in the UK and around the world in PowerPoint to maximise their efficiency and effectiveness.

Topics can be individually taught or as part of a full training package:

1. Presentation design or re-design.
2. Slide Master template slides creation.
3. Presentation automation and design.
4. Dynamically link your presentation to Excel tables and graphs.
5. Problem solving and support on frustrating Microsoft PowerPoint issues from an expert adviser.
6. Create dynamic presentations with animation, templates and slide transitions.
7. Formatting such as bullets, numbering and paragraph settings.
8. Printing and layout problem solving advice.
9. Create "Speaker's Notes" so you can see your own note and prompts on your laptop but your audience only sees the main slides.
   
10. Formatting error correction.
11. Data entry forms creation.
12. Business Process Automation.
13. Automation of data processing and analysis.
14. Creation of dynamic charts and reports for presentations.
15. Bespoke document design and development using PowerPoint Macros (VBA).
16. Excel to PowerPoint and Word integration.
17. One-off problem solving.
18. Password recovery and removal.
19. Headers, Footers and Numbering Problems
20. Tables
21. Data Entry forms / protection / restrict editing
22. Templates
23. Styles
24. Page Numbers / Page Numbering
25. Watermarks
26. Document Automation
27. Standard Paragraphs
28. Paragraph format
29. Tracked Changes
30. Table of contents
31. Formatting
32. Bullets and numbering
33. AutoSummarize
34. Linked images
35. Page Layouts
36. Margins
37. Section Breaks
38. Columns
39. Clip art
40. Citation / Bibliography Management
41. Cross References
42. VBA / Macros / Buttons
43. Extract from PDF
44. Smart Art
45. Organisation Charts
46. Spell checking
47. Copy and Paste / Special
48. Customize / Customise Ribbon
49. Printing
50. Print Preview
51. Shortcut keys
52. Line and paragraph spacing
53. Page break
54. Cover page
55. Hyperlink
56. Saving
57. Read only
58. Symbols
59. Formula and Equations
60. Auto correct
61. Dictionary
62. Foot notes
63. Word, paragraph and letter count
64. Fonts and font size

Contact me to discuss your full requirements

Certified Management Consultant