강의

N
챌린지

멘토링

N
클립

커뮤니티

Productivity

/

Office

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

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

（4.9）受講レビュー 168件

受講生 18,290名

  • 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,290

受講生

168

受講レビュー

12

回答

4.9

講座評価

1

講座

カリキュラム

全体

191件 ∙ (25時間 11分)

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

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

受講レビュー

全体

168件

4.9

168件の受講レビュー

  • 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% 受講後に作成

          無料

          似ている講座

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

          Microsoft Teams - 1 Using Teams (from basics to team composition)講義サムネイル

          Microsoft Teams - 1 Using Teams (from basics to team composition)

          omas

          This is Teams training for all team members, team leaders, and managers who will collaborate through Teams. This training covers everything from understanding Teams to how to use chat, and how to organize and use teams and channels for collaboration.

          入門

          入門

          Teams, MS-Office, Business Productivity

          Microsoft Teams - 1 Using Teams (from basics to team composition)講義サムネイル

          Microsoft Teams - 1 Using Teams (from basics to team composition)

          omas

          Excel Basics to Advanced講義サムネイル

          Excel Basics to Advanced

          armikig1711

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

          入門

          入門

          Excel, MS-Office

          Excel Basics to Advanced講義サムネイル

          Excel Basics to Advanced

          armikig1711

          [Episode] Excel + Python (Basic)講義サムネイル

          [Episode] Excel + Python (Basic)

          datadoctor

          Now you can use Python in Excel! A light lecture to try out the latest features!

          初級

          初級

          Excel, Python

          [Episode] Excel + Python (Basic)講義サムネイル

          [Episode] Excel + Python (Basic)

          datadoctor

          Power Automate Level 4 - Creating a Vacation Request/Management System講義サムネイル

          Power Automate Level 4 - Creating a Vacation Request/Management System

          omas

          Are you using Excel to apply for and manage vacation/annual leave? 🤔 Stop asking your manager about your annual leave every time! Create a vacation application and management system for your company through this lecture.

          初級

          初級

          Power Automate, SharePoint, Power Apps

          Power Automate Level 4 - Creating a Vacation Request/Management System講義サムネイル

          Power Automate Level 4 - Creating a Vacation Request/Management System

          omas

          Computer Application Skills Level 1 & 2 Practical - Spreadsheet Practice講義サムネイル

          Computer Application Skills Level 1 & 2 Practical - Spreadsheet Practice

          usefulit

          Through this course, learners will be able to acquire the skills necessary to obtain a Computer Application Skills certification. This course is structured according to the examination standards for obtaining the Computer Application Skills certification. You can learn and apply fundamental knowledge of Computer Application Skills subjects to prepare for certification acquisition. (Computer Application Skills Level 1 & 2 Practical - Spreadsheet Practice)

          初級

          初級

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

          Computer Application Skills Level 1 & 2 Practical - Spreadsheet Practice講義サムネイル

          Computer Application Skills Level 1 & 2 Practical - Spreadsheet Practice

          usefulit

          Basic Statistics with Excel講義サムネイル

          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. :)

          初級

          初級

          Excel, Statistics

          Basic Statistics with Excel講義サムネイル

          Basic Statistics with Excel

          statisticsplaybook

          ITQ Powerpoint Certification to be completed over the weekend講義サムネイル

          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

          入門

          入門

          MS-Office, PowerPoint, ITQ

          ITQ Powerpoint Certification to be completed over the weekend講義サムネイル

          ITQ Powerpoint Certification to be completed over the weekend

          erumcoding

          [Basics] Even those with no coding experience can do it! Automating Google Sheets tasks in 90 minutes講義サムネイル

          [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.

          入門

          入門

          Business Productivity, Google Apps Script, Google Sheets

          [Basics] Even those with no coding experience can do it! Automating Google Sheets tasks in 90 minutes講義サムネイル

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

          workwithdugi

          [Work Automation Using Free MS RPA] Power Automate Desktop Basic講義サムネイル

          [Work Automation Using Free MS RPA] Power Automate Desktop Basic

          omas

          We will practice automating repetitive tasks using Power Automate Desktop, a free RPA tool from MS. Through this process, we will learn to understand automation and apply it to our actual work.

          初級

          初級

          Power Automate, MS-Office

          [Work Automation Using Free MS RPA] Power Automate Desktop Basic講義サムネイル

          [Work Automation Using Free MS RPA] Power Automate Desktop Basic

          omas

          Computer Application Skills Level 1 & 2 Written Exam - Spreadsheet General講義サムネイル

          Computer Application Skills Level 1 & 2 Written Exam - Spreadsheet General

          usefulit

          Through this course, learners can develop the ability to obtain a Computer Application Skills certification. This course is structured according to the examination standards as a preparation course for acquiring the Computer Application Skills certification. You can learn and apply basic knowledge of Computer Application Skills subjects to prepare for certification acquisition. (Computer Application Skills Level 1 & 2 Written Exam - Spreadsheet General)

          入門

          入門

          Excel, MS-Office, VBA

          Computer Application Skills Level 1 & 2 Written Exam - Spreadsheet General講義サムネイル

          Computer Application Skills Level 1 & 2 Written Exam - Spreadsheet General

          usefulit

          [Pass ITQ Excel A in One Go] in 3 days講義サムネイル

          [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.

          初級

          初級

          ITQ, Excel, MS-Office

          [Pass ITQ Excel A in One Go] in 3 days講義サムネイル

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

          dmsgml1030

          Powering Your Data! Excel Data Analysis講義サムネイル

          Powering Your Data! Excel Data Analysis

          alpaco

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

          入門

          入門

          Excel, Excel PowerQuery

          Powering Your Data! Excel Data Analysis講義サムネイル

          Powering Your Data! Excel Data Analysis

          alpaco

          [For Beginners] Data Visualization with Power BI講義サムネイル

          [For Beginners] Data Visualization with Power BI

          dee

          In the [Beginner's] Data Visualization with Power BI course, you will learn how to edit data using the query editor, visualize data using various tools, and check and share the analyzed results.

          入門

          入門

          Power BI, MS-Office

          [For Beginners] Data Visualization with Power BI講義サムネイル

          [For Beginners] Data Visualization with Power BI

          dee

          Efficient AI Utilization That Companies Want - Conquering Excel with AI Structured Prompts講義サムネイル

          Efficient AI Utilization That Companies Want - Conquering Excel with AI Structured Prompts

          Masocampus

          Is it possible to automate Excel without uploading company data? AI utilization secrets revealed that maintain security while reducing work hours!

          入門

          入門

          ChatGPT, Excel, AI

          Efficient AI Utilization That Companies Want - Conquering Excel with AI Structured Prompts講義サムネイル

          Efficient AI Utilization That Companies Want - Conquering Excel with AI Structured Prompts

          Masocampus

          Analyzing and predicting marketing data with Excel講義サムネイル

          Analyzing and predicting marketing data with Excel

          groschool

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

          初級

          初級

          Excel, Performance Marketing

          Analyzing and predicting marketing data with Excel講義サムネイル

          Analyzing and predicting marketing data with Excel

          groschool

          ChatGPT × Excel Practical Application: Easy Start to Work Automation for Everyone講義サムネイル

          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.

          初級

          初級

          Excel, VBA, ChatGPT

          ChatGPT × Excel Practical Application: Easy Start to Work Automation for Everyone講義サムネイル

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

          iexceller