오피스 마녀의 엑셀 레시피 - 그걸 왜 몰라?

Are you familiar with Python now? Python is the most widely used language for collecting, analyzing, and utilizing data. If you want to use Python for data science, today's lesson will be really helpful. We will install and use Python modules and packages, aka libraries, related to data science.

Python, now you're doing it? Then, can you implement GUI using PyQt in Python? In order to implement GUI using Python, I've included only the most necessary content, focusing on the most frequently used syntax in actual development sites, utilizing the package PyQt.

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!

What do you do with Excel? Sorting and filtering the data that pours in? What do you do when your team leader suddenly wants data? You want a lot of data, and you are always busy and waste time, right? Have you heard of pivot tables? You may have even used them. But! Pivot tables are easier than you think, and there are more hidden functions. Here is a secret that will drastically reduce the time you spend handling, analyzing, and organizing data.

The basics of database! We will help you to clearly understand the concept of your DB. We will help you not to get lost in any study related to database in the future.

It contains only the most essential content, focusing on the most frequently used phrases when doing web crawling in the field. Once you learn it, you can use it in many different ways.

Learn Python easily and quickly with patterns. Learn only the essentials in a concise manner 💪

Rather than a boring and obvious Python lecture, we've collected the most frequently used Python patterns in the field.

Are you working overtime because of Excel? Or are you having trouble getting your work done because of an error? For you, I have prepared 10 really, really useful tips for using Excel!

Are you working overtime because of Excel? Or are you having trouble getting your work done because of an error? For you, I have prepared 10 really, really useful tips for using Excel!

What do you do with Excel? Sorting and filtering the data that pours in? What do you do when your team leader suddenly wants data? You want a lot of data, and you are always busy and waste time, right? Have you heard of pivot tables? You may have even used them. But! Pivot tables are easier than you think, and there are more hidden functions. Here is a secret that will drastically reduce the time you spend handling, analyzing, and organizing data.

Since the company does not have a separate system developed, tasks such as requesting business cards, registering external visitors, and managing parking requests that require time-consuming manual processing via email and paper printing are managed through a system created using SharePoint+List+Forms and automated with Power Automate.

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

Excel VBA helps you use Excel faster and more efficiently. Now, learn VBA to spend your free time at work. For web data collection, please refer to this course: https://www.inflearn.com/course/python-crawling#

A class on analyzing customer/sales data with Excel, even without R or Python!

Covers how to properly use the new game-changer "ChatGPT" for "Excel utilization." You can learn to create Excel formulas for practical use, easily grasp Excel functions, and write macros and VBA code using ChatGPT.

Data-based decision-making ability, an essential competency in the era of digital transformation! As companies rush to find talent with digital capabilities, develop BA capabilities to successfully solve organizational problems through this course!

Through this course, learners can acquire the ability to obtain a computer proficiency certificate. It is a course for obtaining a computer proficiency certificate, and it is structured in accordance with the examination criteria. You can learn and utilize basic knowledge of the computer proficiency subject to prepare for obtaining the certificate. (Computer Proficiency Level 1, 2 Written - Spreadsheet General (2021 Revised))

1. You may experience the side effect of thinking about VBA codes while sleeping. 2. You may become a workaholic by choice due to the desire to automate repetitive Excel tasks one by one.

Even complete beginners who don't know anything about Excel are OK! Just follow the lectures and you can get an A grade in ITQ Excel.

Through this course, learners can acquire the ability to obtain a computer proficiency certificate. It is a course for obtaining a computer proficiency certificate, and it is structured in accordance with the examination criteria. You can learn and utilize basic knowledge of the computer proficiency subject to prepare for obtaining the certificate. (Computer Proficiency Level 1, 2 Practical - Spreadsheet Practice (2021 Revised))

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.

ITQ PowerPoint national certification key summary lecture that can be obtained by utilizing two days of the weekend! 4 mock exams and real-time mock exam solution videos provided

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