When it comes to performing accounting or any other duties where data processing takes a long time or where you regularly need to perform some repetitive or similar activities and processes, it’s great to keep easy-to-use tools handy. As we are putting together courses at PwC’s Digital Academy, we would like to tell you about a tool that will make your daily tasks much easier to do. Power Query is a data preparation and transformation tool available in Microsoft Power BI and, starting from the 2016 version, in Microsoft Excel and other programs. This tool allows users to obtain data from a variety of external data sources and from files stored on computer. It allows you to group and transform data and perform other activities. This article offers a few practical examples to raise awareness of how this functionality can be used and what benefits it offers.

When external conditions are especially challenging, smooth internal processes and readily available information may prove to be a key aspect of improving your competitive edge. Today’s finance function is challenged by changes in the business environment and economy and by disruptive technology, so a CFO equipped with financial knowledge alone is no longer enough. In its annual CFO survey, PwC finds out what problems are facing companies in areas that CFOs keep on their radar as a top priority in order to grow their company and improve the performance of its finance function. This article summarises findings of the CFO survey conducted by PwC CEE and opportunities we see for supporting CFOs.

Many workers take a vacation in the summer but accountants usually pick a time with a relatively lower workload. Taking a full vacation tends to be difficult when you are supposed to be filing tax reports, calculating and paying out wages, or closing the month. This article explores replacement possibilities and an appropriate evaluation of accounting risks during accountants’ absence.