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…
When picking the dates in Excel documents, you may accidentaly make a mistake. The ideal way to avoid this is to use the Date Picker tool. For now, there is no simple solution within the application itself that can be used for this purpose, but there is a simple add-in available that can help with the date selection process.
A few years ago, Excel, which comes as part of a Microsoft 365 subscription, got the Ideas option. Now this option has been improved and is called Analyze Data. It enables, with the help of artificial intelligence, simple and fast data analysis to generate tables, pivot tables or charts according to user questions, which help user to visualize data in appropriate business reports.