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.
When working in Excel, it’s often necessary to move columns, rows or cells. You can easily move cells in Excel using a keyboard shortcut or with a click of the mouse. In the following step-by-step guide, we’ll explain how to move cell contents in Excel using drag and drop or Copy and Paste, without changing formulas, cell references or contents.
PowerPoint notes are a useful feature when giving an unscripted presentation. If you print your PowerPoint notes, you do not have to worry about the on-site technical situation. In our step-by-step guide, you will learn how to print your PowerPoint presentation notes and use the various editing options when exporting handouts.
All well-known browsers come with incognito mode which lets you ‘surf privately’ on the web. Find out what private mode means in practice and how to activate it in in Google Chrome, Mozilla Firefox, Microsoft Edge, and Apple Safari. But beware that incognito mode on its own does not guarantee anonymity online.
Do you want to combine or merge cells or columns in your Excel table, but are not sure how? This guide explains how to combine, centre, and split cells in Excel using clear and simple examples. You’ll also learn how you can use the “&” sign to combine cells.