Learning Excel

Task tracking in Excel

Plan, manage and track your team's tasks, projects, deadlines, costs, and resources in one automated Excel solution.

Learn how to automate Excel by working properly with a single table with a simple database in the background. The result is:

• error-free, controlled data entry, ...

Automate Cost Management in Excel

Learn how to automate your Work in Excel:

• Plan your costs,
• Compare the cost plan with realization,
• Track cost by projects, cost centers, and accounts,
• Optimize your work with one file for multiple users, each user has its data input table,
• Create common reports.

No IT staff su...

How to create a common report from several Excel tables

Learn how to create a common Excel report from several tables on separate sheets for multiple users:

1. Create a query from table / range
2. Append queries in a single database
3. Create a common report Watch the video for cost planning use case.

Learn more about how to automate Excel ...

8 steps Excel automation guide

Automate your work in Excel and significantly reduce the time for performing daily tasks and reduce the possibility of errors due to manually entering all data. Follow 8 key steps and modernize your work in Excel.

1. Define the data you are interested in and want to collect. Consi...