UNO-Weekly | Excel-Basics
셀서식
DateTime_Format
단축키
DateTime_ShortCutKeys
값계산
ROUND+ROUNDUP+ROUNDDOWN
CEILING+FLOOR
값요약
SUMPRODUCT+LogicalFormula
논리식
IF+ISERR+IFERROR
Logical Formula Basic
날짜계산
DATEVALUE
DATEDIF
값찾기
INDIRECT_VLOOKUP_Naming
INDIRECT_Naming
RAND+RANK+COLUMN+INDEX
INDEX+MATCH_2+ArrayFormula
INDEX+MATCH_1
VLOOKUP+HLOOKUP+MATCH_1
VLOOKUP+MATCH_2
IF+LEFT+RIGHT+MID+DATE
RANK+CHOOSE
정보가공
TRIM+SUBSTITUTE
UNO_WEEKLY | Excel Basic Series |