How to analyze trends with TREND function in WPS Office Excel

In this article, you will know how to analyze trends with TREND function in WPS Office Excel with simple steps as following: · Know about the TREND function in WPS Spreadsheeto Principle of the TREND functionThe TREND function predicts the linear increasing amount based on the current data (y=mx+b).o Syntax of the TREND functionTREND([known_y's], [known_x's], [new_x's], [logical values]) o Explanation of the TREND functionKnown_y's (required): the set of y-values you al....

The WEEKDAY Function in EXCEL

· Description:Weekday Function can return a number from 1 to 7 identifying the day of the week of a date. In today’s tutorial, we will also learn how to combine WEEKDAY with nested IF&OR function. · Syntax:(Serial_number, Return_type) · Arguments:Serial_number: The number that represents a date.Return_type: You can enter a number here: 1: Returns a number from 1 to 7, meaning start from Sunday and end at Saturday. It’s the default if omitted.2: Returns a number from 1 to 7, meaning st....

DATEDIF function in EXCEL

· Description:Except for DAYS360 function(hyperlink), there is another more powerful function to calculate dates that are not in the same year. The DATEDIF function is mainly used to count the number of days, months or years between two dates.· Syntax:DATEDIF(start_date, end_date, comparison unit)· Arguments:Start_date: A serial date number that represents the start date.End_date: A serial date number that represents the end date.Comparison unit: The type of result you want to return.I....

The MINUTE Function in Excel

To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.· Description:MINUTE function returns the minute as a number from 0 to 59.· Syntax:MINUTE(Serial_number)· Arguments:Serial_number: A number in the date-time code used by WPS spreadsheets, or text in time format.· Example:Suppose we have the starting time (8 AM) and end time of different products on sell and we want to calculate how long it took for each item to be sold out.1. Select....

The DAYS360 function in Excel

· Description:DAYS360 returns the number of days between two dates based on a 360-day (30 days a month, 12 months a year), which can be used in some accounting calculations.· Syntax:DAYS360(start_date, end_date, method)· Arguments:Start_date and end_date are the two dates between which you want to know the number of days.Method is a logical value specifying the calculation method.FALSE or omitted: U.S.(NASD) method. If the start_date is the last day of a month, it is seen as the 30th ....

The HOUR function in Excel

· Description:HOUR function returns the hour as number from 0 (12:00 AM) to 23 (11:00 P.M).· Syntax:HOUR(Serial_number)· Arguments:Serial_number: A number in the date -time code used by WPS spreadsheets, or text in time format.· Example:Suppose we have the employees' clock-in time and want to return their entry hour. What can we do with the help of the HOUR function?1. Open your table with WPS Spreadsheets.2. Select cell C3 where we want to calculate the entry hour of Mike. We ....