인프런 - 라이프타임 커리어 플랫폼

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

This is an in-depth course on Microsoft Power BI that allows you to analyze and explore data more effectively by applying various visualization techniques. Through this course, you can learn how to connect various data sources, refresh data in the way you want, and learn various data preprocessing methods to edit data in a form suitable for analysis.

Through the synergy of Excel and generative AI (ChatGPT), this practical, hands-on training covers the entire spectrum including data aggregation, cleansing, visualization, report writing, template automation, code-free schedule creation, VBA automation, and Google Sheets integration, designed to enable learners from Excel beginners to intermediate users to develop skills that can be immediately applied in real-world work through step-by-step learning.

A course for anyone who is not familiar with programming or an office worker who wants to easily handle work, to learn how to create data processing rules, merge multiple data, and easily automate with just a few mouse clicks!

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

This course is a hands-on course in which you will find statistical data needed in the workplace, download it yourself, and create charts (graphs).

Team leaders, you say, if you give me an Excel file, I have to look at it one by one? Can't you organize it so that it's pretty and easy to see at a glance? I'm busy organizing and analyzing data, but when will I edit it nicely? When that happens, you think, how great would it be if there was a magical tool that visualizes the Excel data I organized beautifully? Yes, there is. Power BI, a magical tool created by MS. It's a simple visualization tool that makes it easy to see the Excel data you created at a glance, and once you create it, it's continuously updated and used later! We'll tell you very, very easily and kindly what the program is and how to use it!

This is the second in-depth course on Microsoft Power BI that will help you analyze and explore data more effectively by applying various visualization techniques. Through this course, you will be able to accurately understand the data modeling work and relationships in Power BI and grasp various concepts that you must know to effectively utilize DAX.

You can learn various ways to use Excel to adjust, clean, and collate data brought in from outside, as well as how to extract, separate, and transform data from a single cell.

Learn the principles and usage of DAX, which is essential for advanced analysis using Excel Power Pivot, and learn major DAX functions.

Learn Excel Power Pivot to analyze large amounts of data in a high-performance environment. Excel Power Pivot is a powerful advanced data analysis tool in Excel that allows you to connect various data sources to build a data model and perform advanced analysis using DAX.

This course provides 100% hands-on experience by explaining which functions and features of Excel can be used to solve tasks most quickly and efficiently in these cases through examples used in actual workplaces.

As you follow along with fun, you will naturally learn the basic concepts and techniques. You will be able to easily create visualization tools that are accurate, clear, pretty, and attractive. You will naturally understand the features and advantages of each from Excel 2007 to 2016, and learn what advantages and disadvantages they have. You will learn how to make the impossible in Excel indirectly.

You know the importance of 🔥Big Data🔥 in your business, but you gave up on data analysis tools with difficult names like Python, R, SQL... before you even started? Don't worry anymore 😉 A beginner's course that teaches anyone how to analyze data and discover valuable insights using Excel, which is highly accessible!🎁

Stop using Excel based on difficult functions, and learn how to use advanced Excel functions with just a few clicks! Effectively learn advanced Excel functions that are highly useful but unfamiliar, and acquire work automation, data preprocessing, data modeling, and advanced visualization capabilities all at once, and raise your data analysis level!

Quickly pass the Comhwal Level 1 written exam with Wang Dumo Saem, who has 20 years of experience. Only study the Dumo keywords that frequently appear on the exam! Wang Dumo Comhwal

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

Learn how to aggregate and analyze data using PivotTables in Excel 2013.

You can learn various ways to use Excel to adjust, clean, and collate data brought in from outside, as well as how to extract, separate, and transform data from a single cell.

Learn how to use Power Query, an add-in to Excel, to analyze large amounts of data more quickly and efficiently, and automate repetitive data tasks.