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

410, 2019

Google Maps gets incognito mode for more privacy
Google Maps gets incognito mode for more privacy

Google Maps gets incognito mode for more privacy

Michael Suhr2023-06-03T09:37:17+02:00October 4th, 2019|Categories: Shorts & Tutorials, Data Protection, Google, Uncategorized|Tags: Data Protection, Google, Short News|

Google is also putting the privacy of its users to the test for the maps service Google Maps and is introducing an incognito mode.

110, 2019

The right to be forgotten only applies within the EU
The right to be forgotten only applies within the EU

The right to be forgotten only applies within the EU

Michael Suhr2023-06-03T09:38:18+02:00October 1st, 2019|Categories: Shorts & Tutorials, Data Protection, Google, Uncategorized|Tags: Data Protection, Google, Short News|

The right to be "forgotten" by deleting data from Google's search results only applies within the borders of the EU.

1409, 2019

Verdict: Facebook fan pages may be banned
Verdict: Facebook fan pages may be banned

Verdict: Facebook fan pages may be banned

Michael Suhr2023-06-03T09:44:34+02:00September 14th, 2019|Categories: Shorts & Tutorials, Data Protection, Uncategorized|Tags: Facebook, Meta, Short News|

The Federal Administrative Court in Leibzig has given the data protection authorities the go-ahead to ban Facebook fanpages.

1309, 2019

Create Pivot Table and Pivot Chart in Excel
Create Pivot Table and Pivot Chart in Excel

Create Pivot Table and Pivot Chart in Excel

Michael Suhr2023-06-03T09:45:35+02:00September 13th, 2019|Categories: Microsoft Excel, Microsoft Office, Office 365, Shorts & Tutorials|Tags: Excel, Excel tables|

So you can easily create pivot tables with Microsoft Excel, and also sort large amounts of data without much effort.

1206, 2019

How to regulate your digital estate
How to regulate your digital estate

How to regulate your digital estate

Michael Suhr2023-06-02T19:23:37+02:00June 12th, 2019|Categories: Data Protection, Internet, Finance & Shopping, Shorts & Tutorials, Uncategorized|Tags: Data Protection, finance|

These things should be noted in your digital estate / inheritance and should make it easier for your loved ones later.

706, 2019

This is how the Name Manager works in Excel
This is how the Name Manager works in Excel

This is how the Name Manager works in Excel

Michael Suhr2025-12-07T08:06:18+01:00June 7th, 2019|Categories: Microsoft Excel, Microsoft Office, Office 365, Shorts & Tutorials|Tags: Excel, Excel tables|

Calculate instead of numbers but just by name in Microsoft Excel, and make easier with the name manager's work.

Popular Posts

410, 2019

Google Maps gets incognito mode for more privacy
Google Maps gets incognito mode for more privacy

Google Maps gets incognito mode for more privacy

Michael Suhr2023-06-03T09:37:17+02:00October 4th, 2019|Categories: Shorts & Tutorials, Data Protection, Google, Uncategorized|Tags: Data Protection, Google, Short News|

Google is also putting the privacy of its users to the test for the maps service Google Maps and is introducing an incognito mode.

110, 2019

The right to be forgotten only applies within the EU
The right to be forgotten only applies within the EU

The right to be forgotten only applies within the EU

Michael Suhr2023-06-03T09:38:18+02:00October 1st, 2019|Categories: Shorts & Tutorials, Data Protection, Google, Uncategorized|Tags: Data Protection, Google, Short News|

The right to be "forgotten" by deleting data from Google's search results only applies within the borders of the EU.

1409, 2019

Verdict: Facebook fan pages may be banned
Verdict: Facebook fan pages may be banned

Verdict: Facebook fan pages may be banned

Michael Suhr2023-06-03T09:44:34+02:00September 14th, 2019|Categories: Shorts & Tutorials, Data Protection, Uncategorized|Tags: Facebook, Meta, Short News|

The Federal Administrative Court in Leibzig has given the data protection authorities the go-ahead to ban Facebook fanpages.

1309, 2019

Create Pivot Table and Pivot Chart in Excel
Create Pivot Table and Pivot Chart in Excel

Create Pivot Table and Pivot Chart in Excel

Michael Suhr2023-06-03T09:45:35+02:00September 13th, 2019|Categories: Microsoft Excel, Microsoft Office, Office 365, Shorts & Tutorials|Tags: Excel, Excel tables|

So you can easily create pivot tables with Microsoft Excel, and also sort large amounts of data without much effort.

1206, 2019

How to regulate your digital estate
How to regulate your digital estate

How to regulate your digital estate

Michael Suhr2023-06-02T19:23:37+02:00June 12th, 2019|Categories: Data Protection, Internet, Finance & Shopping, Shorts & Tutorials, Uncategorized|Tags: Data Protection, finance|

These things should be noted in your digital estate / inheritance and should make it easier for your loved ones later.

706, 2019

This is how the Name Manager works in Excel
This is how the Name Manager works in Excel

This is how the Name Manager works in Excel

Michael Suhr2025-12-07T08:06:18+01:00June 7th, 2019|Categories: Microsoft Excel, Microsoft Office, Office 365, Shorts & Tutorials|Tags: Excel, Excel tables|

Calculate instead of numbers but just by name in Microsoft Excel, and make easier with the name manager's work.

* contained paid Promotion

Unterstützen Sie unsere Arbeit

Neueste Artikel

IT security: The deceptive appearance of digital security

Michael2023-06-04T17:32:12+02:00May 18th, 2023|

In a digitized world, IT security is an important factor. But technology alone is not enough. A holistic strategy is needed that also takes into account the human component.

Benefits and risks of AI systems in healthcare

Michael2023-06-04T17:34:15+02:00May 18th, 2023|

AI systems have found their way into many areas of healthcare in recent years and offer numerous advantages, but also risks.

ChatGPT assembles stock portfolio and wins

Michael2023-06-04T17:35:34+02:00May 16th, 2023|

ChatGPT assembled a hypothetical portfolio of 38 stocks that was quite impressive, and generated higher-than-anticipated gains. However, the time to leave your own finances to an AI seems too early.

Thousands of Chip Factories in China are shutting down

Michael2023-06-04T17:36:24+02:00May 15th, 2023|

10,000 Chinese companies involved in chip development have had to close their factories again. "Made in China" strategy seems to have failed. The reasons are mostly homemade, and thus a group in South Korea remains at the top of the chip producers worldwide.

Set up PayPal Passkey – How it works

Michael2023-06-04T09:09:50+02:00May 11th, 2023|

The PayPal Passkey makes PayPal payments even more secure. Since October 2022 only available in the USA for the time being. In the course of 2023 also in other countries.

World’s largest online retailer Alibaba with its own chatbot

Michael2023-06-04T09:20:52+02:00May 10th, 2023|

The world's No. 1 online retailer Aliba wants to launch its own chatbot with the language software: "Tongyi Qianwen". We try to shed light on what's behind it.

Meta enters the world of AI chatbots with LLaMA

Michael2023-06-04T09:22:49+02:00May 8th, 2023|

Meta founds a top-level group to work on generative AI with LLaMA (Large Language Model Meta AI). LLaMA should be better than GPT3.

Funding for Balcony Power Plants per Federal State

Michael2023-06-04T09:23:46+02:00May 7th, 2023|

Since January 1st, 2023, 19% VAT has been waived in Germany for the purchase of balcony solar systems. There is also federal funding. We have listed how much funding you can receive for each federal state.

Google-Bard chatbot integration comes to Google Pixel

Michael2023-06-04T09:24:41+02:00May 6th, 2023|

Google Bard Chatbot kommt bald auf Google Pixel Geräte. Vorerst ist es nur ein Test, aber weitere Android Smartphones könnten folgen.

Android Smartphone without tracking – Is that possible?

Michael2023-06-04T09:25:33+02:00May 5th, 2023|

Android with an active Chrome browser sends the location to Google in the background a whopping 340 times a day without users interacting with the device.

These jobs are at risk from AI systems like ChatGPT

Michael2023-06-04T09:26:25+02:00May 4th, 2023|

With the rapid development of AI systems such as ChatGPT, AutoGPT and TruthGPT, new jobs will be created, but it will also cost many jobs.

NetzDG becomes the Digital Services Act

Michael2023-06-04T09:27:13+02:00May 2nd, 2023|

The Digital Services Act (DSA) must be gradually implemented by February 17, 2024 and will replace the NetzDG, which has been in force since October 1, 2017.

Weitere Artikel