Login
Discover
Waves
Communities
Login
Signup
@excelsheets
51
Followers
13
Following
10
Follow
Email digest
Resource Credits
Available
Used
Created
2022-10-21 00:23
RSS Feed
Subscribe
Blog
Blog
Posts
Comments
Communities
Wallet
excelsheets
excel
4y
Published via Ecency
Excel and GSheet Functions Compilation
In Excel and GSheets, function is a pre-defined formula that makes calculations easier. We'll just have to input specific values in specific order known as arguments. Here is a compiled list of all functions
$ 0.128
9
1
2
excelsheets
mancave
3y
How to Share your Google Sheets (Step by Step Guide)
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.
$ 0.135
8
excelsheets
leofinance
3y
Published via Ecency
WEEKDAY function
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
excelsheets
leofinance
3y
Published via Ecency
TIME function
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
excelsheets
leofinance
3y
Published via Ecency
SECOND function
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
excelsheets
leofinance
3y
Published via Ecency
MINUTE function
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
excelsheets
leofinance
3y
Published via Ecency
HOUR function
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
excelsheets
leofinance
3y
Published via Ecency
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
excelsheets
leofinance
3y
Published via Ecency
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
excelsheets
leofinance
3y
Published via Ecency
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
3y
Published via Ecency
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
revisesociology
LeoFinance
3y
excelsheets reblogged
Co-working spaces are a great deal ATM!
I currently pay £180 a month for a hot desk at my new co working space - that's 24/7 access, and if I turn up before 8.45 I'm practically guaranteed to get one of the nicer desks - and there's always something
finguru
The Mindful AI
3y
excelsheets reblogged
Read A Book In 10 Mins With Chat GPT!
Personally, I hate reading books. They bore me to death. I feel that most of them run around in circles to prove one single point and that deviates me from the point itself. Moreover, I have a busy schedule
cashheaven
leofinance
4y
excelsheets reblogged
Back to Basics: Utilizing crypto as Digital Payment (accepting HBD as payment)
let's accept HBD as payment for our business' products and services
excelsheets
excel
4y
Published via Ecency
VLOOKUP Function
Function Type: Lookup and Reference Description: VLOOKUP is one of the most popular functions in Excel. It is used to lookup a data and retrieve the corresponding data from a specific column. You may either
excelsheets
excel
4y
Published via Ecency
IF Function
Function Type: Logical Description: IF function specifies a logical test to perform allowing us to return one of two results. Logical test results in a TRUE or FALSE. Logical tests utilize Logical Operators.
excelsheets
excel
4y
Published via Ecency
PRODUCT function
Another frequently used function in excel and gsheets is the PRODUCT function. It is the counterpart of the mathematical formula of multiplication. Function Type: Math and Trigonometry Description: Multiplies
excelsheets
excel
4y
Published via Ecency
SUM function
The easiest and most frequently used function in excel and gsheets is the SUM function. It is also the best way to introduce us the functions. SUM function is the counterpart of the Mathematical Formula
excelsheets
excel
4y
Published via Ecency
Excel Range
A range is a collection of two or more cells. It is usually adjacent, but they don't necessarily have to be next to each other to be a range. Contiguous range - cells are adjacent Non-contiguous range
excelsheets
excel
4y
Published via Ecency
Excel Cells
In Microsoft Excel, a cell is a rectangular box that occurs at the intersection of a vertical column and a horizontal row in a worksheet. Thus, it is defined by a combination of column and row e.g., A1
Older →
