How to turn Excel into a Corporate Application

INFORMATIVE READINGS - Corporate Planning with Excel/VBA

by Dr. Gian Paolo Avanzo
Founder and CEO at Crown Consultancy Services Ltd, I worked as CFO and SAP senior FICO/Project/Transformation manager worldwide. I am committed to inspiring awareness of Best Planning Practices.Follow 16

135 views|Start the discussion!|Bookmark read for free

Description
WHO SHOULD READ THIS DOCUMENT?
Entrepreneurs, Managers, CFOs, Controllers, Financial Managers, Key Users, Auditors, Tax Advisors, Bank Managers, Financial Analysts, Management Consultants, Business Professionals.

TOPIC
What if Excel could integrate fragmented spreadsheets to sustain a 360° Corporate Scenario Planning error-free?

What if this solution could be adopted to perform consolidation of plans and budgets across the organization’s subsidiaries and be aggregated with few clicks?

When surfing the web, you may find dozens of articles that warn how Excel can be dangerous and source of risks for the organizations. Excel is not necessarily worse than other applications.

It is just the lack of best practice to help organizations design, implement and sustain spreadsheet applications.

But, how can we sketch best practice for designing a professional spreadsheet?

In this document we provide some insights from our everyday experience such as:

- Apply a project-oriented approach as if the spreadsheet were an application software
- Clearly identify business requirements
- Design & build a prototype
- Test, test and...test
- Sustain and enhance the application after go-live
- Design the most efficient architecture
- Segregate activities with multiple worksheets
- Insert knowledge area (Quick Guide, Help etc.)
- Separate input and output
and more

OUR INNOVATIVE SPREADSHEET SOLUTION FOR ENTERPRISE INTEGRATED FINANCIAL PLANNING (EIFP)
We, at Crown Consultancy Services, know that it is possible to develop an Excel application with the highest degree of security, data consistency and reliability to elevate Excel to the rank of professional EIFP application.

For this reason, we designed, developed and market ProfitQube™ – the first and the only EIFP software – that brings together the ease of use of Excel, the power of VBA language and the end-to-end business process simulation for manufacturing, trade and services companies within one modelling environment.

ProfitQube™ is a simulation software tool that provides Excel interface for modelling complex integrated financial projections producing IFRS Financial Statements with Charts, KPIs, Ratios and more.

ProfitQube’s mission is to enable SMEs, Large Organizations and Financial Professionals to manage budgets, forecasts and plans for critical decisions.

New Product - ProfitQube Consolidation is now available.
ProfitQube Consolidation is a management accounting add-on of ProfitQube which enables the consolidation of Income Statement, Balance Sheet and Cash Flow (Direct and Indirect).

The consolidation process is aimed both for corporate internal control, plan, budget or forecast and for evaluating strategic investments and joint ventures.

Crown Consultancy Services Company is a leading provider of EIFP financial simulation software.

This Best Practice includes
1 PDF Document