Freezing Excel Rows

Freezing Rows and Columns in Excel: A Guide

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.

VLOOKUP in Excel

Faster with Excel: the VLOOKUP function explained

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

Unique Selling Proposition

Unique selling propositions – a product’s distinguishing features as the new recipe for success

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 the competition...

Excel: INDEX Function

Excel: INDEX – Data Search Made Easy

Analysing huge quantities of data can be a frustrating task. However, Microsoft’s spreadsheet program offers a range of functions that make preparing worksheets easier and more efficient. For instance, the INDEX function in Excel enables you to replicate specific cell content. This can be very useful particularly in combination with other formulas.

What is a podcast?

What is a podcast?

Podcasts have become one of the most popular forms of content. They are seen as being a convenient and multi-layered medium perfect for listening to on the go. It’s not only private individuals who use the format as an uncomplicated and effective platform for their ideas and content, for quite some time now podcasts have become a very powerful marketing tool. As well as answering the question of...

snackable content

Snackable content – bite-sized web content

Snackable content has become an online marketing buzzword. The term refers to content on the web that can be taken in quickly and easily. Examples of snackable content include posts and tweets, pictures or memes, and short videos. Snackable content is designed to suit the average attention span of web surfers, and is usually sensationalist or emotional, designed to pique a reader’s interest...

How to calculate time in Excel

How to calculate time in Excel quickly and easily

You can use the SUM function to quickly add up several values. But if you want to calculate hours in Excel, you first have to adjust the format of the cells. The format has to be correct, otherwise you’ll encounter problems when you add up more than 24 hours. In that case, your total could be missing an entire day. We’ll teach you how to add hours in Excel and avoid common mistakes.

OTT

OTT Means the Next Step Forward in Television

The emergence of over-the-top content (OTT) has long-term implications for the future of television. As a direct alternative to the likewise internet-based IPTV, OTT is independent of internet providers. OTT doesn’t require its own infrastructure and enables users to freely choose when they use which digital content. Video on-demand, live streaming and Internet cable television with OTT content...

Word Hyphenation

Activate and adjust hyphenation in Word

Hyphenation in Word is a handy tool often used to create a more legible document. This feature avoids excessive line breaks and large spaces that sometimes occur in Word documents. We’ll show you how to activate and customise automatic hyphenation in Word.

Dynamic pricing

Dynamic pricing: what is it exactly?

Dynamic pricing allows prices for products and services to be quickly adjusted at any time, and enables providers to flexibly respond to factors like supply and demand – and to actively influence them in order to increase revenue. Major online retailers like Amazon also use dynamic pricing, sometimes altering their prices several times a day. What is dynamic pricing exactly and is it possible to...


Wait! We’ve got something for you!
Get your .co.uk domain for just £1/1st year.

Enter the web address of your choice in the search bar to check its availability.
12 months for £1
then £10/year