• Skip to main content
  • Skip to primary sidebar

Nerd Excel

Excel Simplified

  • Excel
  • Google Sheets
  • Word
  • Google Docs

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

How to Sort Alphabetically in Google Sheets

Sort Alphabetically in Google Sheets

Once a spreadsheet contains numerous lines of data, it becomes difficult to find what you are looking for. It then becomes important to properly sort the data to ensure it […]

How to Sort Multiple Columns Alphabetically in Excel

Sort Multiple Columns Alphabetically in Excel

Reading thousands of lines in an Excel spreadsheet can be an annoying process, especially when the data is unorganized. Luckily, it is very easy to sort multiple columns alphabetically in […]

  • Go to page 1
  • Go to page 2
  • Go to page 3
  • Go to Next Page »

Primary Sidebar

Popular Now

  • How to Calculate Age in Google Sheets
  • How to Sort by Date in Google Sheets
  • How to Generate Random Numbers in Google Sheets
  • How to Generate Random Numbers in Excel
  • How to Unprotect Excel Sheet Without Password

About | Privacy Policy | Disclosure | Terms | Contact
© Copyright 2022 @Nerdexcel.com · All Rights Reserved