# How to Convert Date to Number in Excel (3 Examples)

This tutorial explains how to convert a date to a number in three different scenarios: 1. Convert One Date to Number 2. Convert Several Dates…

# Excel: How to Calculate Sum If Cells Not Equal to Value

You can use the following formulas to calculate the sum of values in Excel for cells that are not equal to some value: Method 1:…

# How to Calculate Ratios in Excel (With Example)

A ratio is used to compare two numbers. Ratios are useful for understanding how large one value is compared to another. For example, suppose A…

# Excel: How to Group Values in Pivot Table by Uneven Intervals

The following step-by-step example shows how to group values in a pivot table in Excel by uneven intervals. Step 1: Enter the Data First, let’s…

# Excel: How to Group Values in Pivot Table by Range

The following step-by-step example shows how to group values in a pivot table in Excel by range. Step 1: Enter the Data First, let’s enter…

# MongoDB: How to Select a Random Sample of Documents

You can use the following syntax to select a random sample of documents from a collection in MongoDB: db.myCollection.aggregate([ { \$sample: { size: 4 }…

# MongoDB: How to Use “Not Equal” in Queries

You can use the \$ne operator (which stands for “not equal”) in MongoDB to query for documents where a field is not equal to a…

# MongoDB: How to Use Greater Than & Less Than in Queries

You can use the following operators in MongoDB to perform greater than or less than queries: \$lt: Less than \$lte: Less than or equal \$gt:…

# MongoDB: How to Insert if Not Exists

You can use the following syntax to insert a document into a collection in MongoDB only if it doesn’t already exist: db.teams.update( { team :…

# MongoDB: How to Round Values to Decimal Places

You can use the \$round operator in MongoDB to round numeric values to a certain number of decimal places. This operator uses the following basic…