How to add values in Google Sheets

How to Add Values in Google Sheets

There are multiple ways to add numbers in Google Sheets. This article gives you a couple of ways to do this and use functions, create lists, and other vital features to improve your Google Sheets experience. One of the reasons people work with Google Sheets is because they get to use numbers. Google Sheets helps …

Read more

How to change date format using Google Sheets

How to Change Date Format Using Google Sheets

When using Google Sheets, it is obvious that you will have to use dates. You can format these dates for your preference and convenience. It is important to note that Google Sheets stores all its dates as integer numbers, not as sequences of the day, month, or year as it was in Excel. Google also …

Read more

How to calculate percentage using Google Sheets

How to Calculate Percentage Using Google Sheets

It is important to express quantities in terms of Percentage as it helps visualize the numbers better. Common quantities like tax, bank interest rates, and discounts are expressed as percentages. The proportions, also expressed as percentages are great for making comparisons. This article explains how to calculate and display percentages in Google Sheets. It is …

Read more

How to create a pivot table in Google Sheets

How to create a Pivot table in Google Sheets

As its name suggests, a pivot table is a table that can be moved around. That is, it is pivoted. It is easier to group, divide, and isolate your data in diverse ways with pivot tables. Due to its pivot nature, the user can analyze the dataset and derive the relationship in the dataset given. …

Read more

How to count distinctive values on Google Sheets

Counting Distinctive Values on Google Sheets

When working in Google Sheets, you could want to count the number of unique occurrences of data within your set of data. The great news is that within Google Sheets, there are different ways to do this in the spreadsheet easily. There are two commonly used ways to count distinctive values in Google sheets. Using …

Read more

How to create a key in Google Sheets

How to create a key in Google Sheets

Google sheet key is a feature in Google sheet containing characters enclosed in slashes within the URL. Google sheet keys are used for various purposes. For instance, they specify either a cell or a sheet. The user can easily extract the data from one cell or sheet to another. In addition, data imports are made …

Read more

How to check edit history on Google Sheets

How to check edit history on Google sheet

In Google sheet, history refers to the older version of your sheet. Google sheet allows one to view and restore the sheet to the version that fits best. In addition, you can also view the changes made to each specific cell. Let us discuss some of the common methods of checking the history in Google …

Read more

How to add a draft watermark in Word

Tutorial on How to page number in word from page 3

A watermark is a text or image that is faded and sits across a document page, usually diagonally. The purpose could be to indicate the document’s stage, such as draft, final copy, or confidential. You can use a watermark to insert the company logo in the document to avoid issues such as copyright infringement. Creative …

Read more

How to mail merge using Google Sheets

How to mail merge using Google Sheets

Mail merge is a powerful tool to share or send personalized data to one or more recipients. This tool helps in sending many emails at a go. The user is only required to write a single message on Gmail, and the message will automatically be sent to all recipients specified in the Google sheet. Therefore, …

Read more

How to add a table of contents in Word

How to add a table of contents word

Microsoft Word offers users many features to create and customize their documents to look more presentable and readable. A table of content is one of the must-know features word offers. This feature is mainly based on the headings of your word document. The table of contents enables and helps readers to know what information is …

Read more