by Oluwaseun Olatoye | Mar 23, 2022 | Format
This post is going to show you all the ways you can get the weekday name from a date in Google Sheets. The benefit of having a column of dates is that you can extract each component of a date into separate columns. If the date is in numeric format, the individual...
by Oluwaseun Olatoye | Mar 19, 2022 | Functions
This post is going to show you all the ways you can convert minutes into hours in Google Sheets. Sometimes your dataset will not contain the items in the exact format you need and you will have to do some manipulation to extract the results you want. This is the case...
by Oluwaseun Olatoye | Mar 18, 2022 | Apps Scripts
This post is going to show you how you can get the hexadecimal code from a colored cell in Google Sheets. Spreadsheets usually focus on numbers and text, but colors can also be an important part. Color helps to bring style and add context to the spreadsheet. With most...
by Lalit Salunkhe | Mar 16, 2022 | General
This post is going to show you all the ways you can use to move and rearrange the columns in your Google Sheets workbooks. Most of these methods will also work for moving any rows around as well! Google Sheets offers so many easy customizations for its users. The...
by Oluwaseun Olatoye | Mar 3, 2022 | Functions
This post will show you various ways you can find the slope of the best fit line for your data in Google Sheets. Data is vital to any successful organization. But gathering and collecting data is just part of the process. To gain knowledge, data must be processed and...