How to Calculate Age in Google Sheets

Calculate Age in Google Sheets

An interesting workaround allows you to calculate age in Google Sheets using a date of birth. The formula allows users to subtract the current day from the date of birth to get either the age in years, months, days, or all three. Calculate Age in Years in Google Sheets The formula in question is called … Read more

How to Sort by Date in Google Sheets

Sort by Date in Google Sheets

Just like alphabets and numbers, dates can also be sorted from earliest to latest and vice-versa. In Google Sheets this can be done with the built-in sort function, which allows users to sort a dataset. However, unlike numbers and alphabets, some date formats are unsupported, and may lead to errors when you try to sort … Read more

How to Generate Random Numbers in Google Sheets

Generate Random Numbers in Google Sheets

Looking to populate your Google Sheets spreadsheet with a bunch of randomized data? You can vastly speed up the process by making use of built-in functions. There are two different functions that allow users to quickly generate random numbers in Google Sheets. The RAND and RANDBETWEEN functions are a simple and easy way to populate … Read more

How to Generate Random Numbers in Excel

Generate Random Numbers in Excel

Instead of manually entering in numbers, you can generate random numbers in Excel to automate the process. Excel has two built-in functions, RAND and RANDBETWEEN, which populate cells with randomly generated numbers. Generate Random Numbers Within a Range in Excel The easiest way to generate random numbers within a range in Excel is by making … Read more

How to Unprotect Excel Sheet Without Password

Unprotect Excel Sheet Without Password

Excel sheets and workbooks are usually protected to prevent unwanted changes to the document. The sheet protection feature allows people to view the sheet, but not make changes to it or the structure of the document. Users can turn off sheet/workbook protection, however they will be asked to enter in the password. You may wonder … Read more

How to Type With Voice in Google Docs

Type With Voice in Google Docs

With so much high tech around us, it feels like we’re stuck in the 20th century still having to use our hands to type. However, unbeknownst to most users you can actually type with voice in Google Docs. In fact, not only can you type with text, but you can also use voice commands to … Read more

How to Make Google Docs Read to You

Make Google Docs Read to You

Sometimes when writing a speech, script, or essay you may want to consider how your words sound when read aloud. By using a Chrome extension, you can make Google Docs read to you, allowing you to pinpoint awkward pauses or phrases in your writing. In just a few steps users can make use of the … Read more

How to Sort by Multiple Columns in Google Sheets

Sort by Multiple Columns in Google Sheets

To easily analyze large spreadsheets, you can make use of sorting functions that will organize your data. For those using Google’s productivity suite, the built-in sorting function allows users to sort by multiple columns in Google Sheets. Sort by Multiple Columns in Google Sheets In the example below, we have a dataset that contains three … Read more