Vespa (Project Management Office)
Client
Corporate & Institutional Bank
Problem
The Project Management Office (PMO) needed a database to manage their projects and provide ad-hoc management reports.
Their own IT department quoted the business area a 6-figure solution which would take 6 months.
Solution
“My IT department is trying to sell me a Mack truck when all I need is a Vespa.”
So we called this database solution "Vespa" as it was small and nimble.
This database allowed the 6 members of the Project Management Office (PMO) to monitor the costs of each project in the department.
Analysts also wanted flexible reports.
These were created via pre-formatted Excel templates with data extracted from the database.
This solution was delivered in weeks for a fraction of the IT department’s quote.
Technology
MS Access, Excel, VBA
* To respect client confidentiality, identifiers including client logos and names have been removed from all screenshots and descriptions. Displayed names and values are fictional.
PROFESSIONAL PROJECT PORTFOLIO
Get this FREE Portfolio of VBA Projects
Get this beautiful portfolio of Excel VBA projects for ideas and inspiration.
Over 30 pages of smart solutions using Excel, Word, Outlook, MS Access and VBA.
Click the Download button to get instant access to this project summary as a PDF you can print or share.
BENEFIT FROM EXPERIENCE
Save time, money & stress
Get one-on-one access with an experienced Excel consultant who's ready to solve your business critical Excel, VBA, Formula or Macro problems.
Let me take care of everything for you and take advantage of 20+ years of Excel & VBA development experience.
