If you regularly use spreadsheet programs to process large datasets, you will welcome anything that helps. This is where drop-down lists in Excel come in. These allow you to conveniently add content with just one click so you don’t have to type the same thing again and again. We show you how to insert a drop-down in Excel.
In recent years, many online shops have received warnings due to not properly adhering to website legalities. Given the growing number of online businesses, it’s not surprising to see an increase in companies that specialise in identifying legal violations and then fining the operator. Therefore, it’s all the more important to understand the legal basics of your web shop to ensure you’re on the...
In Excel, it can be useful to count the number of characters in each cell if the big picture gets lost in large amounts of data. To quickly and easily get an overview of the number of characters, you can use the Excel LEN function. In our step-by-step instructions, you will learn how to use this function to count characters in Excel.
Creating a PowerPoint presentation usually comes with lots of hard work. That’s why it’s all the more frustrating when the presentation you’ve been working on wasn’t saved properly. But how do you recover an unsaved PowerPoint? There are various ways to save your presentation in just a few clicks. We’ll show you how to recover a lost or deleted PowerPoint file.
Spreadsheet processing is used to easily calculate numbers and values using the SUM function in Excel. But if you want to count only some of the values in a table, you should use the COUNTIF function. The function counts values across a specified cell range according to one or multiple criteria. In this article, we’ll show you how COUNTIF works in Google Sheets.
Microsoft’s favourite spreadsheet software offers a plethora of useful features and tools. Among the most important commands are “Find” and “Replace.” We’ll show you how they work step-by-step. In addition, this article offers tips and tricks to search for unknown values using placeholders.
In this guide, you’ll learn how to turn spell check on and off in Word. If you want to check your spelling in Word, you can set the application to automatically display misspelled words and grammatical errors. Word can also suggest corrections, which you can accept or ignore. You can show or hide these highlighted errors at any time.
Moving columns and rows in your Excel spreadsheet is effortless when you use the drag-and-drop function or keyboard shortcuts. In this guide, we’ll show you how to move columns or rows in Excel or cut and paste them into a different location. That way, you can transfer values in Excel without worrying about formula errors or formatting problems.
Has spell check stopped working in Microsoft Word? If so, it’s usually either turned off or the text is formatted in the wrong language. Usually, all you have to do is select the correct language so that only actual spelling errors are marked with wavy red lines. Incorrectly formatted styles can also cause the spell check to stop working.
Word and PowerPoint both belong to the Microsoft Office package. There is the possibility to insert a Word document into PowerPoint. To do this, the presentation software offers two options. We’ll explain the benefits of both, and how to insert a Word document into PowerPoint in a few simple steps.