We often get questions here at HMS about how TimeControl and Excel. Answering appropriately requires knowing why people are asking. For those who are interested in knowing if they should migrate from an Excel timesheet to TimeControl, there are numerous resources on the TimeControl website identifying the benefits of going to a centralized data-driven timesheet model. But, there are so many other ways that the two systems are tied, we’ve created a special solutions portal to help
Let’s take a look at some of the different ways you might be thinking that TimeControl and Excel are related:
Migrate from an Excel timesheet to TimeControl
Many organizations create their first timesheet using Excel. It’s a natural fit. The Excel format is infinitely flexible and perfect for designing a grid that has to use calculations to total up the week’s time and even costs. But, as an organization grows, the need for the functionality of a full timesheet system grows also. Maintenance and the management of an Excel timesheet when an organization is a handful of employees is relatively simple. When the number of people grows, that maintenance becomes more complex, more costly and a bigger challenge. That’s where TimeControl’s centralized data structure becomes much more attractive.
Importing and Exporting data between TimeControl and Excel
TimeControl includes complete support for importing and exporting data in an Excel format. If you maintain some data now in Excel, then moving that into TimeControl is a matter of moments. If you use Excel for analysis of data, then sending TimeControl’s source data to Excel is very simple. You can even schedule exports to Excel or imports from Excel to happen automatically on a schedule you determine.
Integrating Excel Services dashboards into TimeControl
Some people like using Excel’s server-based charting capabilities to create analysis of timesheet or project management data. TimeControl supports displaying Excel views in the dashboard. Need an Excel pivot report? No problem. Need an Excel traffic light dashboard? No problem.
Displaying Reports in Excel
Every TimeControl report including those created in our TimeControl Report Designer or with the TimeControl Drill Down Analyzer can be saved as Excel files so you can do more extensive analysis and reporting in the tools you are familiar with.
You can find out more about how TimeControl and Excel can work together to help your organization become more efficient on our TimeControl/Excel Use-Case portal at: www.timecontrol.com/use-cases/excel-to-timecontrol. On the portal you’ll find webcasts, factsheets and slide presentations explaining some of your options and potential benefits.