Working with Microsoft Excel often implies dealing with a huge amount of xlsx tables. The tables are completed manually, the data is not controlled, hence there is a high chance of errors (typing errors, same content entered in different ways, etc.).
When entering new data, all tables must be manually updated and formula errors corrected (they can collapse), which not only takes a lot of time but facilitates new errors.
When tables are updated by hand, some can easily be missed out.
To be honest, making a report from several tables is impossible, because yet another table needs to be created – which is again done manually.
On top of that, “hand-made” tables lack clearness. Sounds familiar?
Learn moreErrors can be avoided by working properly with a single table and a simple database in the background. And the result is:
You only need to learn basic logic on one typical example to be able to apply your knowledge in many others. For this interactive course, we have chosen the two most common examples from the real world that many users come across – so to speak – every day:
1. Project management
2. Cost planning
Self-learning Excel courses let you choose the time when you want to learn and how fast you want to go. You get files for interactve lessons and Excel files which you can adapt to meet your needs and requirements. By studying the two examples, you will acquire knowledge that will allow you solve problems in different fields. Both examples have been tested in practice and validated by users from various departments:
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.
Marija Nardin
See Excel courses description ›
© 2022 Excel in Practice. All right reserved.