Tag Archives: timecontrol and excel

The many links between TimeControl and Microsoft Office 365 including Excel

We often don’t talk about all the ways TimeControl can touch Microsoft technology because there are so many and every organization might be different in how it wants to leverage Microsoft’s technology with their centralized timesheet system.

TimeControl has a pre-defined link to the Microsoft Project products including Project on the Desktop, Project Server, Project Online and Project for the Web.  TimeControl can be displayed inside a Teams tab.  TimeControl can be displayed within SharePoint or even link directly with SharePoint lists, pulling task information from a task list and even pushing back actuals.  TimeControl reports can be saved in Word read-able format orin images for consumption by PowerPoint.

But let’s just focus for a moment on Excel.

Whether you are thinking of Excel on your Desktop or Excel in Office 365, TimeControl has numerous ways to integrate that technology.  Here are just a few:

Importing and Exporting data between TimeControl and Office 365 Excel

TimeControl includes complete support for transferring data to and from Excel files.  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 define.

Importing legacy timesheets from Excel to TimeControl is already included

TimeControl includes import functionality for timesheet data itself so, if you have an existing timesheet system in Excel you can transfer that data into TimeControl.  Our Excel Solutions Portal even has a template for you to download and use so you don’t have to create it yourself.

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 in your TimeControl dashboard?  No problem. Need an Excel traffic light on the TimeControl dashboard?  No problem.

Displaying TimeControl 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.

Migrating from Excel to TimeControl or TimeControl Online is so simple

When new TimeControl systems are established, they are almost always provisioned for the first time from Excel files.  Even if you are not using an Excel timesheet, Excel is an easy tool for bringing data into one place, manipulating if need be then uploading it into the controlled environment of TimeControl.

For more information on linking to Excel or Microsoft Office Excel 365 or migrating from an  Excel-based timesheet system see our TimeControl/Excel Solutions Portal or speak to one of our TimeControl experts at HMS Software at info@hms.ca.