강의

멘토링

커뮤니티

Productivity

/

Office

Data visualization practice using Excel

Stop messy and complicated data! 💥 Now organize your data clearly in Excel and become a professional worker 😉

(5.0) 5 reviews

28 learners

Level Basic

Course period Unlimited

  • Masocampus
Excel
Excel
MS-Office
MS-Office
Excel
Excel
MS-Office
MS-Office

Reviews from Early Learners

Reviews from Early Learners

5.0

5.0

이병주

30% enrolled

You explain things easily and well.

5.0

박윤희

100% enrolled

I learned well

5.0

김재학

100% enrolled

It was very helpful. I plan to take the related courses in the future.

What you will gain after the course

  • Ability to organize data clearly

  • Ability to utilize Excel formatting functions

  • Ability to convey key messages

  • Problem solving skills during data visualization

Data visualization is a fundamental quality of a professional.
Visualize data with Excel features!

📊 Easily visualize data with Excel! 📊

Accurately convey the core message using visual elements
Get a thumbs-up from your manager! Improve your personal skills and become a professional worker.


The Importance of Data Visualization
📈

Data visualization is a technique for effectively communicating information and data using visual elements like charts and graphs so that users can easily understand them . Because companies rely on their own data for decision-making, creating visualized data that is both visually appealing and accurate is paramount . However, for practitioners who aren't data analysts, even handling Excel and Word can be challenging, leading to the abandonment of data visualization .

Excel is the optimal tool for solving these problems . Leveraging its built-in features, it transforms scattered data into charts that can be easily understood by staff . Furthermore, complex and difficult-to-determine reports can be easily and conveniently processed through Excel, delivering only the essential information. This allows for effective communication and organizational goals .

This course starts from the basics and teaches you various methods to visualize data , such as slicers , pivot tables , sparklines , sunburst charts , waterfall charts , radial radar charts , vertical/horizontal gap charts , overlapping bar graphs , Gantt charts , and dumbbell charts, through hands-on practice . Those who have had difficulty with data visualization so far Learn various data visualization methods through this course and achieve your goals !


Make you a data visualization master
So that I can lead you ✨

💁 Recommended for these people

  • ✔️ Those who want to learn basic Excel formats
  • ✔️ For those who want to convey the core message based on accurate figures
  • ✔️ For those who want to organize data clearly
  • ✔️ Those who want to improve their Excel skills
  • ✔️ Those who dream of starting a business / joining a company / changing jobs / reskilling / talent transformation

🎲 After listening to this lecture

By taking this practical Excel data visualization course, you'll gain the following skills!

  • ✔️ Ability to organize data clearly
  • ✔️ Ability to utilize Excel functions
  • ✔️ Ability to convey key messages
  • ✔️ Problem-solving skills during data visualization

Key points of this lecture ✨

1. Let's start with the first steps of data visualization !

The key to data visualization is effectively communicating your core message to your audience. This course's curriculum is structured from the ground up, allowing even beginners, not data analysts, to easily learn data visualization. Therefore, anyone can master data visualization proficiency and even advanced data visualization techniques after completing the course.

2. Two data visualization methods in Excel are mine!

Excel can be broadly divided into form visualization and chart visualization. Form visualization allows you to clearly express your intended message, allowing your audience to grasp the core message at a glance. Chart visualization builds on your knowledge of bar charts and line charts, allowing you to learn how to use a variety of charts appropriate for your situation.

3. Maso Campus is also against lectures that only cover theory!

The data is already complex, but you're not even practicing it...? Learning that focuses solely on theory will never allow you to apply your knowledge in real-world situations! This course provides eight practice files to help you apply it directly to your work. This will help you accurately visualize your data and make sound decisions.

4. Master Data Visualization in Two Days Challenge

In today's hectic society, attending lectures is a luxury...? No! This course is perfect for our busy K-office workers who commute to and from work! This 7-hour and 47-minute course focuses on core competencies, allowing you to learn practical data visualization methods used in the workplace. Highly recommended for anyone looking to quickly master data analysis and visualization!


Check out what you've learned 📚

1. Learn basic cell and table formats.
2. Visualizing various formats using conditional formatting

3. Create versatile business data visualization charts (nested bar graphs, dumbbell charts, gap charts, Gantt charts)

4. Useful Business Data Visualization Practice

5. Multi-Alternative Interactive Dashboard Practice


Expected Questions Q&A 💬

Q. Do I need to be proficient in Excel to follow the class?

You don't have to worry about your Excel skills because the instructor will go over each and every button you need to click.

Q. I'm not that high in my position yet. Do you think this lecture is only meaningful if you have a high position?

No, that's not true. The only difference may be the size of the data being handled, but the ability to think data-driven is a skill required regardless of position or field.

Q. Are there any requirements or prerequisites for taking the course?

Since this is a hands-on course, we recommend bringing a dual monitor or a spare device that allows you to separate the lecture and practice screens. Furthermore, since the practical training will be conducted on a Windows OS, we recommend taking the course in a Windows environment.


Maso Campus Director Choi Jeong-ah
We are with you ✒️


Please check before taking the class ✔️

  • Sound volume varies by lecture (unit). Depending on your viewing environment, the audio in certain videos may appear quieter. Therefore, please be sure to check the lecture preview before attending.
  • Since this is a hands-on course, we recommend bringing a dual monitor or a spare device that allows you to separate the lecture and practice screens. Furthermore, since the practical training will be conducted on a Windows OS, we recommend taking the course on a Windows environment.
  • Lecture notes and practice files are available in the <13. Lecture Materials Download Center> section.

Recommended for
these people

Who is this course right for?

  • For those who want to know about the basic formats of Excel

  • For those who want to convey the core message based on accurate figures

  • For those who want to organize data clearly

  • Those who want to improve their Excel skills

  • People who dream of starting a business/joining a company/changing jobs/re-skilling/talent transformation

Need to know before starting?

  • Basic Excel skills to utilize tables

Hello
This is

9,422

Learners

1,337

Reviews

114

Answers

4.7

Rating

99

Courses

"I will grow more than yesterday. And, I will help those who strive to grow more than yesterday."

With Actionable Content that embodies the sincerity and aspirations of Maso Campus,

100 million cumulative hours of lectures shared online and offline since 2013!

This precious experience and time are always the source of growth for both Maso Campus and our students.

The Miso Campus team strictly adheres to two principles for the growth of us all. 1. Actionable Content that can be put into practice immediately after learning. 2. Respecting the time and effort of participants.

The Miso Campus team strictly adheres to two principles for the growth of us all.

1. Actionable Content that you can actually use after learning 2. Time-Saving Curriculum that respects the participant's time and effort Grow with Miso Campus's Actionable and Time-Saving Curriculum

1. Actionable Content that you can surely use once you learn it

2. Time-Saving Curriculum that respects the time and effort of participants

We hope you will walk the path of growth together with Masocampus's Actionable and Time-Saving Curriculum.

We hope you will walk the path of growth together with Maso Campus's Actionable and Time-Saving Curriculum.

Curriculum

All

23 lectures ∙ (7hr 46min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

5 reviews

5.0

5 reviews

  • byungjoolee8390님의 프로필 이미지
    byungjoolee8390

    Reviews 1

    Average Rating 5.0

    5

    30% enrolled

    You explain things easily and well.

    • masocampus
      Instructor

      I'm so happy that the lecture seems to have been delivered well! Thank you. 😊

  • byoungchanlee9207님의 프로필 이미지
    byoungchanlee9207

    Reviews 1

    Average Rating 5.0

    5

    30% enrolled

    • masocampus
      Instructor

      Thank you for leaving a course review😊

  • qjqtkfkd1238538님의 프로필 이미지
    qjqtkfkd1238538

    Reviews 1

    Average Rating 5.0

    5

    30% enrolled

    • masocampus
      Instructor

      Thank you for leaving a course review😊

  • yunheepark8121님의 프로필 이미지
    yunheepark8121

    Reviews 1

    Average Rating 5.0

    5

    100% enrolled

    I learned well

    • masocampus
      Instructor

      I'm so glad you enjoyed the class! Thank you. 😊

  • jaehak5271님의 프로필 이미지
    jaehak5271

    Reviews 4

    Average Rating 5.0

    5

    100% enrolled

    It was very helpful. I plan to take the related courses in the future.

    • masocampus
      Instructor

      I'm glad I could help you^^😊 Please take other lectures and I hope you achieve the skills you want!

$61.60

Masocampus's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!