Excel functions generally calculate all values in their range – whether the cells are hidden or not. This is practical, as it does not change the final result. However, sometimes that is exactly what you want. If so, SUBTOTAL can help in Excel: Multiple calculations react to any existing filters and adapt the result accordingly.
Converting a project in PowerPoint to Word is easy. This allows you to quickly create, print, and distribute handouts for your presentation. Find out here which options you have when exporting the file and what you should keep in mind when converting files with the ending .ppt to Word.
Unable to open an Excel file? There can be many reasons for this issue. In most cases, you can simply use Excel’s built-in repair functions to recover a corrupted spreadsheet. Different troubleshooting options are available depending on whether you can’t open one particular spreadsheet or all Excel files. We’ll show you how you can easily resolve this issue yourself.
You often need to send the same content to multiple people, whether it’s a party invitation or a business invoice. If you don’t want to change the addresses manually every time, you can use the mail merge feature in Word. You simply insert placeholders instead of addresses into your document and let the program do the rest – easy!
Hyperlinks are an important element of electronic documents. Microsoft Office also enables you to insert hyperlinks into Word documents, Excel sheets, Outlook messages or PowerPoint presentations for websites or other files on your computer. Learn how this works in our step-by-step guide.
The FIND function in EXCEL is an effective tool. It allows you to find specific strings within a cell, regardless of how much information it contains. FIND is especially useful in combination with other functions. What tasks can the function help you with? And what is the syntactical structure?
Recovering Excel files can be time-consuming and nerve-wracking. Windows and the Excel application offer a wide range of options for recovering unsaved or overwritten Excel spreadsheets if the program crashes or you accidentally close it without saving. In this tutorial, we’ll present helpful solutions and practical tips.
Excel is not working: As a Microsoft Office user, you’ve no doubt experienced this issue before. Excel freezes and suddenly stops responding for a number of reasons. These can include problematic add-ins or other issues that are not caused by Excel itself, such as printer settings or issues with antivirus software. We’ll show you how you can easily fix this problem yourself.
Google Docs is one of the most widely used collaborative tools for word processing. The program offers a number of practical shortcuts that allow you to create and edit documents more efficiently. We’ll show you the most important Google Docs shortcuts and how to view a list of all keyboard shortcuts directly in the Google tool with just a few clicks.
Crawlers rove the web like digital spiders looking for web content, collecting data, and storing it in databases. They have become an integral part of the internet. So, how do web crawlers work and what kinds are there? Here, you will find the answers to these questions and learn how crawlers can be useful for optimising your 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 mid sized 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 optimisation (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.