엑셀 함수 정리This is material I wrote myself.
When using Excel, you frequently use date functions, time functions, logical functions, statistical functions, find-reference functions, mathematical functions, and character functions.
Let’s learn about how these Excel functions are used and how to display Excel functions.
There are a total of 32 Excel functions summarized.
I’ve organized it into a table to make it easier to understand.
1. Date function, time function
TODAY functionNOW functionYEAR functionMONTH function DAY function HOUR function DATE function
2. Logical functions
IF function AND function OR function DELTA function ISNUMBER function
3. Statistical functions
AVERAGE function AVERAGEA function LARGE function SMALL function MAX function MIN function
4. Find Reference Function
VLOOKUP function HLOOKUP function MATCH function INDEX function
5. Mathematical functions
SUM function SUMIF function MOD function PRODUCT function
6. Character functions
LEFT function RIGHT function MID function LOWEER function UPPER function PROPER function
In this way, we have created a collection of 32 Excel functions that are frequently used in Excel.
I hope this will be a useful resource for your Excel work.
This material was created by myself. I also created it as an image file. If you need the material, you can download it and use it.
Excel date time function.jpg
0.07MB
Excel logical function.jpg
0.07MB
Excel text function.jpg
0.09MB
Excel math function.jpg
0.07MB
Excel Find Reference Function.jpg
0.09MB
Excel statistical functions.jpg
0.07MB
2021.08.09 – [View all categories] – Collection of Excel shortcut keys
Excel shortcut key collection
We have brought you a collection of Excel shortcut keys that will shorten your Excel work time. This is a material I created myself using PowerPoint. If you know the shortcut keys frequently used when working in Excel, you can further reduce work time.
infoup.tistory.com
2021.08.08 – [View all categories] – Collection of PowerPoint shortcuts
PowerPoint shortcut key collection
We have prepared a collection of PowerPoint shortcuts that will reduce work time when working with PowerPoint. This is a document I found and created myself in PowerPoint. Office workers and students write with PowerPoint
infoup.tistory.com
2021.08.14 – [Information Industry] – Collection of free PowerPoint templates
Collection of free PowerPoint templates
Collection of Free PowerPoint Templates Are you working on PowerPoint? Do you want to make something cool but are worried because you don’t know how to make it? So, this is a collection of free PowerPoint template sites that we have prepared.
jungboup.com
TEL. 02.1234.5678 / Pangyoyeok-ro, Bundang-gu, Seongnam-si, Gyeonggi-do
© Kakao Corp.
