Office, Karriere und Technik Blog

Office, Karriere und Technik Blog

Word and Excel practice files – sample files2023-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

Search for:

Search for:

Popular Posts

111, 2025

Put an end to password chaos: Why a password manager is important

November 1st, 2025|Categories: Shorts & Tutorials, Data Protection, Google, Homeoffice, Software|Tags: , , , |

Passwords are constantly being stolen through data leaks. A password manager is your digital vault. It creates and stores strong, unique passwords for every service. This effectively protects you against identity theft through "credential stuffing".

3110, 2025

More than just a password: Why 2-factor authentication is mandatory today

October 31st, 2025|Categories: Shorts & Tutorials, Data Protection, Internet, Finance & Shopping|Tags: |

Why is two-factor authentication (2FA) mandatory today? Because passwords are constantly being stolen through data leaks and phishing. 2FA is the second, crucial barrier (e.g., via an app) that stops attackers – even if they know your password. Protect yourself now!

3110, 2025

Beware of phishing: Your PayPal account has been restricted.

October 31st, 2025|Categories: Shorts & Tutorials, Data Protection, Internet, Finance & Shopping|Tags: , |

Beware of the email "Your PayPal account has been restricted." Criminals are using this phishing scam to steal your login information and money. They pressure you into clicking on fake links. We'll show you how to recognize the scam immediately and what to do.

2910, 2025

Excel Tutorial: How to quickly and safely remove duplicates

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

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.

2810, 2025

Who owns the future? AI training and the global battle for copyright.

October 28th, 2025|Categories: Shorts & Tutorials, Artificial intelligence, AutoGPT, ChatGPT, Data Protection, Internet, Finance & Shopping, LLaMa, TruthGPT|Tags: , , |

AI companies are training their models with billions of copyrighted works from the internet – often without permission. Is this transformative "fair use" or theft? Authors and artists are complaining because AI is now directly competing with them and copying their styles.

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.

Offers 2024: Word & Excel Templates

Anzeige

Popular Posts

111, 2025

Put an end to password chaos: Why a password manager is important

November 1st, 2025|Categories: Shorts & Tutorials, Data Protection, Google, Homeoffice, Software|Tags: , , , |

Passwords are constantly being stolen through data leaks. A password manager is your digital vault. It creates and stores strong, unique passwords for every service. This effectively protects you against identity theft through "credential stuffing".

3110, 2025

More than just a password: Why 2-factor authentication is mandatory today

October 31st, 2025|Categories: Shorts & Tutorials, Data Protection, Internet, Finance & Shopping|Tags: |

Why is two-factor authentication (2FA) mandatory today? Because passwords are constantly being stolen through data leaks and phishing. 2FA is the second, crucial barrier (e.g., via an app) that stops attackers – even if they know your password. Protect yourself now!

3110, 2025

Beware of phishing: Your PayPal account has been restricted.

October 31st, 2025|Categories: Shorts & Tutorials, Data Protection, Internet, Finance & Shopping|Tags: , |

Beware of the email "Your PayPal account has been restricted." Criminals are using this phishing scam to steal your login information and money. They pressure you into clicking on fake links. We'll show you how to recognize the scam immediately and what to do.

2910, 2025

Excel Tutorial: How to quickly and safely remove duplicates

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

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.

2810, 2025

Who owns the future? AI training and the global battle for copyright.

October 28th, 2025|Categories: Shorts & Tutorials, Artificial intelligence, AutoGPT, ChatGPT, Data Protection, Internet, Finance & Shopping, LLaMa, TruthGPT|Tags: , , |

AI companies are training their models with billions of copyrighted works from the internet – often without permission. Is this transformative "fair use" or theft? Authors and artists are complaining because AI is now directly competing with them and copying their styles.

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.

Offers 2024: Word & Excel Templates

Anzeige
* contained paid Promotion
Ads

Popular Posts:

Search by category:

Autumn Specials:

Anzeige
Go to Top