How to automate reports in Excel

One of the repetitive tasks in many companies is reporting (projects, cost estimates, sales…). Reports are usually prepared manually in many cases in Excel. Working in Excel often implies dealing with a huge amount of xlsx tables. The tables are completed manually, the data are...

Excel for project management

Although Excel is not marketed as a project management software, when it comes to project tracking, the tool is more efficient than most people realize.

If you do not have a professional project management tool, Excel might be the best choice. On the other hand, if you already ha...

Top 3 most useful Excel formulas

If you want to automate your work in Excel, the combination of formulas VLOOKUP + IF + TODAY () is an extremely useful tool. With these 3 key formulas you can present all events that are important in a work process (e.g., costs monitoring, tasks tracking, delivery dates…).

The IF...

How to build an Excel solution for use on a local network

Microsoft Excel workbooks usually contain a whole range of spreadsheets, each containing many different pieces of data. Working with them is not only time-consuming but can result in errors. For instance, manually inserted formulas can crash; we can accidentally miss formulas and...