インフラン - ライフタイムキャリアプラットフォーム

We introduce the main features and usage methods of Hangul 2022. We will explain through various examples from the basics to advanced document writing.

ITQ Excel National Certification Key Summary Lecture to be Obtained in Two Days of Weekend! 4 Mock Exams and Special Lecture on Functions Provided Separately!

Even those with no coding experience can automate Google Sheets and Apps Script tasks! I will teach you the easiest way by creating examples that can be used in actual work.

A course that covers how to conveniently handle work using the macro recorder without the burden of VBA coding! You can understand how to utilize macros in various ways through practice of simply converting data accumulated in the company into an Excel database and building a search system to find it.

This course will help you make the most reasonable business decisions through data, from data connection to data visualization. Completely master Power BI data analysis and visualization that will lead to valuable insights!

How to vlookup data scattered across multiple files without moving the sheet? How to add data that is not in the original data to the pivot table? How to merge files in one folder at once? How to process more than 100 million data in a worksheet? If you can't think of an answer, take this course.

Are you writing proposals like reports, one by one, under pressure from time to time? Then, why not reorganize the proposal process, organization, and proposals so that you can lead the entire season to victory?

You use 'pivot tables' a lot for data analysis, right? However, Excel provides various analysis tasks that are suitable for the situation in addition to pivot tables. In this lecture, we will organize Excel analysis tasks in 10 ways (sorting, subtotals, pivot tables, pivot charts, target value search, data tables, scenario managers, integration, advanced filters, conditional formatting)

If you are an office worker, you have probably experienced worrying about making a chart at least once. If you are confused about when and what chart to use and how to make it, I will give you a refreshing answer.

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!

By looking at examples of documents in each field that the instructor has processed, you will practice developing a perspective on viewing documents.

Learn how to use office programs (Excel) required by business practitioners and acquire work processing skills suitable for the work environment.

There are many things that are happening through non-face-to-face methods, such as non-face-to-face work, non-face-to-face services, and non-face-to-face meetings. In order to continue business, meetings must continue. If you have done seminars/broadcasts through Live Events, this lecture will now teach you how to conduct online video or audio conferences through Teams Meeting.

Many data are scattered all over the place, such as NAS, external hard drives, and drives, and can be accessed without specific permission management. In addition, various calendars are used to work together and additional emails are sent. The reality is that it is difficult to develop a separate collaboration site that is absolutely necessary for the company, so it is used like this. You can create a collaboration site including an intranet that replaces the file server and various services you are using through Microsoft's SharePoint. Learn how to do it through the lecture!

This lecture teaches how to generate images using DALL-E3 (DALL-E). Through basic functions, a 3-step prompt strategy, and hands-on image generation practice, participants can become creative image creators.

From basic functions to high-level practical documents used in the field and sensible design know-how, give wings to your documents with PowerPoint 2013!

From basic functions to high-level practical documents used in the field and sensible design know-how, give wings to your documents with PowerPoint 2016!

This content provides a practical guide to effectively utilizing generative AI for public institutions and non-profit organizations. It is designed to provide step-by-step specific application cases such as information summarization, document creation, and work capability improvement, starting from the basic principles of working with generative AI, so that learners can immediately apply the utilization method suitable for each situation.

This content will teach you the basics of how to visualize data using Power BI. It is structured so that even non-data experts can easily check and follow along.

Excel 2021 Practical Super-fast Master Class covers 6 key tips and features to help practitioners maximize their work efficiency and get off work early. Quickly acquire all the essential skills of Excel, from data processing, editing, formatting, calculation, analysis, and visual effects through this course.