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. Here's a sample for a Revenue - Cost = Profit: Formula used in

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 month. It returns an integer from 1990 to future years. You can use

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 month. It returns an integer from 1-12 as we see in calendars. You

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 month. It returns an integer from 1-31 as we see in calendars. You can

Function Type: Date and Time Description: NOW function in Excel or Google Sheets returns the serial number of today's date and time. Like TODAY function, NOW function is mostly used in other functions,

Function Type: Date and Time In most cases especially in our dashboards and summary sheets, we want to have the date today automatically. Description: TODAY function in Excel or Google Sheets returns the

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 Google Search. Description: CONCATENATE function in Excel to concatenate

Function Type: Date and Time Description: DATEDIF function calculates the number of days, months, or years between two dates. This function is useful in formulas where you need to calculate an age. In

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/week with your knowledge on Excel or Google Sheets. $500/week may

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

Function Type: Logical Description: OR function returns TRUE even if only one of its arguments are TRUE. Any TRUE argument will result in TRUE. Like AND function, this is most commonly used with IF function

Function Type: Logical Description: AND function returns TRUE if all of its arguments are TRUE. 1 FALSE argument will result in FALSE. This is most commonly used with IF function which also needs logical

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

Function Type: Math and Trigonometry Description: The ROUND function in Excel or Google Sheets is used to round a number to a specified number of digits (decimal places). It is useful and frequently used

Function Type: Lookup and Reference Description: The INDIRECT function in Excel is used to convert a text string into a valid cell reference. It can be used to dynamically reference a cell or range of

Function Type: Lookup and Reference Description: The COLUMN function in Excel or Google Sheets returns the column number of a reference. Although we see alphabet being utilized as column indicators, this

Function Type: Lookup and Reference Description: The ROW function in Excel or Google Sheets returns the row number of a reference. It would return a whole number. It is useful and frequently used combined

Function Type: Date and Time Description: The DATE function in Excel allows you to build a date from individual year, month, and day values. It would Return the value or serial number of a particular date.

So you are a small business owner, say a retail shop. You've got the sales going and now you want to track how your business is doing... Or you probably have 1 or 2 employees. So now you want to track