[Excel Basics] 12 Functions Every Beginner Should Know | Essential Skills for Work

Опубликовано: 14 Август 2026
на канале: PC活用ちゃんねる

1,221,478

25k

Here are 12 essential worksheet functions that Excel beginners should learn first!

0:00 Introduction
0:54 SUM function
4:35 AVERAGE function
6:07 COUNT function
9:05 COUNTA function
10:56 IF function
15:14 COUNTIF function
16:53 COUNTIFS function
18:42 SUMIF function
21:23 SUMIFS function
24:37 VLOOKUP function
26:18 IFERROR function
27:13 XLOOKUP function

A thorough explanation of the SUMIF function!

   • 【Excel】SUMIF関数の使い方を世界一やさしく解説

A thorough explanation of the COUNTIF function!

   • 【Excel】実はこんなに使えるCOUNTIF関数｜基礎から応用まで解説

What is approximate match in the VLOOKUP function?

   • 【Excel】VLOOKUP関数のTRUE近似一致の使い方具体例

Applications of the XLOOKUP function

   • 【Excel】XLOOKUP関数の使用例５選！抽出作業が超楽ちん