Useful tips about Microsoft Excel – Office 365
Concatenating text and date in Excel requires a combination of two functions. We use a practical example to explain how it can be used.
So erstellen Sie aktive Datenabfragen durch Power Query aus verschiedensten Quellen in Excel, führen Daten aus verschiedenen Dateien und Tabellen zusammen.
We explain how to remove duplicate entries from Excel. And also how you can only display duplicate entries in Excel but not delete them immediately in order to decide on a case-by-case basis.
Pretty much everyone who uses Excel knows the Vreference and the Wreference. On the other hand, something newer is the X reference, which can be used to iron out some of the weaknesses of the functions used up to now. We explain the differences between Xreference and Sreference & Wreference.
We use a practical example to explain the importance and possible uses of custom formatting in Excel. Number format codes in Excel are not rocket science!
This is how you conveniently create a dynamic table in Excel and have it automatically carry out calculations.
Almost everyone has heard of the term "macro" in the context of Excel, and perhaps has shied away from it because it sounds like a rather complicated affair for which you have to deal with Excel programming.
How you can use the scenario manager and target value search in Excel 2016/2019 to present complex issues in a space-saving and clear way.
Nested functions in Excel offer the possibility to combine several arguments with each other or to exclude conditions. We explain how it works.
