강의

N
챌린지

멘토링

로드맵

Inflearn brand logo image
Productivity

/

Office

エクセル基礎から実務まで

Excelを初めて使用するユーザーから、職場でExcelを使って仕事を見るすべての方に便利な講座です。

（4.9）受講レビュー 161件

受講生 18,100名

  • 50012980964
Excel
MS-Office

学習した受講者のレビュー

【エクセル基礎から実務まで】

Excelは、サラリーマンにとって最も一般的なプログラムで、複雑な計算を簡単に処理し、データを効率的に管理、分析する機能を提供し、大量のデータを迅速に処理できます。そして、分析結果を最も効果的に見るために表とチャートを作成することができ、データを直感的かつ明確に表現できます。

Excelの基礎から実務までの講座は、Excelを初めて使用するユーザーから職場からExcelを使って仕事を見る実務者の方まで、すべての方が学習できる講座で、全16セクションと1ミッションで構成されています。

=============================================================================

0. Excelの基本、データ入力と管理
1. データベース - 入力だけうまくいっても管理が容易になる
2.データ管理 - 専門家のExcelが特別な理由
3. Excelの花、数式と関数
4. 論理および条件 - スマートなExcelの使用のための基本的な素養
5. テキスト - 文字データを扱う方法
6.日付と時刻 - 時間の計算はExcelが迅速かつ正確です
7. データ集計 - レポートを作成するための最初のボタン
8. フィルタリング - 値を参照する方法
9. チャート - 見やすいチャートがわかりやすい
10. ピボットテーブルとピボットチャート - 複雑で膨大なデータをまとめる
11. ミッション（0～10次まで）
12. パワークエリ (Power Query) New
13. ダイナミックレンジの使用法のすべて
14. 配列式
15. エクセル実務活用
16. エクサルのヒント
17. エクセル実務能力の育成
18. マクロ&VBA
=============================================================================
Excelの使用が初めての場合は、コース1から10まで順番に学習してください。ある瞬間、Excelの使用に自信を持つことができます。
Excelの基本的な使い方を知っている人なら、必要なコースだけを選んで学ぶことができます。 1つの講座がしっかりと構成されており、学習が簡単です。
なる！ 7日実務エクセル 本で学習する方は、セクション0～セクション11までを順番に学習すれば良いです。映像の下に本のページを表示しておきました。
そして、本の分量上入れられなかった内容は、知っておくとヨギンハンというタイトルで表示しておきました。講座の授業ノートは映像の下のブログアドレスをリンクしておきました。
映像だけを視聴しないで実習ファイルを必ずダウンロードして直接実習をしてみることをお勧めします。
Excelの基礎から実務までのコースが必要なすべての人に役立つことを願っています。

学習目標

  • Excelの基本を習得し、現業で適用できる実力を持つことができる。

役に立つ方

  • Excelを初めて使用する方
  • Excelの基本は身につけているが実務には適用しにくい方
  • 就職準備やオフィス資格の準備をする方

知識共有者の紹介

ちょっとした講座
  • ちょっとした講座YouTubeチャンネル（youtube.com/@hantip）、ブログ運営（hantip.net）
  • 官公署、公・企業、大学で講義
  • CLASS101、ティーチャービル、水原地方検察庁、大邱教育研修院イーラーニング製作（ティーチャービル）
  • EBSコンピュータ活用能力1、2級実機校正、交熱、エクセル実務付録作成
  • 著書：なる！ 7日実務Excel |なる！ワーキングエクセルパワーポイントワード＆ハングル

こんにちは
です。

18,100

受講生

161

受講レビュー

12

回答

4.9

講座評価

1

講座

カリキュラム

全体

191件 ∙ (25時間 11分)

講座資料（こうぎしりょう）:

授業資料
講座掲載日: 
最終更新日: 

受講レビュー

全体

161件

4.9

161件の受講レビュー

  • j17154668님의 프로필 이미지
    j17154668

    受講レビュー 1

    ∙

    平均評価 5.0

    5

    8% 受講後に作成

    I found out about it through YouTube, but I've been studying hard since joining Infraon. Thanks to that, I was able to buy the textbook... The only thing I regret is that you could make the table of contents of the class a little easier to understand. Is this too much to ask for since it's a free class?

    • serratus401812님의 프로필 이미지
      serratus401812

      受講レビュー 4

      ∙

      平均評価 4.8

      5

      70% 受講後に作成

      An incredibly amazing and great lecture on life

      • 50012980964
        知識共有者

        Haha thank you. That's a great compliment.

    • owenchoi96님의 프로필 이미지
      owenchoi96

      受講レビュー 11

      ∙

      平均評価 4.7

      5

      100% 受講後に作成

      I highly recommend this to anyone who wants to start Excel properly for the first time. Each lecture is not too long and it explains in detail with many examples, so I think it is the best lecture for beginners.

      • kyungdu6811님의 프로필 이미지
        kyungdu6811

        受講レビュー 1

        ∙

        平均評価 5.0

        5

        100% 受講後に作成

        I think it will be very helpful in practice. I think I will have to keep looking at it repeatedly because I don't have enough time. I also bought the Excel book this time. Thank you.

        • cjw46865667님의 프로필 이미지
          cjw46865667

          受講レビュー 2

          ∙

          平均評価 5.0

          5

          30% 受講後に作成

          無料

          似ている講座

          同じ分野の他の講座を見てみましょう！

          Excel Basics to AdvancedCourse Thumbnail

          Excel Basics to Advanced

          armikig1711

          Through this course, you can study Excel's basics, analysis functions, functions, and other features.

          Beginner

          Beginner

          Excel, MS-Office

          Excel Basics to AdvancedCourse Thumbnail

          Excel Basics to Advanced

          armikig1711

          Excel 2016, available directly at your companyCourse Thumbnail

          Excel 2016, available directly at your company

          marketing0937

          There are certain functions required when organizing Excel data. You can shorten the time for organizing data by learning only the basic functions that you are familiar with, such as VLOOKUP, pivot tables, and conditional sums. Invest just 7 minutes a day. Through this course, you can neatly solve the complicated task of organizing data.

          Beginner

          Beginner

          Excel, MS-Office

          Excel 2016, available directly at your companyCourse Thumbnail

          Excel 2016, available directly at your company

          marketing0937

          Basic Statistics with ExcelCourse Thumbnail

          Basic Statistics with Excel

          statisticsplaybook

          Statistics learned in school, was it too hard to understand? No matter how much you listened to the explanation, statistics were confusing, but we will help you understand them. If you implement them one by one by hand using Excel, you will understand statistical concepts that you didn't understand! A new experience that makes boring statistics fun! We will give you a gift. :)

          Basic

          Basic

          Excel, Statistics

          Basic Statistics with ExcelCourse Thumbnail

          Basic Statistics with Excel

          statisticsplaybook

          [Pass ITQ Excel A in One Go] in 3 daysCourse Thumbnail

          [Pass ITQ Excel A in One Go] in 3 days

          dmsgml1030

          Even complete beginners who don't know anything about Excel are OK! Just follow the lectures and you can get an A grade in ITQ Excel.

          Basic

          Basic

          ITQ, Excel, MS-Office

          [Pass ITQ Excel A in One Go] in 3 daysCourse Thumbnail

          [Pass ITQ Excel A in One Go] in 3 days

          dmsgml1030

          Powering Your Data! Excel Data AnalysisCourse Thumbnail

          Powering Your Data! Excel Data Analysis

          alpaco

          Are you wondering which tool to use for data analysis? Get started easily with Excel!

          Beginner

          Beginner

          Excel, Excel PowerQuery

          Powering Your Data! Excel Data AnalysisCourse Thumbnail

          Powering Your Data! Excel Data Analysis

          alpaco

          ITQ Powerpoint Certification to be completed over the weekendCourse Thumbnail

          ITQ Powerpoint Certification to be completed over the weekend

          erumcoding

          ITQ PowerPoint national certification key summary lecture that can be obtained by utilizing two days of the weekend! 4 mock exams and real-time mock exam solution videos provided

          Beginner

          Beginner

          MS-Office, PowerPoint, ITQ

          ITQ Powerpoint Certification to be completed over the weekendCourse Thumbnail

          ITQ Powerpoint Certification to be completed over the weekend

          erumcoding

          Analyzing and predicting marketing data with ExcelCourse Thumbnail

          Analyzing and predicting marketing data with Excel

          groschool

          A class on analyzing customer/sales data with Excel, even without R or Python!

          Basic

          Basic

          Excel, Performance Marketing

          Analyzing and predicting marketing data with ExcelCourse Thumbnail

          Analyzing and predicting marketing data with Excel

          groschool

          [Basics] Even those with no coding experience can do it! Automating Google Sheets tasks in 90 minutesCourse Thumbnail

          [Basics] Even those with no coding experience can do it! Automating Google Sheets tasks in 90 minutes

          workwithdugi

          Even those with no coding experience can automate Google Sheets and Apps Script tasks! I will teach you the easiest way by creating examples that can be used in actual work.

          Beginner

          Beginner

          Business Productivity, Google Apps Script, Google Sheets

          [Basics] Even those with no coding experience can do it! Automating Google Sheets tasks in 90 minutesCourse Thumbnail

          [Basics] Even those with no coding experience can do it! Automating Google Sheets tasks in 90 minutes

          workwithdugi

          Business Analytics, Strategic Decision Making Practice Master ClassCourse Thumbnail

          Business Analytics, Strategic Decision Making Practice Master Class

          Masocampus

          You know the importance of 🔥Big Data🔥 in your business, but you gave up on data analysis tools with difficult names like Python, R, SQL... before you even started? Don't worry anymore 😉 A beginner's course that teaches anyone how to analyze data and discover valuable insights using Excel, which is highly accessible!🎁

          Basic

          Basic

          Excel, Management

          Business Analytics, Strategic Decision Making Practice Master ClassCourse Thumbnail

          Business Analytics, Strategic Decision Making Practice Master Class

          Masocampus

          ChatGPT × Excel Practical Application: Easy Start to Work Automation for EveryoneCourse Thumbnail

          ChatGPT × Excel Practical Application: Easy Start to Work Automation for Everyone

          iexceller

          Covers how to properly use the new game-changer "ChatGPT" for "Excel utilization." You can learn to create Excel formulas for practical use, easily grasp Excel functions, and write macros and VBA code using ChatGPT.

          Basic

          Basic

          Excel, VBA, ChatGPT

          ChatGPT × Excel Practical Application: Easy Start to Work Automation for EveryoneCourse Thumbnail

          ChatGPT × Excel Practical Application: Easy Start to Work Automation for Everyone

          iexceller

          Business Analytics, Data-Driven Strategy Establishment Practical Master ClassCourse Thumbnail

          Business Analytics, Data-Driven Strategy Establishment Practical Master Class

          Masocampus

          You still haven't started studying data analysis...? Are you... what? 😦 Now, data analysis is not a choice but a necessity! Master data analysis with Masocampus lectures and live a new life!

          Basic

          Basic

          Excel, Management

          Business Analytics, Data-Driven Strategy Establishment Practical Master ClassCourse Thumbnail

          Business Analytics, Data-Driven Strategy Establishment Practical Master Class

          Masocampus

          [Revised in 2024] This is the real Korean language automation [Basic Edition]Course Thumbnail

          [Revised in 2024] This is the real Korean language automation [Basic Edition]

          hpxl0518

          Forget about the difficult Korean language automation that has been going on so far! Just follow along and you will complete the automation program.

          Beginner

          Beginner

          Python, Excel, RPA

          [Revised in 2024] This is the real Korean language automation [Basic Edition]Course Thumbnail

          [Revised in 2024] This is the real Korean language automation [Basic Edition]

          hpxl0518

          Data Automation (with VBA)Course Thumbnail

          Data Automation (with VBA)

          엑셀디자인

          1. You may experience the side effect of thinking about VBA codes while sleeping. 2. You may become a workaholic by choice due to the desire to automate repetitive Excel tasks one by one.

          Intermediate

          Intermediate

          Excel, VBA

          Data Automation (with VBA)Course Thumbnail

          Data Automation (with VBA)

          엑셀디자인

          Computer Proficiency Level 1,2 Practical - Spreadsheet Practice (2021 Revised)Course Thumbnail

          Computer Proficiency Level 1,2 Practical - Spreadsheet Practice (2021 Revised)

          usefulit

          Through this course, learners can acquire the ability to obtain a computer proficiency certificate. It is a course for obtaining a computer proficiency certificate, and it is structured in accordance with the examination criteria. You can learn and utilize basic knowledge of the computer proficiency subject to prepare for obtaining the certificate. (Computer Proficiency Level 1, 2 Practical - Spreadsheet Practice (2021 Revised))

          Basic

          Basic

          Computer Specialist in Spreadsheet & Database, MS-Office, Excel

          Computer Proficiency Level 1,2 Practical - Spreadsheet Practice (2021 Revised)Course Thumbnail

          Computer Proficiency Level 1,2 Practical - Spreadsheet Practice (2021 Revised)

          usefulit

          Computer Proficiency Level 1,2 Written Test - Spreadsheet General (2021 Revised)Course Thumbnail

          Computer Proficiency Level 1,2 Written Test - Spreadsheet General (2021 Revised)

          usefulit

          Through this course, learners can acquire the ability to obtain a computer proficiency certificate. It is a course for obtaining a computer proficiency certificate, and it is structured in accordance with the examination criteria. You can learn and utilize basic knowledge of the computer proficiency subject to prepare for obtaining the certificate. (Computer Proficiency Level 1, 2 Written - Spreadsheet General (2021 Revised))

          Beginner

          Beginner

          Computer Specialist in Spreadsheet & Database, MS-Office, Excel

          Computer Proficiency Level 1,2 Written Test - Spreadsheet General (2021 Revised)Course Thumbnail

          Computer Proficiency Level 1,2 Written Test - Spreadsheet General (2021 Revised)

          usefulit