Concatenate text and date in Excel – Tutorial
Concatenating text and date in Excel requires a combination of two functions. We use a practical example to explain how it can be used.
16
11, 2022
27
09, 2022
Data Queries in Excel – Works with Power Query
So erstellen Sie aktive Datenabfragen durch Power Query aus verschiedensten Quellen in Excel, führen Daten aus verschiedenen Dateien und Tabellen zusammen.
16
05, 2022
Show and remove duplicate entries in Excel | Tutorial
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.
3
05, 2022
The Xreference function – difference to Sreference and Wreference
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.
21
04, 2022
Custom Formatting Excel – Number Format Codes Excel
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!
18
03, 2022
How to create a dynamic table in Excel
This is how you conveniently create a dynamic table in Excel and have it automatically carry out calculations.
25
02, 2022
Use macros correctly in Microsoft Excel
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.
27
12, 2021
Excel Scenario manager and the target value search
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.
23
11, 2021
Apply nested functions in Excel
Nested functions in Excel offer the possibility to combine several arguments with each other or to exclude conditions. We explain how it works.
