sheets

A few days ago, I was tidying up some things and among some books and notebooks I found my collection of patterned papers, a hobby I had ...

As the Provost of the Recyclers Association of Nigeria (RAN), I often found myself failing to remember members' birthdays and send person...

At least a good to have more sheet metal around, the thicker metal plates and some expanded, Checker plate and various other stacks! Ju...

I have been thinking about getting rid of my paper music sheets and using a pad to read music while I play on gigs already for a while. ...

I know you're here because you need to share your file so I'll make it short. No non-sense introductions. https://youtu.be/Ox5w6QjCYAo St...

Function Type: Statistical Description: COUNTBLANK function in Excel or Google Sheets counts cells that are blank in a given range of ...

Function Type: Statistical Description: COUNTA function in Excel or Google Sheets counts cells that contain anything in a cell or a gi...

Function Type: Statistical Description: COUNT function in Excel or Google Sheets counts how many numbers are in the list of arguments....

Function Type: Text Description: PROPER function in Excel or Google Sheets capitalizes the first letter in each word of a text value. ...

Function Type: Text Description: LOWER function in Excel or Google Sheets converts texts to lower cases. Function Structure: =LOWER (...

Function Type: Text Description: UPPER function in Excel or Google Sheets converts texts to UPPER CASE. Function Structure: =UPPER ( ...

Function Type: Date and Time Description: YEARFRAC function in Excel or Google Sheets returns the year fraction representing the numbe...

Function Type: Date and Time Description: WORKDAY function in Excel or Google Sheets returns the serial number of the date before or a...

Function Type: Date and Time Description: WEEKNUM function in Excel or Google Sheets Converts a serial number to a number representing...

Function Type: Date and Time Description: NETWORKDAYS function in Excel or Google Sheets calculates the number of whole workdays betwe...

We can use Named Ranges to make our formula/functions easier to understand/audit. I just thought of sharing it as I clean up my templates...

Function Type: Date and Time Description: YEAR function in Excel or Google Sheets converts a serial number of a date to a day of the m...

Function Type: Date and Time Description: MONTH function in Excel or Google Sheets converts a serial number of a date to a day of the ...

Function Type: Date and Time Description: DAY function in Excel or Google Sheets converts a serial number of a date to a day of the mo...

Function Type: Date and Time Description: NOW function in Excel or Google Sheets returns the serial number of today's date and time. ...

Function Type: Date and Time In most cases especially in our dashboards and summary sheets, we want to have the date today automatical...

Function Type: Text I'm sure not everyone knows what the word concatenate means so I'll start this post with a screenshot of quick Goo...

Function Type: Date and Time Description: DATEDIF function calculates the number of days, months, or years between two dates. This fun...

Do you have expertise with Excel or Google Sheets? Think you are in the top 10% of Excel users worldwide? Here you can make up to $500/w...

Function Type: Logical Description: NOT function Reverses the logic of its argument. Any FALSE argument will result in TRUE. Any TRUE ...

Function Type: Logical Description: OR function returns TRUE even if only one of its arguments are TRUE. Any TRUE argument will result...

Function Type: Logical Description: AND function returns TRUE if all of its arguments are TRUE. 1 FALSE argument will result in FALSE....

Function Type: Math and Trigonometry Description: ABS function returns the absolute (positive) value of a number. If you only want the...

Function Type: Math and Trigonometry Description: The ROUND function in Excel or Google Sheets is used to round a number to a specifie...

Function Type: Lookup and Reference Description: The INDIRECT function in Excel is used to convert a text string into a valid cell ref...