Login
Discover
Waves
Communities
Login
Signup
Topics
#excelforall
Global
Trending
Hot
New
Top
#excelforall
New
Top communities
Create your community
latest #excelforall created topics - older | Ecency
excelsheets
leofinance
2023-05-20 14:00
EOMONTH function
Function Type: Date and Time Description: EOMONTH function in Excel or Google Sheets is used to return the serial number of the last day of the month before or after a specified number of months. Function
$ 0.115
29
excelsheets
leofinance
2023-05-19 07:40
How to do Dynamic Dropdown without blanks in Excel step by step guide
As I am revising my excel template for Retail Inventory, I realized there might be some people out there needing help or guide on how to use a dynamic dropdown, but do not want to include the blanks. Sample
$ 0.127
30
excelsheets
leofinance
2023-05-16 09:20
EDATE function
Function Type: Date and Time Description: EDATE function in Excel or Google Sheets is used to return the serial number of the date that is the indicated number of months before or after the start date.
excelsheets
leofinance
2023-05-16 03:32
DAYS360 function
Function Type: Date and Time Description: DAYS360 function in Excel or Google Sheets is used to compute the number of days between 2 dates on a 360 days per year scale. This accounts for 12 months with
excelsheets
LeoFinance
2023-05-06 00:32
DAYS function
Function Type: Date and Time Description: DAYS function in Excel or Google Sheets is used to compute the number of days between 2 dates. This is equivalent to subtracting an End Date and a Start Date.
excelsheets
LeoFinance
2023-05-01 19:16
Tips & Tricks Tuesdays week 1
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
excelsheets
LeoFinance
2023-03-12 06:17
YEAR function
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
excelsheets
LeoFinance
2023-03-10 19:52
MONTH functions
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
excelsheets
LeoFinance
2023-03-09 16:35
DAY function
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
excelsheets
LeoFinance
2023-02-19 12:36
NOW function
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,
exceltemplate
LeoFinance
2023-02-18 12:55
Debt Snowball Chart Excel Template
Debt Snowball is a payoff method used to be free from debts. Paying your debt more than the minimum amount required. Like a snowball, it starts paying off debts from the smallest amount to the highest.
excelsheets
LeoFinance
2023-02-17 14:51
TODAY function
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
excelsheets
LeoFinance
2023-02-14 12:38
CONCATENATE function
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
excelsheets
LeoFinance
2023-02-04 02:47
DATEDIF Function
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
excelsheets
LeoFinance
2023-01-22 15:26
Work as an Excel Expert at GotIt's ExcelChat
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
excelsheets
LeoFinance
2023-01-18 10:35
NOT function
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.
excelsheets
LeoFinance
2023-01-17 09:34
OR function
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
excelsheets
LeoFinance
2023-01-16 06:08
AND 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
excelsheets
LeoFinance
2023-01-15 10:09
ABS function
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
excelsheets
LeoFinance
2023-01-14 04:31
ROUND function
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
← Latest
Older →
