====== πŸ“‚ Excel ====== Excel κ΄€λ ¨ λ¬Έμ„œλ“€μ„ λͺ¨μ•„λ‘” κ³΅κ°„μž…λ‹ˆλ‹€. ===== πŸ“‹ λ¬Έμ„œ λͺ©λ‘ ====== ^ ꡬ뢄 ^ μ†ŒλΆ„λ₯˜ ^ νŽ˜μ΄μ§€λͺ…(링크) ^ 제λͺ© ^ | Excel | - | [[wiki:hr:excel:countif|countif]] | πŸ“„ Excel COUNTIF/COUNTIFS ν•¨μˆ˜ ν™œμš© κ°€μ΄λ“œ | | ::: | ::: | [[wiki:hr:excel:excel_pivot|excel_pivot]] | πŸ“„ μ—‘μ…€ ν”Όλ²— ν…Œμ΄λΈ”(Pivot Table) μ™„λ²½ ν™œμš©λ²• | | ::: | ::: | [[wiki:hr:excel:excel_sumif|excel_sumif]] | πŸ“„ SUMIF ν•¨μˆ˜ 싀무 ν™œμš©λ²• | | ::: | ::: | [[wiki:hr:excel:excel_vba|excel_vba]] | πŸ“„ μ—‘μ…€ VBA μžλ™ν™” κ°€μ΄λ“œ | | ::: | ::: | [[wiki:hr:excel:excel_vlookup|excel_vlookup]] | πŸ“„ VLOOKUP ν•¨μˆ˜ μ™„μ „ 정볡 | | ::: | ::: | [[wiki:hr:excel:excelmacro|excelmacro]] | πŸ“„ μ—‘μ…€ 맀크둜 μ‚¬μš©λ²• 상세 κ°€μ΄λ“œ | | ::: | ::: | [[wiki:hr:excel:index_match|index_match]] | πŸ“„ μ—‘μ…€ INDEX/MATCH ν•¨μˆ˜ μ‚¬μš© κ°€μ΄λ“œ | --- //이 ν‘œλŠ” μžλ™μœΌλ‘œ μƒμ„±λ©λ‹ˆλ‹€. μˆ˜μ •ν•˜μ§€ λ§ˆμ„Έμš”.// //λ§ˆμ§€λ§‰ μ—…λ°μ΄νŠΈ: 2025-08-07 16:44//