“Sheetgo enables our Business Control department to create a simple and efficient forecast process in Google Sheets, it saves us some serious time and money”
Sophie Kuijpers | Head of IT Operations, YoungCapital
YoungCapital is one of the biggest recruitment agencies in The Netherlands with more than 60 locations in nine different European countries. They help boost people’s careers and provide them with the opportunity to work at companies where they can make a difference. A fresh perspective on the world, endless energy, and new ideas: that’s what YoungCapital is all about.
Hours saved every year
Last year YoungCapital’s Business Control department ran into trouble. The cause of this was the hundreds of ImportRange formulas they were working with. For a moment it seemed that the only option would be to create all forecast sheets in Excel and send them around manually. This was a no-go for YoungCapital as a large part of their middle management was starting to work with Chromebooks (without Office licenses).
YoungCapital started searching for a solution to create a forecast per location to estimate current vs planned budgets, without the need for manual work. For the forecast process, they needed to collect data from 60 locations to better monitor the overall picture. Having so many different sources of data meant they needed to automate their forecast budgeting process in a centralized manner.
A key advantage for us is the fact we can centralize decentralized data and decentralize centralized data!”
Eric de Boer | Business Controller, YoungCapital
YoungCapital combines data from 60 different location spreadsheets with other data sources and centralizes this information in master sheets. This enables them to forecast results quickly and easily, freeing up more time for analysis.
YoungCapital use Sheetgo to connect several data sources, scheduling updates when they want. A key advantage for the company is the fact they can centralize decentralized data and decentralize centralized data! The result is a fully automated forecasting process that saves 3 employees 1-2 days of work per month.
Google Sheets and Sheetgo allow the Business Control department to control access to information, to provide stakeholders with insight into results—and to manage everything centrally.