In our latest Excel training case study, we spoke with an admin manager at Wincanton, a leading logistics company in the UK about how our in-person Excel training transformed her team’s data management and reporting processes through effective corporate Excel training.
Learn how this manager and her team at Wincanton, went from grappling with manual Excel tasks that consumed hours of work to reducing workload by two full days per week on tasks that could be streamlined with better Excel knowledge. That’s a whopping 16 hours per week saved!
The Challenge: The admin manager and her team at Wincanton, a leading logistics company in the UK, faced a common challenge in the corporate world: efficiently managing and manipulating data in a timely manner. With Excel as their go-to tool, employees were losing hours on manual tasks due to varying proficiency levels. The need for corporate Excel training was evident.
The Solution: Systematix, a premier provider of instructor-led Excel training in the UK, stepped in with a comprehensive learning program. This wasn’t just about learning Excel; it was a masterclass in transforming Excel into a powerful tool for data management and reporting.
The Results: The admin manager and her fellow Wincanton employees reported a massive increase in their skill level after the Excel training, saving 16 hours per week and a possible total of 64 hours per month across the organisation being clawed back! This efficiency gain was a revolution in workflow and data management, highlighting the power of effective corporate Excel training led by our instructors.
In conclusion, Systematix’s corporate Excel training transformed this team at Wincanton, enabling them to harness the full potential of Excel, leading to improved efficiency and mastery in data management.
This IT and business skills case study serves as a testament to the power of effective training and the role it can play in transforming business operations.
Wincanton, a third-party logistics company in the UK, faces what we all do in the corporate world – effectively managing m manipulating and reporting on data using Excel. With an employee base of nearly 20,000, the majority of whom are warehouse and driver-based colleagues, the office staff of just over 4,500 already use Excel to handle their reporting needs, but with that many employees – that’s a LOT of data to manage. Excel and Microsoft was their go-to tool, but many employees were spending hours on manual tasks where the likes of pivot tables, vlookups, and concatenating columns could help. The need for corporate Excel training was evident.
“Excel really is our go to tool of choice for reporting. I’m literally in it probably from 9 o’clock in the morning till 5 o’clock in the afternoon doing various exports from systems which export into Excel.”
You know yourself when it comes to data; you’d normally sort, filter, and sum data across multiple tables, a time-consuming task pivot tables expedite by automatically aggregating and summarising data in a way you could actually understand and use to move the business forward. But not everyone in the organisation new how to make use of the advanced Excel functions that make our life WAY easier.
“I was spending hours of unnecessary time trying to run reports and produce fancy graphs and dashboards.”
After engaging Systematix for our expert instructor led Excel training courses and corporate Excel training programs that could cater to the varying skill levels within the organisation, Wincanton needed a program that could provide their employees with the skills they needed to use Excel efficiently, whether they were Excel beginners just starting out with Excel or advanced users looking to further hone their skills.
This is where our team Systematix, your leading provider of Excel training in the UK, came in. With our comprehensive Excel training programs, we were ready to help Wincanton overcome this challenge and unlock the full potential of Excel data management for their organisation.
Offering three levels of training – basic Excel training, intermediate Excel training, and advanced Excel training – Systematix provided a comprehensive learning experience that catered to the varying skill levels within Wincanton. The training was not just about learning Excel; it was about understanding how to use it as a powerful tool for data management and reporting and how it interacted with their existing Power BI use.
“Systematix also provide us with Power BI training as well. So it’s not just Excel we needed them for.”
The trainers from Systematix, with their deep knowledge of Excel’s capabilities, were able to deliver a training experience that was both enjoyable and highly beneficial for the admin manager and her team as well as the organisation, with additional Power BI training.
“I was doing Excel and data input very, very manually without knowing that all these quick functions were even available.”
The admin manager reported specifically that aspects like VLOOKUPs helped her replace the manual search for matching values in large datasets, so she could rapidly merge data from different sources. Where concatenating columns manually involves copying and combining data from multiple cells one by one, understanding Excel shortcut functions like the CONCATENATE function or ‘&’ operator in Excel streamlines this process, instantly merging values from multiple columns saving her time.
But how much time?
The admin manager said her team of 3 saved at least 16 hours per week after the Excel training.
“I was spending hours of unnecessary time trying to run reports and produce fancy graphs and dashboards. I’m now saving at least 2 days per week after the Excel training.”
The impact of the in-person Excel training was significant for the admin manager, her team and the business as a whole. We were also very happy to say that she reported a massive increase in her skill level after completing the course.
“The skill level after completing the course is massively increased, I would say. Lee at Systematix was incredibly helpful in training the team.”
The admin manager, who’s team previously spent two full days per week on tasks that could be streamlined with better Excel knowledge, reported saving those two days after the training. That’s a whopping 16 hours per week saved, freeing up significant time for other important work.
Let’s say YOUR organisation has as many employees as Wincanton. With around 4,500 employees using Excel in some capacity, each saving at least one full day (or 8 hours) per week after the Excel training led by our instructors at Systematix, the total time saved across the organisation could be estimated at an astounding 36,000 hours per week. This equates to 144,000 hours per month, assuming a 4-week month.
That’s a LOT of time saved!
It’s important to note that not all 4,500 employees completed the Excel training as their roles or skill levels varied – but those who did, saved time in the long run.
“The workbooks are easy to follow. The trainers at Systematix are very, very knowledgeable.”
It’s safe to say that these figures illustrate the immense efficiency gains and time savings that instuctor led Excel training can bring to an organisation like yours. Tasks that once took hours are now completed more efficiently, leading to significant time savings and improved workflow.
The training has not only empowered Wincanton’s employees to make the most of Excel’s capabilities but has also led to substantial productivity gains for the organisation as a whole.
This Excel training case study serves as a testament to the power of effective instuctor led Excel training led by real people and the positive role it can play in transforming business operations. Businesses like YOURS!
We’ll help you meet your company training needs with instructor-led business skills and IT training courses, or your money back. Take courses in our UK classrooms or online – it’s your choice! View all of our Microsoft Excel training courses and learn from experienced instructors in the UK: https://www.systematix.co.uk/courses/microsoft-office/excel
Or contact us today: https://www.systematix.co.uk/contact-us
Payments processed by
