Useful tips about Microsoft Excel – Office 365
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.
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.
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.
E: info@ms-office-training.de
P: (+49) 04181-360254
Mon. – Fr. – 09h to 16:30h
© Copyright 2015 – 2024 | MS-OFFICE-TRAINING
Word letter template DIN 5008 - with form fields
4,95 € – 5,95 €
Word Serienbriefvorlage nach DIN 5008 | (Business & Standard)
Original price was: 12,95 €.8,95 €Current price is: 8,95 €.
Excel vacation planner 2023 | with holidays |
Original price was: 14,95 €.9,95 €Current price is: 9,95 €.
Word business letter template 2023 - DIN 5008
Original price was: 14,95 €.10,95 €Current price is: 10,95 €.
Excel Invoice template (not VAT) incl. Master Data
Original price was: 24,95 €.14,95 €Current price is: 14,95 €.
Excel budget book with dashboard and stock market indices
Original price was: 39,95 €.19,95 €Current price is: 19,95 €.
Excel Invoice Template 2023 | GER | VAT with 7% | 19%
Original price was: 29,95 €.19,95 €Current price is: 19,95 €.
Excel invoice template 2023 - for Austria - 10% | 13% | 20%
Original price was: 29,95 €.19,95 €Current price is: 19,95 €.
