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

1110, 2020

The best WhatsApp alternatives compared
The best WhatsApp alternatives compared

The best WhatsApp alternatives compared

Michael Suhr2023-06-03T11:05:09+02:00October 11th, 2020|Categories: Android / iOS, Data Protection, Product Tests, Shorts & Tutorials, Uncategorized|Tags: Android, Apple iOS, Data Protection, Facebook, Meta|

We looked at 4 alternatives to WhatsApp in terms of security and features. There are much better and safer messengers out there

609, 2020

The most important tips for online banking
The most important tips for online banking

The most important tips for online banking

Michael Suhr2023-06-03T11:08:28+02:00September 6th, 2020|Categories: Data Protection, Homeoffice, Internet, Finance & Shopping, Shorts & Tutorials, Uncategorized|Tags: Data Protection, finance, Homeoffice|

So you do not only do your banking conveniently, but also safely from home.

3008, 2020

How you recognize fake shops on the internet
How you recognize fake shops on the internet

How you recognize fake shops on the internet

Michael Suhr2023-06-03T10:21:09+02:00August 30th, 2020|Categories: Data Protection, Internet, Finance & Shopping, Shorts & Tutorials, Uncategorized|Tags: Data Protection, finance|

The scams of fraudsters are getting more sophisticated. We clarify what you should look out for online shops.

2608, 2020

Microsoft Office gets fresher with a new design
Microsoft Office gets fresher with a new design

Microsoft Office gets fresher with a new design

Michael Suhr2023-06-03T10:21:59+02:00August 26th, 2020|Categories: Shorts & Tutorials, Microsoft Excel, Microsoft Office, Microsoft Outlook, Microsoft PowerPoint, Microsoft Teams, Microsoft Word, Office 365|Tags: Microsoft, Short News|

The familiar appearance of Microsoft Office versions will soon be a thing of the past, and a sleek design gives it a fresh look.

2707, 2020

Autocompletion and Autocorrection in Word
Autocompletion and Autocorrection in Word

Autocompletion and Autocorrection in Word

Michael Suhr2025-12-07T08:05:40+01:00July 27th, 2020|Categories: Microsoft Word, Microsoft Excel, Microsoft Office, Microsoft Outlook, Office 365, Shorts & Tutorials|Tags: letters, Word|

What is not suitable, is made suitable. How to Customize Auto Completion & Auto-Correction to Your Needs

907, 2020

The absolute, relative and mixed references in Excel
The absolute, relative and mixed references in Excel

The absolute, relative and mixed references in Excel

Michael Suhr2025-12-07T08:05:44+01:00July 9th, 2020|Categories: Microsoft Excel, Microsoft Office, Office 365, Shorts & Tutorials|Tags: Excel, Excel tables|

This is how you correctly use relative and absolute references in Excel and save yourself a lot of work

Popular Posts

1110, 2020

The best WhatsApp alternatives compared
The best WhatsApp alternatives compared

The best WhatsApp alternatives compared

Michael Suhr2023-06-03T11:05:09+02:00October 11th, 2020|Categories: Android / iOS, Data Protection, Product Tests, Shorts & Tutorials, Uncategorized|Tags: Android, Apple iOS, Data Protection, Facebook, Meta|

We looked at 4 alternatives to WhatsApp in terms of security and features. There are much better and safer messengers out there

609, 2020

The most important tips for online banking
The most important tips for online banking

The most important tips for online banking

Michael Suhr2023-06-03T11:08:28+02:00September 6th, 2020|Categories: Data Protection, Homeoffice, Internet, Finance & Shopping, Shorts & Tutorials, Uncategorized|Tags: Data Protection, finance, Homeoffice|

So you do not only do your banking conveniently, but also safely from home.

3008, 2020

How you recognize fake shops on the internet
How you recognize fake shops on the internet

How you recognize fake shops on the internet

Michael Suhr2023-06-03T10:21:09+02:00August 30th, 2020|Categories: Data Protection, Internet, Finance & Shopping, Shorts & Tutorials, Uncategorized|Tags: Data Protection, finance|

The scams of fraudsters are getting more sophisticated. We clarify what you should look out for online shops.

2608, 2020

Microsoft Office gets fresher with a new design
Microsoft Office gets fresher with a new design

Microsoft Office gets fresher with a new design

Michael Suhr2023-06-03T10:21:59+02:00August 26th, 2020|Categories: Shorts & Tutorials, Microsoft Excel, Microsoft Office, Microsoft Outlook, Microsoft PowerPoint, Microsoft Teams, Microsoft Word, Office 365|Tags: Microsoft, Short News|

The familiar appearance of Microsoft Office versions will soon be a thing of the past, and a sleek design gives it a fresh look.

2707, 2020

Autocompletion and Autocorrection in Word
Autocompletion and Autocorrection in Word

Autocompletion and Autocorrection in Word

Michael Suhr2025-12-07T08:05:40+01:00July 27th, 2020|Categories: Microsoft Word, Microsoft Excel, Microsoft Office, Microsoft Outlook, Office 365, Shorts & Tutorials|Tags: letters, Word|

What is not suitable, is made suitable. How to Customize Auto Completion & Auto-Correction to Your Needs

907, 2020

The absolute, relative and mixed references in Excel
The absolute, relative and mixed references in Excel

The absolute, relative and mixed references in Excel

Michael Suhr2025-12-07T08:05:44+01:00July 9th, 2020|Categories: Microsoft Excel, Microsoft Office, Office 365, Shorts & Tutorials|Tags: Excel, Excel tables|

This is how you correctly use relative and absolute references in Excel and save yourself a lot of work

* contained paid Promotion

Unterstützen Sie unsere Arbeit

Neueste Artikel

AI-powered surfing and shopping with Bing and Edge

Michael2023-07-08T06:07:15+02:00July 7th, 2023|

Microsoft's new Bing and Edge combine search, browsing and chat into one seamless experience by working with OpenAI and the latest model GPT 4. With improved search functions, interactive chat and AI functions, surfing the web will be revolutionized.

Main keyboard shortcuts in Windows 10/11

Michael2023-07-06T17:55:18+02:00July 6th, 2023|

Entdecken Sie die wichtigsten Shortcuts in Windows 11, um Ihre Produktivität zu steigern. Von allgemeinen Befehlen bis hin zu spezifischen Fenster-Management- und System-Shortcuts, lernen Sie, wie Sie mit diesen Tastenkombinationen effizienter arbeiten können.

The digital storage city: YouTube’s storage space

Michael2023-07-06T07:25:55+02:00July 5th, 2023|

Hours of video content are uploaded to YouTube every day, resulting in a staggering amount of storage space. Learn more about the impressive amounts of data and bandwidth YouTube consumes on a daily basis.

New Twitter competitor – Facebook Threads starts

Michael2023-07-05T09:52:18+02:00July 5th, 2023|

Meta's introduction of "threads" could reshape the landscape of social media. This new app, announced for Thursday in the Apple app store, positions itself as a serious competitor for Twitter, which is currently struggling under the leadership of Elon Musk.

Twitter app ‘TweetDeck’ becomes chargeable

Michael2023-07-05T06:46:38+02:00July 5th, 2023|

Twitter's TweetDeck, a favorite among power users, is going paid. While some welcome the change, others express concerns about accessibility and the impact on smaller organizations.

Job interview – Ruined in the first 5 minutes

Michael2023-07-19T19:27:14+02:00July 4th, 2023|

Discover the 6 most common mistakes you can make in the first five minutes of an interview and learn how to avoid them. There is no second chance to make a first impression!

Free AI Image Generator Tools: Your Creative Future in AI

Michael2023-07-04T11:03:16+02:00July 3rd, 2023|

In the digital era, AI image generation is no longer science fiction. Explore free tools that make artistic creation easier while unleashing your imagination.

Encrypt USB stick – These options are available

Michael2023-07-01T08:23:42+02:00July 1st, 2023|

Protecting sensitive data is essential. Encrypting USB sticks provides an extra layer of security. Whether it's built-in software, operating system features, third-party software, or hardware encryption, there are numerous options.

How the E-Prescription works – Smartphone Requirements

Michael2023-07-01T20:48:26+02:00June 30th, 2023|

Digitization in the healthcare system is taking the next step with the e-prescription. In this article we would like to shed light on the most important information on how the e-prescription works and what patients have to consider.

The internet never forgets! – The Wayback Machine

Michael2023-06-30T06:56:21+02:00June 30th, 2023|

The Wayback Machine is like a time capsule that takes us back in time to the internet's past. It captures and preserves the collective digital memory of mankind by storing websites from all eras and making them accessible at all times.

Nvidia sell-off – Chip restrictions against China

Michael2023-06-28T18:01:23+02:00June 28th, 2023|

Nvidia stock suffered after-hours falls following reports of Chinese AI chip restrictions. These could have a significant impact on sales in the world's largest semiconductor market.

Android 14 is coming – will your smartphone be included?

Michael2023-06-27T17:32:30+02:00June 27th, 2023|

Android 14 update is coming soon! Discover the exciting new features and find out if your smartphone is ready for the upgrade. Stay up to date.

Weitere Artikel