Topics: Microsoft Excel – Office 365
Topics: Microsoft Excel – Office 365
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.
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.
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.
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.
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!
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.
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.
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.
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.
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.
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.
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!
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.
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.
Search for further topics:
Search for further topics:
Popular Posts:
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.
Create and save your own text modules in Word
Create your own text blocks in Word, save them and quickly add ready-made text and graphics to your documents.
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.
Encrypt emails in Outlook – How it’s done
Standard e-mails are like postcards that everyone can theoretically read. But there are solutions for more security.
Incognito Mode Chrome and Firefox – How secure is it?
With this command in Windows 10 you can display the browser history despite incognito mode.
Environmentally friendly printing for more climate protection
Climate protection starts small. And so not only can costs be saved through environmentally friendly and conscious printing in the office, but the climate can also be protected.
Popular Posts:
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.
Create and save your own text modules in Word
Create your own text blocks in Word, save them and quickly add ready-made text and graphics to your documents.
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.
Encrypt emails in Outlook – How it’s done
Standard e-mails are like postcards that everyone can theoretically read. But there are solutions for more security.
Incognito Mode Chrome and Firefox – How secure is it?
With this command in Windows 10 you can display the browser history despite incognito mode.
Environmentally friendly printing for more climate protection
Climate protection starts small. And so not only can costs be saved through environmentally friendly and conscious printing in the office, but the climate can also be protected.