Easy-to-follow Excel 2013 Find/Reference Functions

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.

Introduces new features in Excel 2013 and helps you develop Excel's basics and business application skills by learning data entry, table creation, function utilization, data management and analysis, chart creation, and data visualization using conditional formatting.

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.

You can learn new features in Word 2016, create various practical documents, and acquire effective ways to use Word 2016.

Using Excel 2016, you can learn how to enter data, create tables, use functions, manage and analyze data, create charts, and visualize data using conditional formatting, so that you can develop Excel's basics and business application skills.

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 use Power Query, an add-in to Excel, to analyze large amounts of data more quickly and efficiently, and automate repetitive data tasks.

You can learn how to solve difficult problems you encounter while working with Word and learn useful tips to increase your work efficiency.

We provide easy and systematic instruction centered on 100% practical training so that all students can utilize the project at an expert level. We provide practical project management methodologies and various cases to increase students' confidence and determination in the success of the project.

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 build a collection system and GTD methodology to integrate the flood of information into one, and how to apply classification and processing of collected information to Outlook and OneNote.

Improved features in OneNote 2013 help you get your work done more easily, faster, and anywhere, anytime.

Learn about all the features that allow you to work with information, from understanding the work environment of OneNote 2016 to organizing, recording, and utilizing notes.

This article introduces the basic usage of Outlook 2013 for efficient mail, calendar, people information, tasks, and notes, and introduces features that are linked with Microsoft accounts, SharePoint Server 2013, and OneNote 2013.

Learn about the new features in Outlook 2016 and useful functions you can use for work.

Access is a tool that allows you to create databases. Unlike Excel, it is very easy to standardize simple or repetitive tasks. Even without programming knowledge, it is possible to display ‘dialog boxes’ and corresponding reports. Also, since it is a database, it can handle relatively large amounts of data easily and quickly.

Master the overall features of Access 2016, learn how to build databases, and manage data effectively.

Let's explore how to automate long documents using styles and multi-level numbering, which are core features of MS Word.

You can learn how to use Excel 2016 to search for or retrieve the data you want in various work situations.

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.

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.

Are you using Excel to apply for and manage vacation/annual leave? 🤔 Stop asking your manager about your annual leave every time! Create a vacation application and management system for your company through this lecture.

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.

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.

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

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

Forget about the difficult Korean language automation that has been going on so far! Just follow along and you will complete the automation program.

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

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

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.

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

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