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

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.

For those who have difficulty with Excel, we deliver only the essentials that you need to know in the shortest time possible. And, the effect of killing two birds with one stone until obtaining a certificate. Take this opportunity to gain Excel practice and a certificate. Unlike other OA programs, Excel has many complicated parts in terms of functions and utilization. Based on the know-how accumulated through long lectures, we only cover the essentials of Excel. In relation to practical use, you can improve your Excel practical skills in a short period of time and obtain the ITQ Excel certificate, which is highly useful in practice, at the same time.

This is the process of becoming the 'standard' for efficiently and scientifically processing and analyzing data using the most trendy method in Excel.

Stop dealing with messy, complicated data! 💥 Now, organize your data clearly in Excel and become a true productivity pro 😉

This course will teach you how to use Excel Pivot Tables to quickly and easily analyze data and create dynamic automated reports in your daily life and practice. Pivot Tables are easy and powerful. Through this course, you can begin the process of solving problems through data analysis.

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.

This course is not a training course that explains the functions of Excel, but a course that uses Excel examples used in actual work settings to learn which functions to apply in each situation to perform tasks most quickly and efficiently.

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.

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.

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 the principles and usage of DAX, which is essential for advanced analysis using Excel Power Pivot, and learn major DAX functions.

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.

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

In the [Beginner's] Data Visualization with Power BI course, you will learn how to edit data using the query editor, visualize data using various tools, and check and share the analyzed results.

Learn the basic features to easily use Visio 2013. Also, learn how to use Visio like Visio by comparing it to office tools and learn about compatibility features with other programs to increase work efficiency.

With Visio, you can quickly and easily draw and utilize various diagrams to visualize various management data, apply them to work, and start optimal visual management.

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

Understand how to effectively analyze and visualize data using Power BI, a data analysis and visualization tool from Microsoft.

Visualize and present the overflowing public data skillfully using the most common and familiar Excel and PowerPoint.