엑셀 함수 정리It’s amazing.
The Excel function data shared this time can be said to be something special.
That’s right… Because we’ve organized not only functions, but also formula symbols that are very helpful in using functions! ^^
So the conclusion is…
Learn how to use 235 functions and how to use formulas.
I hope you have a perfect study of functions. ^^
(Even if you know the function, you often cannot use it without knowing the formula. For example, the conditional expression part of the IF function, etc.)
To learn how to use today’s data, please refer to how to use previous data.
Because the function part is the same!!
(How to use it in function data?) That’s right. ^^ This material has several ‘functions’.
http://amazingteur.blog.me/220796264050
This is the main screen that appears when you open this document. As you can see, many functions are organized.
From now on, I will briefly explain each sheet.
1. Collection of functions
This is literally the function summary part. As you can see, 235 functions are organized in the following format: ‘Category-Function Name-Version-Formula-Configuration-Function-Example and Answer’.
After learning the basics on the left, look at the examples and answers on the right for easier understanding!
2. Bundle functions
In this sheet, you can see help related to functions at the top, and several functions are grouped at the bottom.
The reason for grouping them is… There are quite a few functions in Excel that have similar functions or formulas.
If you just understand or memorize these things individually… you will fail!!
Be sure to understand it ‘bundled and conveniently’ like this!
3. Organizing formula symbols
This time, finally a formula symbol! This can be said to be a special advantage of this material.
For example, what if you want to easily find the sum of 201 x 337 and 465 x 283 (multiply)?
Even if you know how to use SUM, it will be difficult if you don’t know the formula.
In preparation for situations like this, please also know the formula symbols. ^^
For reference, you can use =SUM(201*337, 465*283).
At the bottom, the symbols used for ‘cell formatting’ are also organized.
The TEXT function is a function that applies cell formatting to a given value and expresses it.
If you don’t know how to apply cell formatting, it’s useless, right?
This ‘method’ corresponds to the symbol above. ^^
4. Elementary function quiz!
This is a place where you can take basic quizzes about basic functions.
This is a solvable problem if you understand the concept of functions, so try to solve it with confidence. ^^
Lastly, time to look at some functions!!
First, the statistical function part!!
There are quite a few useful functions for you, including LARGE, MAX, MIN, and RANK.
Please be sure to know these things as they will be very useful when working later. lol
The second is the legendary HLOOKUP and VLOOKUP! This is a pretty famous function, right?
In particular, the power of VLOOKUP is no joke here.
There is even a saying that you must know VLOOKUP to be a true expert in Excel functions.
This is pretty useful, right?
We hope you will completely master Excel with this material.
Go for it! ^^
Excel, blog, daily life-oriented / mutual neighbors are accepted, but if the blog appears to be managed by a robot, it will be rejected and blocked (blacklisted).
