Category: How-to instructions

Content Word allows you to insert watermarks to display above text How to make a text watermark Watermarking an image Change the position of the watermark image Word allows you…

Database maintenance plans automate many database management tasks in Microsoft SQL Server. You can create maintenance plans with a simple wizard-based process without any knowledge of Transact-SQL. You can perform…

SQL Server Agent allows you to automate various administrative tasks. In this tutorial, we will walk through the process of using SQL Server Agent to create and schedule a task…

A function is a predefined formula in Excel and Google Sheets that is designed to perform specific calculations in the cell it resides in. Remark : . The information in…

A function is a predefined formula in Excel and Google Sheets that is designed to perform specific calculations in the cell it resides in. Remark : . The information in…

Content In large Excel spreadsheets, VLOOKUP can help you find data How the VLOOKUP function works Function Arguments and VLOOKUP Syntax How the Range_Lookup Argument Works VLOOKUP errors: #N/A and…

To count the number of times data in two or more ranges of cells matches multiple criteria, use the SUMPRODUCT function. SUMPRODUCT only counts cases where the criteria for each…

Content Find when a project starts or ends, use WORKDAY function in Excel WORKDAY Syntax and Arguments Functions Enter the workday function Troubleshooting the WORKDAY function Find when a project…

Content How to use the SUM function in Google Sheets Write a function in Google Sheets How do you write a SUM function? How to enter the SUM function in…

Sometimes it is difficult to read and understand large tables. When you scroll too far to the right or too far down, you will lose the headlines that are at…