Showing Duplicates in Excel
Identifying Duplicates in Excel
  • Online sales

There are several reasons why you may want to find duplicates in Excel – to filter out errors or analyze double entries. Excel can automatically display these duplicates to you. Thanks to color highlighting, you can instantly see which entries appear more than once in your tables. And the feature is easy to use: We’ll explain how it works.

Identifying Duplicates in Excel
Joy of Missing Out
JOMO: The mindful countertrend to FOMO
  • Social media

JOMO (joy of missing out) is the antithesis of FOMO (fear of missing out). Younger people especially are discovering the joy of missing out for themselves. They’re enjoying the moment, instead of chasing after trendy events and comparing themselves to others on social media. JOMO is a response to the increasing levels of stress associated with the modern world of work and social pressures.

JOMO: The mindful countertrend to FOMO
How to wrap text in Excel
Wrapping text in Excel: How to display the contents of your Excel cells on multiple lines
  • Online sales

Excel cells often contain only a few numerical values or short text. But when you’re dealing with lengthy contents, the Microsoft application often hides a portion of the information. You can prevent this by wrapping text, which Excel allows you to do in two different ways. In this article, you’ll learn everything you need to know about this feature.

Wrapping text in Excel: How to display the contents of your Excel cells on multiple lines
Internet of Things
The internet of things: The era of networked things
  • Digital law

The internet of things (IoT) is driving digital change. Smart household appliances and self-driving cars are already available. More and more everyday devices are being connected to form a comprehensive network that will eventually penetrate all areas of life. The 5G mobile communications standard will soon be implemented, which will help IoT achieve a breakthrough in the foreseeable future. Smart...

The internet of things: The era of networked things
Freezing Excel Rows
Freezing Rows and Columns in Excel: A Guide
  • Online sales

The bigger an Excel table is, the harder it is to maintain an overview. The problem is that cells like the header bar become hidden without the use of special formatting. The following article shows you how to freeze certain Excel columns and rows so they stay visible when scrolling.

Freezing Rows and Columns in Excel: A Guide
VLOOKUP in Excel
Faster with Excel: the VLOOKUP function explained
  • Online sales

It can often be incredibly time-consuming to search for a specific entry in an Excel table by hand, which is where VLOOKUP comes into play. This practical function allows you to find the exact value for a specific search criterion. The VLOOKUP function is indispensable for managing price lists, members directories, and inventory catalogues. To ensure you can benefit from this practical function,...

Faster with Excel: the VLOOKUP function explained
What is MAC spoofing?
What is MAC spoofing?
  • Know-how

MAC spoofing is a method by which unique hardware addresses are masked using a Locally Administered Address (LAA) in the software. MAC spoofing can offer protection for your privacy when using public LAN or WLAN networks, but can also be used for illegal network activities. We explain to you here how MAC spoofing works and which settings in Windows must be accessed in order to change your MAC...

What is MAC spoofing?
COUNTIF in Excel
Practical functions in Excel: COUNTIF explained
  • Web analytics

What is COUNTIF? With Excel, Microsoft provides a helpful spreadsheet program. The application combines numerous functions – most of which many users are unaware of. It therefore makes all the more sense to learn more about it and use the program for more than just creating tables. The COUNTIF function helps you create statistics, for example. We explain clearly how to use COUNTIF correctly in...

Practical functions in Excel: COUNTIF explained
Unique Selling Proposition
Unique selling propositions – a product’s distinguishing features as the new recipe for success
  • Online sales

You should always advertise your products or services in such a way that your customers will not want to purchase them anywhere else. Whether the offer relates to a special product, a new technology, or a unique service, you must establish a unique selling proposition (USP). To truly benefit from this special feature, you must make it visible by means of marketing. However, because competition...

Unique selling propositions – a product’s distinguishing features as the new recipe for success
Parallax websites: scrolling with 3D effect
What is Parallax scrolling?
  • Web design

The internet community loves variety – not only regarding content but also regarding how websites are designed. Web designers and software developers are always striving to come up with creative ideas and surprise site visitors with new user experiences. One of these innovative design approaches is so-called parallax scrolling, which uses perceptional psychological effects to convey...

What is Parallax scrolling?