Clean Data is an AI feature in Excel that automatically finds inconsistent data and suggests error corrections. It works with data tables and usually, within their columns, finds excess spaces, uneven use of lowercase and uppercase characters, non-conforming formats, blank values, duplicates, errors… This option sometimes runs automatically, immediately after opening the document, and you can also run it manually…
Until now we used Text Import Wizard to import text, and nowadays we can achieve the same result, whether it’s TXT or CSV files, with two new functions: IMPORTTEXT and IMPORTCSV. These functions are very similar: the first one offers more features, while the second is intended exclusively for importing from CSV files. Both functions return a dynamic array, are easy to use, and can make it much easier to import data.
When you create formulas in Excel, you can refer to cell addresses, and you can also name cells or ranges by using the Name Manager to create the appropriate names. Can names be created automatically? Yes they can! After selecting a range, and giving a criterion in the Create from Selection option, you can create names automatically…
Since 2018, Excel has undergone one of the biggest transformations in its history with the introduction of functions for working with dynamic arrays. Unlike traditional functions that return a single value, these functions can generate entire tables as a result. Because these tables are dynamic, any change to the data in the source is automatically reflected in the displayed result. How to format dynamic results?
Slicers are graphical objects that we can use to filter data on a Power BI report page. When we use the dates to create slicers, then we create the so-called Timeline slicer. Until now, we were able to manually select a date range to filter the data in the report, and recently it is possible to run a Date Picker control in order to chose a date within a slicer.