After 20 years of working with users in various manufacturing companies, I have realized that employees love using Microsoft Excel in their work. They invest a lot of effort in (successfully) creating large and complex excel tables which are linked by infinitely long and complex formulas, and with every new entry, this infinite chain of formulas must be updated manually. Which is, both in terms of time and coordination, not an easy task and – it gets even worse – there is a good chance of errors when it is done manually.
Furthermore, these two-dimensional tables in the xlsx files are organized in sheets named by departments. This presents a problem to start with: how to create a common and clear report that always contains correct and updated data and results.
That’s why I started exploring how to use Microsoft Excel to standardize data sources, reduce the number of inputs or clicks for the user to do their job as quickly, easily and correctly as possible. How to automate the whole work process, from user-friendly data entry to creating interactive reports through common databases so that the results are refreshed in real-time.
Based on the different use-cases (sales, purchasing, quality control, production, materials management, capacity and cost planning, finance and accounting, HR, etc.), I developed all-in-one and network Excel solution: it only takes a single data entry, and with each subsequent step, data is automatically upgraded into a controlled data model structure ready for analytics in Microsoft Excel or any BI tool.
The users love the solutions presented, and they develop their own solutions based on everyday practical examples.
It is this enthusiasm that motivated me to turn 20 years of practical, possibly little unconventional, knowledge of Microsoft Excel into the interactive eLearning courses that are now available on this website.
I hope you will find them useful too.
Thank you for your trust.
© 2022 Excel in Practice. All right reserved.