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.2) 6 reviews

30 learners

Level Beginner

Course period Unlimited

Excel
Excel
MS-Office
MS-Office
Excel PowerQuery
Excel PowerQuery
dax
dax
data-visualization
data-visualization
Excel
Excel
MS-Office
MS-Office
Excel PowerQuery
Excel PowerQuery
dax
dax
data-visualization
data-visualization
날개 달린 동전

Recommend Course to grow and earn commission!

날개 달린 동전

Marketing Partners

Recommend Course to grow and earn commission!

Reviews from Early Learners

Reviews from Early Learners

4.2

5.0

fluree0732

13% enrolled

The lecture seems to be well-structured with content necessary for practical work, covering the entire process from beginner to intermediate and advanced levels. I'm really looking forward to and excited about the PivotTable and Power Query courses! From the very beginning, I'm learning a lot about how to easily solve tasks that I used to click on inconveniently and cumbersomely with keyboard shortcuts. Thank you.

What you will gain after the course

  • 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 DataScienceOne

83

Learners

10

Reviews

5

Answers

4.1

Rating

4

Courses

Data Science One | Taesun Yoo

LinkedIn Profile Instructor Introduction [Click]

Key Experience:

  • Senior Advisor at the Workplace Safety and Insurance Board (WSIB) of Ontario (1 year)

  • Workplace Safety and Insurance Board (WSIB) Senior Data Analyst (5 years of experience)


Education:

  • University of Toronto: Master of Health Informatics

  • Western University: Bachelor of Medical Physics


Areas of Expertise:

Data Analytics/Data Modeling/Business Analysis

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


Others: Data Science One YouTube Channel [Click]

  • I am uploading lectures for the purpose of sharing tips for getting hired as a data analyst, short data analysis portfolios, and Udemy course promotions!


Based on over 10 years of experience and know-how, I create courses to help those aspiring to become data analysts in North America sharpen their skills. My content covers everything from the basics to real-world use cases used in actual companies.

More

Curriculum

All

107 lectures ∙ (15hr 1min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

6 reviews

4.2

6 reviews

  • kangsc3185님의 프로필 이미지
    kangsc3185

    Reviews 8

    Average Rating 4.6

    5

    100% enrolled

    • hshshs님의 프로필 이미지
      hshshs

      Reviews 1

      Average Rating 5.0

      5

      100% enrolled

      It was a great course that was filled with the passion and expertise of the instructor from A to Z in Excel.

      • datascienceone
        Instructor

        Hello, thank you for taking the time to leave a review. It was a great help and we will come back with better content in the future.

    • fluree07320834님의 프로필 이미지
      fluree07320834

      Reviews 4

      Average Rating 5.0

      5

      13% enrolled

      The lecture seems to be well-structured with content necessary for practical work, covering the entire process from beginner to intermediate and advanced levels. I'm really looking forward to and excited about the PivotTable and Power Query courses! From the very beginning, I'm learning a lot about how to easily solve tasks that I used to click on inconveniently and cumbersomely with keyboard shortcuts. Thank you.

      • siwon4126983님의 프로필 이미지
        siwon4126983

        Reviews 1

        Average Rating 4.0

        4

        31% enrolled

        Each lecture is short, which is great. There was some noise or echo in the audio at the beginning that made some parts hard to hear.

        • datascienceone
          Instructor

          Thank you for leaving a course review. I will optimize the microphone settings to improve the audio quality.

      • wookjeon1950님의 프로필 이미지
        wookjeon1950

        Reviews 1

        Average Rating 5.0

        5

        100% enrolled

        DataScienceOne's other courses

        Check out other courses by the instructor!

        Similar courses

        Explore other courses in the same field!

        $39.60