{"id":229,"date":"2018-10-07T12:57:43","date_gmt":"2018-10-07T12:57:43","guid":{"rendered":"https:\/\/www.cmwlab.com\/blog\/?p=229"},"modified":"2026-01-06T12:27:19","modified_gmt":"2026-01-06T12:27:19","slug":"stop-tracking-stuff-in-excel","status":"publish","type":"post","link":"https:\/\/www.cmwlab.com\/blog\/stop-tracking-stuff-in-excel\/","title":{"rendered":"Tired of Tracking Stuff in Excel? Try the Workflow Tool That Works!"},"content":{"rendered":"

Microsoft\u00ae Excel\u2122 is the default business tool in many companies thanks to breadth of its functionality and incredible flexibility. Over the years Excel users have leveraged its functionality to solve a wide range of challenges. For example, MS Excel is widely used for managing tasks and projects, tracking progress in Excel is also a widely spread practice. Have you ever thought of creating a workflow in Excel? A lot of people struggle to create Excel approval workflow and give up on trying one day. If your company has a single project, Excel can be a great tool. But what if you have several projects with a huge amount of tasks people are expected to complete collaboratively? You will need more power for quick task status tracking and team collaboration.\r\n<\/p>\r\n\r\n\r\n

Is there any alternative to Microsoft Excel when it comes to managing project activities? Many users come to our support team with the same questions: how to avoid using Excel for managing project activities<\/a>. Because they have only trouble with it. With time, such Excel file grows big and becomes unmanageable.<\/p>\r\n\r\n\"CMW<\/a>\r\n

The thing is that Excel is a great tool for calculating, for tables. Yet it\u2019s not intended for managing project activities. So \u2013 what can we use instead?<\/p>\r\n\r\n

\u201c…it\u2019s easier to cope with too much workload if you have a great workflow tool.\u201d<\/blockquote>\r\n\r\n

THE PROBLEM: Stand-alone files with project activities track are unmanageable.<\/h3>\r\n\r\n

Let\u2019s take an example of a training center School which tracks training requests in an Excel file. When a new training request arrives, it gets listed in the Excel file by whoever receives it first. He inputs the training title, location, deadline and the responsible person. This file is stored on the local computer of the manager and is updated manually: when somebody needs this file, she asks to send it to her. As the result, it causes more email communication and the process visibility is low.<\/p>\r\n\r\n\"excel<\/a>\r\n\r\n

When School\u2019s team got tired of it, they shared the file. We don\u2019t know what they exactly used: it was maybe Dropbox<\/a> or Google Docs<\/a>, whatever. Anyways, now they can work on this file simultaneously and it\u2019s easier to update it. When one opens the file and makes changes in it, he may not see that the other is working on it too, making changes to it as well. So later, when he hits \u2018save\u2019, he can have an unpleasant surprise. The least of them is having input the same training twice.<\/p>\r\n\r\n

Finally, their file grew as big as 1000 trainings and it keeps growing. Since then it has become even more unmanageable. They tried to ask somebody to take care of managing this file, but all the team is already busy with organizing trainings: they just don\u2019t have time for additional work of managing their file.<\/p>\r\n\r\n

The worst is that you cannot put too much information on a single file. This would make the file even heavier and less useful. Updates are not always brought to the file timely. So with an Excel file containing information on the project you can\u2019t be in the context, right here and right now.<\/p>\r\n\r\n

The question remains: how to work on the project activities efficiently and avoid the mess with a stand-alone table?<\/p>\r\n\r\n

THE SOLUTION: live-time updates by users with workflow coordination.<\/h3>\r\n\r\n

Workflow coordination with Comindware Tracker<\/a> is the solution to this problem. It has logic of business processes integrated into it. This is drastically different from a file + comments. Here\u2019s how the School\u2019s team life changed with this workflow tool.<\/p>\r\n\r\n\r\n\r\n\"Comindware<\/a>\r\n

\n \n\n Get a 30-day trial!\n\n <\/a>\n<\/section>\r\n\r\n

School\u2019s list of training requests in Comindware Tracker<\/a> still looks like a list. There\u2019s the name of the training in the list, deadline, priority, location, responsible. Yet now it\u2019s nothing like a list of activities. What looks like a list works now like a hypertext with a workflow coordination engine inside.<\/p>\r\n\r\n

When you hit on a training item name on the list, you go to this item and see all of the information upon this training, all in one place:<\/p>\r\n\r\n\"Comindware<\/a>\r\n\r\n

With workflow coordination feature, the School\u2019s team has set a process for a training request. And the training request, with all of the information in it, goes through the workflow:<\/p>\r\n\r\n\"workflow<\/a>\r\n\r\n

\n \n\n Get a 30-day trial!\n\n <\/a>\n<\/section>\r\n\r\n

The one who\u2019s working on the work item now sets statuses, updates and priorities \u2013 and it\u2019s immediately visible to everyone, because it\u2019s online. No emails needed anymore. It\u2019s possible to discuss each work item in a special comment tread integrated into the training request form. Users have an option to receive notifications when the work item has been changed.<\/p>\r\n\r\n\"work<\/a>\r\n\r\n

With workflow management software by Comindware you can stretch beyond Excel\u2019s built-in capabilities and easier perform repeating tasks that would best be served in automated workflow. These features are specially developed to help managing work, and they are not supported in Excel. Because Excel is good for other purposes. By the way, School\u2019s team can now use Excel for its purposes \u2013 calculations and tables, and attach them to their training requests items in Comindware Tracker<\/a>.<\/p>\r\n\r\n

Nobody needs to keep it in the head: who\u2019s the next. After I finish my part of work on this work item, whom am I to notify that it\u2019s ready? The workflow decides whom the work item will go to next. No more need to check Excel file for status updates and details on every step of a workflow. \r\n<\/p>\r\n\r\n

You can try Comindware Tracker<\/a> for work management too \u2013 it\u2019s completely free for 30 days.<\/p>\r\n\r\n

Where else will this workflow tool be of use?<\/h3>\r\n\r\n

This functionality reveals to be efficient in specific activity. This is why we have crafted solutions for support helpdesk<\/a>, finance & administration, software development<\/a> and HR automation<\/a>. Some clients replace their Excel customer tracker by a solution based on Comindware Tracker and enjoy it. \r\n<\/p>\r\n

If you\u2019re doing something else, yet you\u2019d like to use Comindware Tracker to track issues \u2013 good choice! Comindware Tracker<\/a> is fully customizable and we\u2019re ready to help you set up your first process.<\/p>\r\n\r\n

\n \n\n Get a 30-day trial!\n\n <\/a>\n<\/section>\r\n\r\n
\n\t
\n