G-Stock StudioShutterstock

## How to format dates in Google Sheets

• Online sales

In Google Sheets, there are helpful functions for formatting dates, so you don’t have to enter them manually for each row. The spreadsheet program also lets you customize the input format to suit your needs. We’ll explain how to insert dates in Google Sheets and how to sort by date as well. Keep reading to find out everything you need to know about the Google Sheets date function.

## How to make an Excel file read-only

• Online sales

Find out how to make an Excel file read-only. We’ll show you how to save an Excel file so that modifications can only be made with a password. We’ll also reveal what you need to know when opening a read-only Excel spreadsheet. In just a few simple steps, you can ensure that changes—both unintentional and unapproved—are a thing of the past!

## What are Excel functions? An overview of the best functions in Excel

• Online sales

There are many different functions in Excel, and they can be used for a wide range of tasks. With these predefined calculations, you can increase the efficiency and ease of your workflows. In this article, we provide an overview of the best Excel functions, what their syntax is and the myriad of tasks that you can carry out with them.

## How to remove read-only from Excel

• Online sales

There are various ways to disable read-only in Excel. Our dedicated article explains how you can open and edit a write-protected Excel document, how you can turn off read-only in an Excel workbook or spreadsheet and how you can continue editing an Excel document marked as final — with or without a password. Let’s get started.

Robert KneschkeShutterstock

## How to use the percentage formula in Excel

• Online sales

Want to know how to calculate percentages in Excel? With the most important formulas for calculating percentages in Excel, the process is a cinch. In this article, you’ll learn how to calculate percentages of totals and growth rates, and how to figure out proportions and totals based on percentages. We’ll also give you tips on increasing and decreasing numbers by percentages.

## How to change language settings in Word

• Online sales

How do you change the language in Microsoft Word? You can set different languages for the user interface and the spell check in Microsoft Word regardless of the language you have for your Windows operating system. This is especially useful when working with documents in other languages. In this article, you’ll learn how to change the display and spell check language in Word.

ChinnapongShutterstock

## How to track changes in Excel

• Online sales

Imagine you’re preparing an Excel spreadsheet that several colleagues will be collaborating on at the same time. You can monitor the changes made to the spreadsheet by tracking changes in Excel. This way, you’ll be able to keep an overview of who wrote or changed what. In this dedicated article, we show you how it’s done.

Perspective JetaShutterstock

## How to remove a password from an Excel file

• Online sales

Encrypted files or individual worksheets can usually be unprotected by removing the password. While removing a password from an Excel file doesn’t take long, things can quickly take a turn for the worst if you can’t remember your password. This article reveals tips and tricks on how to remove a password from an Excel workbook, as well as what works and what doesn’t.

G-Stock StudioShutterstock

## How to insert Excel into Word

• Online sales

Want to insert an Excel table into Word but aren’t sure how to go about it? The easiest way to do it is to use the copy and paste commands. But if you want to edit the data later on, it’s better to link Excel into Word. This can be done rather quickly. Find out how in this easy-to-understand guide where we explain how to insert an Excel spreadsheet into Word.

## What is the Excel “not equal to” operator and how to use it

• Online sales

Excel is the perfect tool for evaluating large sets of data in tables and precisely defining conditions. Excel’s logical operators are particularly useful for carrying out such evaluations. In this article, you’ll learn how the Excel “not equal to” sign works and how it can be used with functions like IF, OR and SUMIF. Keep reading to find out how to do “does not equal” in Excel.

# Online marketing

### The IONOS Guide to Online Marketing: tips and expertise for all

There are many options and strategies for marketing content, products, and services online. In addition to traditional outlets (like banners or videos), e-commerce also lends itself particularly well to generating customer attention: methods like search engine, affiliate, and social media marketing are all part and parcel of a good online marketing mix. In our guide on the topic, we’ve compiled important information on the basics of online marketing and have also included plenty of expert-level tips.

### Who should use our Online Marketing Guide?

From beginners to experienced professionals, this guide offers individuals of all competency levels relevant tips for successful online marketing. And online marketing basics are just as much a part of this guide as expert-level topics (‘Cloaking–an SEO blackout’ or ‘Canvas fingerprinting–web tracking without Cookies’). Readers looking to set up e-commerce platforms or become online marketers stand to gain a lot with this content. Small and midsized companies aiming to enter the online market or expand their marketing skills will also find useful resources here (e.g. ‘Creating a business plan for your online store’, ‘8 tips for successful online store marketing’, or ‘Successful social media marketing’).

### How the guide is structured

The articles are divided into four different subcategories. Under ‘Online sales’, you’ll find texts on how to construct and operate an online shop. In addition to the fundamentals of online marketing, there’s a lot of information on how to upgrade your web store located in this section. The subcategory, ‘Social media’ provides tips on how to win over customers and create campaigns within today’s conventional social media networks. Here, you can find out how to execute different strategies in varying levels of complexity. Under the keyword, ‘Social media marketing’, there are articles on search engine optimization (SEO), search engine advertising (SEA) as well as useful online marketing tips for relevant tools and techniques. The fourth and final subcategory, ‘Web analytics’, covers different approaches and tools for gathering data on visitor behavior and how to create web statistics (e.g. with Google Analytics). IONOS’s Online Marketing Guide is a one-stop shop for clear and comprehensive information on online business and online marketing.

We use cookies on our website to provide you with the best possible user experience. By continuing to use our website or services, you agree to their use. More Information.