엑셀 함수 정리Online and offline job fairs providing job opportunities for Gyeonggi residents
Popular searches
Popular tags
#Excel #Function #Excel function
hello.
Next to the youth, it is the Youth Foundation.
One of the most frequently used computer programs is
I think it might be ‘Excel’.
Excel creates documents containing numbers and data.
When writing data
Because it can be visually emphasized
If you are an office worker, you will especially use it more often.
It’s a program.
Excel that I use every day
If you learn frequently used functions
Make Excel more useful
Document work time can be shortened.
‘Excel’ is essential for office workers and students
Today, the most frequently used Excel work
We have summarized Excel functions.
– SUM (range): Adds values. (=Can also be used as A+B)
– AVERAGE (range): Calculate the average of the values.
– PRODUCT (range): Multiply the values. (=Can also be used as A*B)
– MAX (range): Outputs the maximum value within the range.
– MIN (range): Outputs the minimum value within the range.
– IF(A,B,D): Outputs C or D value depending on whether condition (A) is satisfied.
– IFS(A1,B2,A2,B2..): Outputs B1, B2… values when the conditions (A1, A2…) are met.
– SUMIF(A,B,C): Outputs the sum of the corresponding C values when the condition (B) in the range A is satisfied.
※ The difference between IF and IFS is the ‘number of conditions.’ While ‘IF’ is true/false, ‘IFS’ can provide values according to the number of various conditions.
– TODAY(): Prints today’s date.
– YEAR(A): Retrieves only the year from the date A.
– DATE(A,B,C): Retrieves year (A), month (B), and day (C) values.
※ The time function is output continuously changing depending on time.
– COUNT(A): Counts the number of cells with numeric values within the range (A).
– COUNTA(A): Counts the number of cells with any value within the range (A).
– COUNTIF(A,B): Compares the values in the range (A) with B and counts the number of matches.
※ What COUNT and COUNTA have in common is that they count the number of cells with values in a range. The difference is that COUNT is limited to numbers, but COUNTA counts all.
– LEFT(A,B): Displays B (number) from the left of the cell A values.
– RIGHT(A,B): Displays B (number) from the right of cell A values.
– MIC(A,B,D): Starting from the Bth cell of A, display C (number).
– LEN(A): Displays the number of letters in A.
※ Spacing is also included in the number of characters.
Frequently used in my work so far
I have summarized Excel functions.
do more work
‘Function’ that allows you to do it proficiently
It can be used in quite a few situations
We found out together today
Learn the contents of Excel functions
We hope to increase your work efficiency.
Then next week too
Useful information for young people
I’ll be back!
By the youth, Youth Foundation
Original source: Youth Foundation blog
before
next
You can participate after logging in.
Would you like to log in?
Gyeonggi Job Foundation Western Business Headquarters, 3rd floor, 25 Buheung-ro 424beon-gil, Bucheon-si, Gyeonggi-do
Gyeonggi Job Foundation Western Business Headquarters, 3rd floor, 25 Buheung-ro 424beon-gil, Bucheon-si, Gyeonggi-do
