Duplicate entries in your Excel lists? This distorts your data. Our tutorial shows you, using a practical example, how to clean up your data in seconds with the "Remove Duplicates" function – whether you want to delete identical rows or just values in a column.
The OFFSET function in Excel creates a flexible reference. Instead of fixing =SUM(B5:B7), the function finds the range itself, e.g., for the "last 3 months". Ideal for dynamic charts or dashboards that grow automatically.
The INDIRECT function in Excel converts text into a real reference. Instead of manually typing =January!E10, use =INDIRECT(A2 & "!E10"), where A2 contains 'January'. This allows you to easily create dynamic summaries for multiple worksheets.
Copilot is growing up: Microsoft's AI is no longer an assistant, but a proactive agent. With "Vision," it sees your Windows desktop; in M365, it analyzes data as a "Researcher"; and in GitHub, it autonomously corrects code. The biggest update yet.
Everyone was waiting for Windows 12 in October 2025, but it didn't arrive. Instead, Microsoft is focusing on Windows 11 25H2 and "Copilot+ PC" features. We'll explain: Is Windows 12 canceled, postponed, or is it already available as an AI update for Windows 11?
Want to block unwanted websites in Windows? You can do it without extra software using the hosts file. We'll show you how to edit the file as an administrator and redirect domains like example.de to 127.0.0.1. This will block them immediately in all browsers.
Caught red-handed? Your Outlook inbox has 1000+ emails? That's pure stress. Stop the email deluge with the "Zero Inbox" method. We'll show you how to clean up your inbox and regain control using Quick Steps and rules.
Deceptively authentic emails from your bank, DHL, or PayPal? That's phishing! Data theft and viruses are a daily threat. We'll show you 5 simple rules (2FA, password managers, etc.) to protect yourself immediately and effectively and help you spot scammers.
Say goodbye to file chaos! "Offer_final_v2.docx" is a thing of the past. Learn 5 simple tips for a perfect folder structure on your PC and in the cloud (OneDrive). With proper file naming and archive rules, you'll find everything instantly.
E: info@ms-office-training.de
P: (+49) 04181-360254
Mon. – Fr. – 09h to 16:30h
© Copyright 2015 – 2025 | 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 €.
