강의

멘토링

컀뮀니티

Productivity

/

Office

Practical Excel Data Analysis: Formulas, Power Query, Dashboard Creation

In this course, you can learn a wide range of topics, from basic Excel functions to advanced formulas, data visualization, and dashboard creation, with a focus on hands-on practice. By providing templates and solution files, self-study is possible, and you can maximize work efficiency by mastering data analysis skills that can be immediately applied in real-world scenarios.

(4.0) 5 reviews

29 learners

  • DataScienceOne
Excel
ms-office
Excel PowerQuery
DAX
MS-Office
dax
data-visualization

Reviews from Early Learners

What you will learn!

  • With this single lecture, you can learn everything from basic Excel navigation to advanced formulas, Power Query, Power Pivot, and data visualization.

  • Learn core practical skills intensively: Excel formulas, M code, DAX, etc.

  • Data Visualization Wireframe Theory: Color, Font, Layout, Creating Dashboards can improve understanding of optimal design practices.

“Do you feel like data analysis is too complicated?”

“Do you want to organize and visualize your data efficiently?”

In this course, you will learn how to analyze data, create reports, and build dashboards by utilizing various functions of Excel.

Specific outcomes you will achieve from this course:

  • Organized Data Sheets : Manage your data efficiently using advanced data cleaning techniques.

  • Efficient reports and dashboards : Use pivot tables and visualization techniques to present your data in an easily understandable format.

  • Project Experience : Apply the skills you learn in real-world situations through a capstone project based on a real-world scenario.

This course goes beyond simple functional explanations to cover how to maximize productivity in practice. You will learn in-depth techniques for data processing and analysis.


Why should I take this course?

💡 Maximize efficiency : Leverage a variety of Excel functions to expedite the data analysis process.
💡 Immediately applicable to practice : You can immediately apply what you learn through real-world examples.
💡 Grow as a professional : Master data analysis and visualization skills to perform better at your job.


Become an expert in data analysis and automation using Excel today! Learn Excel skills that will maximize your work productivity.

🔥 Features of this course 🔥

📌 Learn Excel functions that can be used immediately in real life
From basic Excel usage to data visualization, pivot tables, and advanced functions, you will learn step-by-step and learn various functions that can be applied immediately in practice.

📌 Provides efficient data processing and report writing methods
Learn how to streamline repetitive data processing tasks and create reports more efficiently using Excel.

📌 50% theory, 50% practice
By appropriately combining theory and practice, you can learn Excel's functions through practice and learn how to use them in actual work.

📌 Available for beginners to intermediate level
It is structured so that even beginners to Excel can easily follow along, and those who know the basic functions can quickly learn advanced content.

👍 I recommend this to these people 👍

Office workers who have difficulty analyzing and organizing data

For those who want to efficiently process data and create reports using Excel

For those who want to learn Excel skills in depth through real-world project experience.

Anyone can easily learn Excel basic formulas, advanced functions, data visualization, and practical applications!

This course is composed of 50% theory and 50% practice , so you can learn step by step. You can learn Excel functions through various practical examples and learn how to apply them in practice.

After taking the course, you will be able to:

  • Data Organization and Analysis : Learn Excel features that help you easily organize and analyze your data.

  • Create reports : Create readable reports using pivot tables and charts.

  • Project Completion : Gain hands-on experience by completing projects based on real data.

After taking the course , you will be able to:

  • Data cleaning and analysis ✅
    Learn techniques to efficiently organize and analyze data using Excel's various functions. Learn techniques that can be applied immediately in the field, such as removing duplicates and handling blank values.

  • Report writing and visualization ✅
    You'll learn how to create readable reports using pivot tables and charts, and how to effectively communicate information by applying data visualization principles.

  • Project performance and practical experience ✅
    By working on projects based on real data, you can apply data analysis and visualization techniques and gain practical experience, which will help you strengthen your job-related skills.



    #MS-Office #dax #ExcelPowerQuery #data-visualization


Learn about these things.

Navigate the Excel Basic Menu

Get familiar with Excel's basic menus and worksheet components, and learn how to select data and format cells to create an efficient work environment.

Excel Basic and Advanced Functions

From basic formulas to advanced functions, you will strengthen your data analysis and calculation skills by utilizing functions such as SUM, VLOOKUP, and IF, and learn various formulas required in the field.

Excel Power Query and Power Pivot

Learn how to efficiently retrieve and organize data with Power Query, and how to model data and create calculated columns using DAX using Power Pivot.

Data Visualization and Projects (Creating a Financial Budget Dashboard)

Learn the fundamental principles of data visualization, design and implement dashboards to create a practical financial budget dashboard. Gain hands-on experience through projects based on real data.

Introducing the knowledge sharer (instructor)

Education:

  • Master of Health Informatics (University of Toronto)

  • Bachelor of Science in Medical Physics (Western University)

personal history:

  • Dec 2018 - Present: Ontario Workers Insurance Corporation - Senior Data Analyst

  • Sep 2015 - Mar 2018: CAMH Hospital - Lead Business Intelligence QA Analyst


bailiwick:

  • Business Intelligence / Data Modeling

  • Business Analysis / Data Analysis

  • Data Visualization / Product Development


Personal YouTube Channel:

  • Founder of YouTube Channel Data Science One


Things to note before attending the lecture

💻 Class environment information

  • Operating System and Version (OS) : Windows 10 or later, macOS

  • Tools used : Microsoft Excel (2016 or later recommended)

  • PC specifications : Minimum performance computer capable of running Excel

  • Target Audience : The course is structured so that even those without programming experience can follow along, but an understanding of basic Excel functions will help you learn more smoothly.

Learning Materials

  • Download Materials : All materials are provided in the [Section 0. Download Lecture Package] for practice materials.

  • Practical examples and datasets : Provides sample datasets for various data analysis practices.

  • Template : Data analysis and report creation template using Excel

  • Samples : Sample data analytics-focused reports and dashboards


Player Knowledge and Notes

  • Microsoft account creation and Office license verification required :


    If necessary, we recommend using the Office 365 trial version or purchasing the full version of MS Office 2016.

  • Experience using Excel :


    No experience is required to take this course, but basic Excel experience is helpful.

  • Understanding basic formulas and functions :


    An understanding of basic formulas and functions (SUM, AVERAGE, etc.) is helpful, but not required.

  • The lecture is based on the English version of Excel.
    Please note that although the practice files and lecture materials are provided in Korean, the English version of Excel screens are used within the video.


  • Unauthorized distribution of lecture materials is prohibited :


    Please refrain from unauthorized distribution of the material as this constitutes copyright infringement.

Recommended for
these people

Who is this course right for?

  • Excel novice

  • Office workers interested in data analysis and report writing

  • Those who want to increase productivity by using Excel in their work

Need to know before starting?

  • Excel Basics

  • Data Analysis Basics

Hello
This is

79

Learners

8

Reviews

5

Answers

3.9

Rating

4

Courses

데읎터싞읎얞슀원 | Taesun Yoo

링크딘 프로필 강사소개 [큎늭]

죌요 겜력:

  • 옚타늬였죌 귌로자 볎험 공닚 (WSIB) 시니얎 얎드바읎저 (1년)

  • 옚타늬였죌 귌로자 볎험 공닚 (WSIB) 시니얎 데읎터 분석가 (겜력 5년)


학력:

  • 토론토 대학교: 볎걎 정볎학 석사

  • 웚슀턎 대학교: 의학 묌늬학 학사


전묞 분알:

Data Analytics/Data Modeling/Business Analysis

Business Intelligence/Data Visualization/Product Development (Power BI)


Ʞ타: 데읎터싞읎얞슀원 유튜람 채널 [큎늭]

  • 데읎터 분석가로 췚업에 도움읎 되는 팁, 짧은 데읎터 분석 포튞폎늬였, 유데믞 윔슀 프로몚션 등을 목적윌로 강의륌 업로드하고 있습니닀!


10년 읎상의 겜력곌 녞하우륌 바탕윌로, 북믞에서 데읎터 분석가로 췚업을 원하시는 분듀을 위핎 Ʞ술을 갈고 닊을 수 있게 강의륌 만듀고 있습니닀. Ʞ쎈부터 싀제 Ʞ업에서 사용하는 응용 묞제(Use Cases)까지 닀룚고 있습니닀.

Curriculum

All

107 lectures ∙ (15hr 1min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

5 reviews

4.0

5 reviews

  • siwon4126983님의 프로필 읎믞지
    siwon4126983

    Reviews 1

    ∙

    Average Rating 4.0

    4

    31% enrolled

    1぀の講矩が短くお良いです。 音響が序盀にノむズたたぱコヌがあっお、よく聞こえない郚分がありたした。

    • datascienceone
      Instructor

      受講レビュヌを残しおいただき、ありがずうございたす。マむクの蚭定を最適化しお音質を向䞊させるようにいたしたす。

  • hshshs님의 프로필 읎믞지
    hshshs

    Reviews 1

    ∙

    Average Rating 5.0

    5

    100% enrolled

    講垫の情熱ず専門性が詰たった、Excel の A-Z たでを網矅した玠晎らしい講座でした。

    • datascienceone
      Instructor

      こんにちは。時間をかけお受講レビュヌを残しおいただきありがずうございたす。ずおも倧きな力になりたす。今埌、より良いコンテンツでお䌚いできるよう努めたす。

  • kangsc3185님의 프로필 읎믞지
    kangsc3185

    Reviews 8

    ∙

    Average Rating 4.6

    5

    100% enrolled

    • fluree07320834님의 프로필 읎믞지
      fluree07320834

      Reviews 4

      ∙

      Average Rating 5.0

      5

      13% enrolled

      講矩の構成が初玚から䞭玚、高玚に至るたで党過皋においお、実際の業務に必芁な内容で構成されおいるようです。 ピボットテヌブルも、パワヌク゚リの過皋もずおも楜しみで、埅ち遠しいです 普段、䞍䟿で面倒にクリックしおいた䜜業が、ショヌトカットキヌで簡単に解決できる郚分に、最初から倚くのこずを孊んでいたす。 ありがずうございたす。

      • dddddffddd님의 프로필 읎믞지
        dddddffddd

        Reviews 1

        ∙

        Average Rating 1.0

        Edited

        1

        32% enrolled

        説明がうたくいっおおらず、事前準備なしで講矩を準備したのではないかずいう考えがずっず頭の䞭に浮かんでいたした。잠깐만요, 죄송핎요を䜕床も繰り返したり、自分で䜜った䟋でround関数を䜿甚しおいるのに、自動的に小数点以䞋が切り捚おられた倀に「なぜこうなるのこれは必芁ない」ず蚀ったり、自分で䜜成した出力デヌタず異なる倀が衚瀺されたのに「ずにかく」ず無芖したりする郚分で信頌性が䜎䞋したした。たずえ倀がぎったりず䞀臎しおround関数が䞍芁だったずしおも、自分で掻甚䟋ずしお出したのなら、掻甚できるように䟋倀を修正するべきではないでしょうか。講矩を公開する前に、それを修正/反映するべきではなかったでしょうか。他にもこのような郚分がたくさんありたした。講矩の内容ず説明も英語ベヌスで䞍䟿ですし、無料講矩ではなく有料講矩なのに、講矩の質は無料講矩に劣りたす。良かった点は、講矩パヌトが现分化されおいるので、知っおいる郚分はすべおスキップできるずいう点だけです。

        • datascienceone
          Instructor

          こんにちは。貎重な時間を割いお、講矩に察する率盎なフィヌドバックをいただきありがずうございたす。 講矩の進行方法がスムヌズでなかった点は、心から残念に思っおおり、これを補うために講矩動画を再撮圱しお眮き換える予定です。おっしゃった内容を積極的に反映したす。 ただし、講矩の質が無料講矩よりも劣っおいるずいう意芋には同意できたせん。進行方法に残念な点があったこずは認めたすが、講矩に含たれるコンテンツず実務掻甚䟋に぀いおは自信を持っおいたす。 たた、䞀郚の受講者に䞍䟿をかける可胜性があるこずを考慮せずに、Excelの英語バヌゞョンをベヌスに説明したした。しかし、講矩動画ず実習ファむルはすべお韓囜語で提䟛されおおり、講矩の抂芁にその内容を明確に蚘茉したす。 今埌もより良い講矩を提䟛できるよう継続的に改善しおいきたす。もう䞀床フィヌドバックをいただきありがずうございたす。

      $39.60

      DataScienceOne's other courses

      Check out other courses by the instructor!

      Similar courses

      Explore other courses in the same field!