Office, Karriere und Technik Blog

Office, Karriere und Technik Blog

Contact2023-06-03T18:32:36+02:00

Write a message

Write a message

Popular Posts:

2710, 2025

Dynamic ranges in Excel: OFFSET function

October 27th, 2025|Categories: Shorts & Tutorials, Microsoft Excel, Microsoft Office, Office 365|Tags: , |

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.

2710, 2025

Mastering the INDIRECT function in Excel

October 27th, 2025|Categories: Shorts & Tutorials, Microsoft Excel, Microsoft Office, Office 365|Tags: , |

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.

2310, 2025

From assistant to agent: Microsoft’s Copilot

October 23rd, 2025|Categories: Shorts & Tutorials, Artificial intelligence, AutoGPT, ChatGPT, Homeoffice, LLaMa, Microsoft Excel, Microsoft Office, Microsoft Outlook, Microsoft PowerPoint, Microsoft Teams, Microsoft Word, Office 365, TruthGPT, Windows 10/11/12|Tags: , , , |

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.

2110, 2025

Windows 12: Where is it? The current status in October 2025

October 21st, 2025|Categories: Shorts & Tutorials, Homeoffice, Microsoft Office, Windows 10/11/12|Tags: , , |

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?

2010, 2025

Blocking websites on Windows using the hosts file

October 20th, 2025|Categories: Shorts & Tutorials, Homeoffice, Microsoft Office, Windows 10/11/12|Tags: , , , |

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.

2010, 2025

The “Zero Inbox” method with Outlook: How to permanently get your mailbox under control.

October 20th, 2025|Categories: Shorts & Tutorials, Data Protection, Homeoffice, Microsoft Office, Microsoft Outlook, Office 365, Windows 10/11/12|Tags: , , , |

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.

Offers 2024: Word & Excel Templates

Popular Posts:

2710, 2025

Dynamic ranges in Excel: OFFSET function

October 27th, 2025|Categories: Shorts & Tutorials, Microsoft Excel, Microsoft Office, Office 365|Tags: , |

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.

2710, 2025

Mastering the INDIRECT function in Excel

October 27th, 2025|Categories: Shorts & Tutorials, Microsoft Excel, Microsoft Office, Office 365|Tags: , |

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.

2310, 2025

From assistant to agent: Microsoft’s Copilot

October 23rd, 2025|Categories: Shorts & Tutorials, Artificial intelligence, AutoGPT, ChatGPT, Homeoffice, LLaMa, Microsoft Excel, Microsoft Office, Microsoft Outlook, Microsoft PowerPoint, Microsoft Teams, Microsoft Word, Office 365, TruthGPT, Windows 10/11/12|Tags: , , , |

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.

2110, 2025

Windows 12: Where is it? The current status in October 2025

October 21st, 2025|Categories: Shorts & Tutorials, Homeoffice, Microsoft Office, Windows 10/11/12|Tags: , , |

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?

2010, 2025

Blocking websites on Windows using the hosts file

October 20th, 2025|Categories: Shorts & Tutorials, Homeoffice, Microsoft Office, Windows 10/11/12|Tags: , , , |

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.

2010, 2025

The “Zero Inbox” method with Outlook: How to permanently get your mailbox under control.

October 20th, 2025|Categories: Shorts & Tutorials, Data Protection, Homeoffice, Microsoft Office, Microsoft Outlook, Office 365, Windows 10/11/12|Tags: , , , |

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.

Offers 2024: Word & Excel Templates

Ads

Popular Posts:

Search by category:

Autumn Specials:

Anzeige
Go to Top