office, karriere und technik blog

office, karriere und technik blog

Word and Excel practice files – sample filesMichael2023-07-09T08:28:44+02:00

Word and Excel practice files – Sample files

On this page we have provided some practice and example files to help you improve your understanding of specific procedures for different use cases in Excel. These files are of course free.

Word and Excel practice files – Sample files

On this page we have provided some practice and example files to help you improve your understanding of specific procedures for different use cases in Excel. These files are of course free.

Custom formatting

Date, times, working days

Goal Seek, Scenario Manager

Basic arithmetic, partial result

Index function

Vlookup, Wlookup

Nested Functions

IF THEN, IF AND, IF OR…

Types of Cell Reference

Conditional formatting

Custom formatting

Date, times, working days

Goal Seek, Scenario Manager

Basic arithmetic, partial result

Index function

Vlookup, Wlookup

Nested Functions

IF THEN, IF AND, IF OR…

Types of Cell Reference

Conditional formatting

Popular Posts

404, 2023

Hide folders in Windows – Protect folders with password
Hide folders in Windows – Protect folders with password

Hide folders in Windows – Protect folders with password

Michael2023-06-04T08:57:37+02:00April 4th, 2023|Categories: Shorts & Tutorials, Data Protection, Microsoft Office, Windows 10/11/12|Tags: Data Protection, Windows|

Cyber security is also becoming increasingly important in the home. Encrypt files | Hiding folders | Password protection of folders in Windows.

2703, 2023

Clean up Excel spreadsheets
Clean up Excel spreadsheets

Clean up Excel spreadsheets

Michael2023-06-04T09:05:39+02:00March 27th, 2023|Categories: Shorts & Tutorials, Microsoft Excel, Microsoft Office, Uncategorized|Tags: Excel, Excel tables|

It is very easy to use Excel tables created without a system and still get usable data from them with a few tricks.

502, 2023

Insert and edit header and footer in Excel
Insert and edit header and footer in Excel

Insert and edit header and footer in Excel

Michael2023-06-03T16:46:56+02:00February 5th, 2023|Categories: Shorts & Tutorials, Microsoft Excel, Microsoft Office, Office 365|Tags: Excel, Excel Calendar, Excel tables|

Inserting a header and footer in Excel is far from user-friendly. We show ways and workarounds how you can do it anyway.

1611, 2022

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

Concatenate text and date in Excel – Tutorial

Michael2023-06-03T16:47:55+02:00November 16th, 2022|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.

2709, 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

Michael2023-06-03T16:49:44+02:00September 27th, 2022|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.

1907, 2022

Encrypt emails in Outlook – How it’s done
Encrypt emails in Outlook – How it’s done

Encrypt emails in Outlook – How it’s done

Michael2023-06-03T16:52:48+02:00July 19th, 2022|Categories: Microsoft Outlook, Data Protection, Homeoffice, Microsoft Office, Office 365, Shorts & Tutorials, Uncategorized|Tags: Data Protection, Homeoffice, Outlook|

Standard e-mails are like postcards that everyone can theoretically read. But there are solutions for more security.

Popular Posts

404, 2023

Hide folders in Windows – Protect folders with password
Hide folders in Windows – Protect folders with password

Hide folders in Windows – Protect folders with password

Michael2023-06-04T08:57:37+02:00April 4th, 2023|Categories: Shorts & Tutorials, Data Protection, Microsoft Office, Windows 10/11/12|Tags: Data Protection, Windows|

Cyber security is also becoming increasingly important in the home. Encrypt files | Hiding folders | Password protection of folders in Windows.

2703, 2023

Clean up Excel spreadsheets
Clean up Excel spreadsheets

Clean up Excel spreadsheets

Michael2023-06-04T09:05:39+02:00March 27th, 2023|Categories: Shorts & Tutorials, Microsoft Excel, Microsoft Office, Uncategorized|Tags: Excel, Excel tables|

It is very easy to use Excel tables created without a system and still get usable data from them with a few tricks.

502, 2023

Insert and edit header and footer in Excel
Insert and edit header and footer in Excel

Insert and edit header and footer in Excel

Michael2023-06-03T16:46:56+02:00February 5th, 2023|Categories: Shorts & Tutorials, Microsoft Excel, Microsoft Office, Office 365|Tags: Excel, Excel Calendar, Excel tables|

Inserting a header and footer in Excel is far from user-friendly. We show ways and workarounds how you can do it anyway.

1611, 2022

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

Concatenate text and date in Excel – Tutorial

Michael2023-06-03T16:47:55+02:00November 16th, 2022|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.

2709, 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

Michael2023-06-03T16:49:44+02:00September 27th, 2022|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.

1907, 2022

Encrypt emails in Outlook – How it’s done
Encrypt emails in Outlook – How it’s done

Encrypt emails in Outlook – How it’s done

Michael2023-06-03T16:52:48+02:00July 19th, 2022|Categories: Microsoft Outlook, Data Protection, Homeoffice, Microsoft Office, Office 365, Shorts & Tutorials, Uncategorized|Tags: Data Protection, Homeoffice, Outlook|

Standard e-mails are like postcards that everyone can theoretically read. But there are solutions for more security.

* contained paid Promotion

Unterstützen Sie unsere Arbeit

Neueste Artikel

Safe at Home: The Ultimate Guide to Your PC and Your Wi-Fi

Michael2025-11-07T17:56:24+01:00October 14th, 2025|

Is your home Wi-Fi really secure? 🏠 From router passwords to phishing protection – our ultimate security guide will make life difficult for hackers. Secure your PC and home network now with our simple and easy-to-understand tips! #Cybersecurity #HomeNetwork

Emails the world doesn’t need: The 7 deadly sins of the digital inbox

Michael2025-11-07T18:01:25+01:00October 14th, 2025|

Is the "Answer Everyone" doomsayer striking again? 😱 We're exposing the 7 deadly sins of the digital inbox – from blank subject lines to the CC assassin. How many of these sins do you (or your colleagues) recognize yourself in? Take the quiz! #Email #OfficeHumor

The secret language of the office: The ultimate phrase translator

Michael2025-11-07T18:08:20+01:00October 13th, 2025|

Your colleague wants to "take the topic with them" and you nod, even though you don't understand a thing? 😉 No more of that! Our ultimate translator for office jargon is here. Find out what's really meant. Laughter and "aha!" moments guaranteed! #OfficeSlang #OfficeHumor

Ordnerrücken in Microsoft Word erstellen – Schritt für Schritt-Anleitung

Michael2025-11-04T11:14:23+01:00September 22nd, 2025|

Diese Anleitung zeigt Ihnen, wie Sie in wenigen Schritten einen Ordnerrücken DIN A4 in Microsoft Word erstellen. Perfekt für die Organisation im Büro oder Zuhause, hilft Ihnen dieser Ratgeber, Ihre Dokumente stilvoll und übersichtlich zu ordnen.

Identitätsdiebstahl im Internet: Funktionsweise und Schutzmaßnahmen

Michael2025-11-04T11:14:23+01:00August 11th, 2025|

Identitätsdiebstahl im Internet ist ein wachsendes Problem. Erfahren Sie, wie Phishing, Malware und Social Engineering funktionieren und wie Sie sich mit starken Passwörtern, Zwei-Faktor-Authentifizierung und Sicherheitssoftware effektiv schützen können. Bleiben Sie wachsam und informiert!

UEFI Malware: Functionality and Protection Measures

Michael2025-11-07T18:14:56+01:00June 23rd, 2025|

UEFI malware infects a computer's firmware, making it difficult to detect and remove. Protect your system with regular firmware updates, enabling Secure Boot and TPM, and using specialized security software. Learn more about attack vectors and effective protection measures.

How smart home devices spy on us

Michael2025-11-07T18:32:32+01:00June 1st, 2025|

Smart home devices make everyday life easier, but they also collect and transmit sensitive data. This article examines the risks of surveillance through smart home technologies and provides tips on how to protect your privacy.

How Google detects AI-powered ad abuse

Michael2024-03-31T08:51:31+02:00March 30th, 2024|

In an unprecedented AI race, Google is unveiling its latest technologies to detect AI ad abuse. This article highlights how AI-powered tools are used to combat fraudulent activities and the challenges involved.

Alexa Plus – paid model with AI support comes

Michael2024-02-18T06:20:40+01:00February 18th, 2024|

Amazon launches “Alexa Plus,” an AI-based version of its voice assistant. In addition to the classic Alexa, Alexa Plus is presented as a premium offering that is being revised to improve response quality. The launch is scheduled for June 30, 2024, with uncertain costs for users.

Integrate and use ChatGPT in Excel – is that possible?

Michael2024-02-02T06:08:09+01:00February 1st, 2024|

ChatGPT is more than just a simple chatbot. Learn how it can revolutionize how you work with Excel by translating formulas, creating VBA macros, and even promising future integration with Office.

Get more accurate search results on Google

Michael Suhr2024-01-24T07:57:29+01:00January 22nd, 2024|

With a few tricks you can get more targeted search results on Google and you don't have to scroll through the result lists. Just exclude unpopular sites and much more.

A turning point in EU policy on regulating AI

Michael2024-01-25T06:51:27+01:00January 5th, 2024|

The EU's AI Act represents a historic step forward in the regulation of artificial intelligence. With strict guidelines for high-risk applications, it paves the way for safe and responsible AI innovation on a global scale.

Weitere Artikel