Interactive Excel courses

Interactive Excel courses

Excel in Practice interactive courses will help you manage your day-to-day work with Microsoft Excel

faster, easier and error-free.

Improve the organization of your group work with network solutions.

Automate data and report refreshing.

Read our Blog ›

Problems working with Microsoft Excel

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 more

The optimal single-table solution

Errors can be avoided by working properly with a single table and a simple database in the background. And the result is:

  • error-free, controlled data entry, facilitated by mandatory fields with centralized code lists
  • real-time refreshing of data from different tables (sources)
  • a common table linked to several input tables. It is a "database" used to create interactive reports, monitor KPIs, create dashboards.

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:

  • sales
  • production
  • purchasing
  • marketing
Buy now

Author of the Excel in Practice interactive courses

Author of the Excel in Practice interactive courses

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 ›

See my references ›