MS Office Training

16 11, 2022

Concatenate text and date in Excel – Tutorial
Concatenate text and date in Excel – Tutorial

Concatenate text and date in Excel – Tutorial

2023-06-03T16:47:55+02:00By Michael|Categories: Microsoft Excel, Microsoft Office, Office 365, Shorts & Tutorials|Tags: Excel, Excel tables|

Concatenating text and date in Excel requires a combination of two functions. We use a practical example to explain how it can be used.

27 09, 2022

Data Queries in Excel – Works with Power Query
Data Queries in Excel – Works with Power Query

Data Queries in Excel – Works with Power Query

2023-06-03T16:49:44+02:00By Michael|Categories: Microsoft Excel, Microsoft Office, Office 365, Shorts & Tutorials|Tags: Excel, Excel tables|

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
Show and remove duplicate entries in Excel | Tutorial

Show and remove duplicate entries in Excel | Tutorial

2023-06-03T18:05:55+02:00By Michael|Categories: Shorts & Tutorials, Microsoft Excel, Microsoft Office, Office 365, Uncategorized|Tags: Excel, Excel tables|

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.

21 04, 2022

Custom Formatting Excel – Number Format Codes Excel
Custom Formatting Excel – Number Format Codes Excel

Custom Formatting Excel – Number Format Codes Excel

2023-06-03T18:09:07+02:00By Michael|Categories: Shorts & Tutorials, Microsoft Excel, Microsoft Office, Office 365, Uncategorized|Tags: Excel, Excel tables|

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
How to create a dynamic table in Excel

How to create a dynamic table in Excel

2023-06-03T11:09:20+02:00By Michael|Categories: Microsoft Excel, Microsoft Office, Office 365|Tags: Excel, Excel tables|

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 Excel
Use macros correctly in Excel

Use macros correctly in Excel

2023-06-03T11:10:34+02:00By Michael Suhr|Categories: Microsoft Excel, Microsoft Office, Office 365, Shorts & Tutorials|Tags: Excel, Excel Calendar, Excel tables|

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.

8 01, 2022

Microsoft Office 2021 – Is the switch worth it?
Microsoft Office 2021 – Is the switch worth it?

Microsoft Office 2021 – Is the switch worth it?

2023-06-03T16:13:58+02:00By Michael|Categories: Microsoft Word, Microsoft Excel, Microsoft Office, Microsoft Outlook, Microsoft PowerPoint, Microsoft Teams, Office 365, Product Tests|Tags: Excel, Microsoft, Outlook, PowerPoint, Word|

Since October 5, 2021, the time has finally come. After Office 2019, Office 2021 is now at the start. We took a closer look at the new Office version and found out whether the switch is worth it.

27 12, 2021