#excelforall

I know you're here because you need to share your file so I'll make it short. No non-sense introductions. Step 1: Create Your Google Sheet Before you can share your masterpiece, you need to create it.

Available in: Desktop version starting Excel 2007, Online Excel 365, Google Sheets Function Type: Statistical Description: COUNTIFS function in Excel or Google Sheets counts the number of cells within

Function Type: Statistical Description: COUNTBLANK function in Excel or Google Sheets counts cells that are blank in a given range of cells specified. Literally just the empty / blank cells. Even a single

Function Type: Statistical Description: COUNTA function in Excel or Google Sheets counts cells that contain anything in a cell or a given range of cells. It counts even the errors, Boolean, AlphaNumerics

Function Type: Statistical Description: COUNT function in Excel or Google Sheets counts how many numbers are in the list of arguments. In my head, Excel or GSheets is counting the numbers in the specified

Function Type: Text Description: PROPER function in Excel or Google Sheets capitalizes the first letter in each word of a text value. In my head, this is like when we write proper nouns, such as name of

Function Type: Text Description: LOWER function in Excel or Google Sheets converts texts to lower cases. Function Structure: =LOWER ( text ) Argument Breakdown: text - The text you need to convert to lower

Function Type: Text Description: UPPER function in Excel or Google Sheets converts texts to UPPER CASE. Function Structure: =UPPER ( text ) Argument Breakdown: text - The text you need to convert to upper

Function Type: Date and Time Description: YEARFRAC function in Excel or Google Sheets returns the year fraction representing the number of whole days between start_date and end_date. Function Structure:

Function Type: Date and Time Description: WORKDAY function in Excel or Google Sheets returns the serial number of the date before or after a specified number of workdays. This function is useful in formulas

Function Type: Date and Time Description: WEEKNUM function in Excel or Google Sheets Converts a serial number to a number representing where the week falls numerically with a year. This function is useful

Function Type: Date and Time Description: NETWORKDAYS function in Excel or Google Sheets calculates the number of whole workdays between two dates. This function is useful in formulas where you need to

Function Type: Date and Time Description: TIMEVALUE function in Excel or Google Sheets is used to convert a time in the form of text to a serial number. This is best used when you have separate cells /

Function Type: Date and Time Description: DATEVALUE function in Excel or Google Sheets is used to convert a date in the form of text to a serial number. This is best used when you have separate cells /

Function Type: Date and Time Description: WEEKDAY function in Excel or Google Sheets is used to convert a serial number to a day of the week. Function Structure: =WEEKDAY(serial_number,[return_type]) Arguments

Handy short-cuts to work with excel.

Function Type: Date and Time Description: TIME function in Excel or Google Sheets is used to return the serial number of a particular time. Function Structure: =TIME(hour,minute,second) Arguments hour

Function Type: Date and Time Description: SECOND function in Excel or Google Sheets is used to convert a serial number to seconds. "SECOND" returns only the seconds of the serial number, it ignores

Function Type: Date and Time Description: MINUTE function in Excel or Google Sheets is used to convert a serial number to a minute. "MINUTE" returns only the minute of the serial number, it ignores

Function Type: Date and Time Description: HOUR function in Excel or Google Sheets is used to convert a serial number to an hour. "HOUR" returns only the hour of the serial number, it ignores