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…
Category: How-to instructions
Create a SQL Server database maintenance plan
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…
Start SQL Server Agent: Configure SQL Server 2012
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…
Function definitions, usage and examples in Excel and Google Docs
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…
Function definitions, usage and examples in Excel and Google Docs
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…
Finding data with VLOOKUP in Excel
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…
Use the Excel SUMPRODUCT function to count multiple criteria
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…
Excel WORKDAY function: Find project start and end dates
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…
Sum Columns or Rows in Google Sheets
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…
Freeze or lock columns and rows in Excel
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…