Goal: To present a VBA macro alternative to an earlier video on extracting characters from the right of each cell in a selection. This video…
Remove x characters from left of cell using Excel VBA
Goal: To create a macro approach to an earlier video on removing characters from the left of each cell in a selection. Download Spreadsheet Vault…
Case Study – Internal Control spreadsheet tool to manage Cash Payments
Strategize was approached by a real estate company to build a business model, which could improve the internal controls or corporate governance surrounding the payment of accounts payable invoices.
Case Study – Strategic Plan for Investor Pitchbook or Investor Presentations
Strategize executed successfully on this mandate for the client, by producing a strategic plan and financial model, which could cater to the client’s various strategic initiatives in pitching the company to private equity investors.
Financial Reporting & Strategic Planning dashboards
→ Added Value: high‐level graphical snapshot of KPIs to executives & other stakeholders
The dashboards will deliver a high‐level graphical and tabulated snapshot of the company’s actual, budget and forecasted financial performance. The drop‐down box functionality enables customisation for the end‐user.
Forecasting & Strategic Planning capacity
→ Added Value: seamless, comprehensive & robust forecasting capacity
Strategize will deliver a best‐practice financial model that will permit seamless forecasting capacity of a client’s financial statements. The implementation of a disciplined monthly reporting regime will allow financial and other corporate executives of a company, to compare and analyse financial numbers, based upon actuals versus budget or forecasted numbers.