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...

Excel for marketers

Excel is one of the most used tools for data analysis by marketers. If you a marketer, you probably use Excel very often for planning costs, projects, tasks, sales and preparing several different reports. But how well do you really know how to use it? Most of marketers can’t use ...