Inflearn brand logo image
Inflearn brand logo image
Inflearn brand logo image
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) 4 reviews

24 learners

  • masocampus
Excel
MS-Office

What you will learn!

  • 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

6,848

Learners

824

Reviews

95

Answers

4.7

Rating

85

Courses

"어제보다 성장하겠습니다. 그리고, 어제보다 성장하려는 사람을 돕겠습니다."

 

마소캠퍼스의 진심과 소망을 담은 Actionable Content로,

2013년부터 온오프라인으로 함께해 온 누적 강의 1억시간!

이 소중한 경험과 시간은 언제나 마소캠퍼스와 수강생 모두의 성장의 원천입니다.

 

마소캠퍼스 팀은 우리의 모두의 성장을 위해 두 가지 원칙을 반드시 지킵니다.

 

1. 배우면 반드시 쓸 수 있는 Actionable Content

2. 참여자의 시간과 수고를 존중하는 Time-Saving Curriculum

 

마소캠퍼스의 Actionable and Time-Saving Curriculum으로 성장의 길을 함께 걸어나가길 기원합니다.

Curriculum

All

23 lectures ∙ (7hr 46min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

4 reviews

5.0

4 reviews

  • byoungchanlee9207님의 프로필 이미지
    byoungchanlee9207

    Reviews 1

    Average Rating 5.0

    5

    30% enrolled

    • masocampus
      Instructor

      受講レビューを残していただき、ありがとうございます😊

  • qjqtkfkd1238538님의 프로필 이미지
    qjqtkfkd1238538

    Reviews 1

    Average Rating 5.0

    5

    30% enrolled

    • masocampus
      Instructor

      受講レビューを残していただき、ありがとうございます😊

  • yunheepark8121님의 프로필 이미지
    yunheepark8121

    Reviews 1

    Average Rating 5.0

    5

    100% enrolled

    よく学んだ

    • masocampus
      Instructor

      よく受講してくださったなんて本当に嬉しいです!ありがとうございます。 😊

  • jaehak5271님의 프로필 이미지
    jaehak5271

    Reviews 4

    Average Rating 5.0

    5

    100% enrolled

    多くの助けになりました。続いて連携する過程などを受講する予定です。

    • masocampus
      Instructor

      役に立つことができて嬉しいです^^😊他の講義も聞いて、ぜひ欲しい能力を達成してください!

$61.60

masocampus's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!