Team OfficeBeginner

How to get Last Value in a Column in Google Sheets

by

There are multiple instances when might you need to get the last column value in Google sheets.

You can scroll down to get the last value, but this is will be impractical when you have a huge dataset.

For example, there’s a list of students in descending order of marks scored. You want to know the student who has scored the least.

Let’s go over some methods to find the last value in a column. 

3 methods to get the last value in a column in Google Sheets: 

  • Using INDEX and COUNTA functions 
  • Using INDEX and MATCH functions for numerical values 
  • Using INDEX and MATCH functions for text values 

Read more

How to Make a Cover Page in Google Docs

by

If a cover page is not attractive, most people will lose interest in reading the document. An attractive cover page can draw people to your document. You don’t have to worry about using special graphics design software. With Google Docs, you can create the perfect title page.

The steps given below will show you how to design your cover page.

A simple method to create cover pages with Google Docs:

  • Remove margins and insert drawing

Read more

How to Fix ‘Bottom Margin Bigger’ Issue in Google Docs

by

Thick bottom margins can be annoying when you need precise margins for your work. Most word processing software uses the widow/orphan control feature.

In Google Docs, the feature is active by default. It makes your text look better, but you may get bigger margins.

What is a widow? 

Imagine a paragraph that begins at the end of a page and occupies one line at the top of the next page. That line on the second page is a widow. By default, Google Docs will move some lines from the first page to the second page to prevent widows. Unfortunately, this transfer leaves thicker margins on the previous page.

What is an orphan? 

An orphan occurs when the first line of a paragraph sits at the end of a page. Google Docs will move this line to the next page. A transfer like this will leave the last line empty. The empty last lines make the bottom margins appear bigger.

The widow/orphan control prevents widows and orphans. There is no way to turn this feature off in Google Docs. However, the workaround below can give you slimmer bottom margins.

2 ways to fix bigger bottom margin in Google Docs:

  • Set document margin size
  • Minimize header/footer

Read more

What are document properties in MS Word

by

For any document, Word creates certain types of metadata about the document. It stores them as document properties.

These properties are standard with fixed names. You cannot change them—these are the Document’s Title, Author name, Keywords, and Comments. Other properties store statistical data about your document. These include file size, date, and time you last printed or saved the document.

Word updates these properties automatically, and you cannot edit them.

Apart from the standard document properties, Word also has custom properties.

Read more

How to unhide rows in Google Sheets

by

You may have hidden rows in Google Sheets previously for any reason. If you want to reveal them now, you just have to unhide the rows that you have previously hidden.

4 methods of unhiding rows in Google Sheets:

  • Using the arrows
  • By selecting Unhide rows
  • By pressing Ctrl + Shift + 9
  • Unhide the rows hidden by filters.

Read more

How to sum by category in Google Sheets

by

Sometimes, we need to sum by a category in Google Sheets.

We can use SUMIF function, SUMIFS function and UNIQUE function for this. 

2 Methods to sum by category in Google Sheets 

  • Summing according to a given range using SUMIF
  • Summing according to a given range using UNIQUE and SUMIF

Read more

How to count characters in Google Sheets

by

Unlike Google Docs, Google Sheets doesn’t have an in-built word count option. To count characters in Google Sheets, you have to improvise.

The LEN function is used for counting characters in spreadsheets. This function is more powerful than the in-built word count function in Google Docs. You can specify what you want to count and also specify the conditions.

4 ways to count characters in Google Sheets

  • Count all the characters in a cell
  • Count all the characters in a column
  • Count the characters and ignore spaces
  • Count specific characters

Read more

How to hide columns in Google Sheets

by

Hiding unused columns in spreadsheets helps you focus as you work. You may have to show your spreadsheet to an audience. Hiding unused columns will also help your audience focus while you are presenting the spreadsheet.

There are two methods you can use to hide rows and columns. 

  • Using Mouse and keyboard
  • Using Keyboard shortcuts

Read more