The 20/20 Excel Problem-Solving

Helping you find solutions

EXCEL TOOLS EXAMPLES

SIMPLE

  • Standard agenda (auto-timing and break highlighting)
  • External cost budgeting and tracking tool (multiple work orders)
  • Resource planning & time tracking tools
  • Risk and change management tools
  • PowerPoint presentations linked to Excel tools
  • Project plans visualization in Excel (automatic timelines display)


    COMPLEX

    • Business case builder (standard elements costs + adjustables)
    • Portfolio progression model (standard success rates and duration)
    • Portfolio/project dashboards (multi-layer, multiple data sources)
    • Automated reporting (data extract and processing with VBA)
    • Multi-project reports consolidation (e.g. monthly reporting)

    WHAT IS EXCEL PROBLEM-SOLVING?

    As die-hard Excel fans, we're true believers in the "fact" that if you can think it, it can be made in Excel!

    With +20 years' experience developing tools, reports and dashboards in Excel - ranging from a simple standardized agenda template (with a bit of built-in AI on calculating start and end time for agenda items and highlighting the all-important breaks) to more innovative and complex tools and functions e.g. automated reporting with extensive VBA programming - we can safely say, that we are yet to meet the business reporting challenge that Excel can't handle.