Pivot tables have been with us for a long time and allow us to easily analyze data by changing the perspective from which we look at them. Recently, there is also a PIVOTBY function that allows us to get a similar report, but in an Excel spreadsheet. By marking rows, columns, values and other parameters, a dynamic report is generated. Here’s a post about how to use this function…
If writing SQL queries is in your job description I am certain that you, in great extent, inside SELECT command, use a GROUP BY clause that allows you to group row values by a given column and then apply an aggregation function, e.g. SUM, COUNT, AVERAGE, MIN, MAX… I have good news for you: we can achieve almost the same thing within an Excel report by using the GROUPBY function…
Python has finally become part of Excel, and from now on you can add pieces of Python code to a sheet to define datasets, process and visualize them. If you have a Microsoft 365 subscription and have downloaded update 2409 (Build 17628.20164), you will be able to use Python normally (no longer reserved for testers only). In this short intro you will learn what Python is and how it can enrich your reports.
The introduction of the SVG format in Excel has gone unnoticed by most users, and it enables the conversion of maps into standard graphics objects. After that, you can do whatever you want with them. In this simple “recipe”, I’ll show you how to convert and format SVG maps you have previously downloaded, in order to create effective reports…
When working with pivot tables, you will sometimes use filters to change how the data is presented in report based on the selected criteria. Using filters or using slicers are completely legitimate methods. But what if you want to create a separate report for each criterion you used in the filter. Excel has a simple option that allows you to do this…