[Wang Dumok] Computer Literacy Level 1 Written Exam 2025

Are you preparing for the 1st level of Computer Proficiency? If so, try it out easily, quickly, enjoyably, and pleasantly with Wang Du-mok, a teacher with 20 years of experience.

Provides solutions for all past Industrial Engineer Information Processing written exams, from the 2020 revision until the CBT exam.

We have prepared everything for you to pass the Information Processing Engineer written exam. With an investment of just 30 hours, you can pass the Information Processing Engineer written exam.

Make Excel and Access professional level by taking the opportunity to obtain a qualification that is highly useful in practice! If you have passed the 2nd level, why not challenge the 1st level?

This lecture provides solutions to past exam questions for the Information Processing Industrial Engineer written exam prior to the revision. In this lecture, you can check how the exam questions are presented.

This lecture is for studying Database Utilization, the third subject of the Information Processing Industrial Engineer written exam.

This lecture is for studying "Programming Language Utilization," the second subject of the Information Processing Industrial Engineer written exam.

This course studies information system-based technology, one of the written subjects for the Information Processing Industry Engineer exam.

We aim to enhance business skills by using Excel, a core tool, to improve work efficiency and enable differentiated form creation. This goes beyond simple formula-based Excel use, teaching how to easily, professionally, and efficiently produce necessary business forms.

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

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

Through this course, learners can develop the ability to obtain a Computer Application Skills certification. This course is structured according to the examination standards as a preparation course for acquiring the Computer Application Skills certification. You can learn and apply basic knowledge of Computer Application Skills subjects to prepare for certification acquisition. (Computer Application Skills Level 1 & 2 Written Exam - Spreadsheet General)

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

You know the importance of 🔥Big Data🔥 in business, but have you given up before even starting because of difficult-sounding data analysis tools like Python, R, and SQL? Don't worry anymore😉 This is a course for beginners to learn how anyone can analyze data and discover valuable insights using the highly accessible Excel!🎁

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

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

Analyzing customers, markets, and revenue patterns—you no longer need to learn it yourself. Just ask AI, and expert-level analysis and strategies are completed in an instant!

Don't learn Excel the hard way. The questions that appear on the ITQ exam are already predetermined. With the 'guaranteed exam formulas' extracted from 25 years of teaching big data, we guide you on the fastest shortcut to achieving an A grade in just 2 weeks, even with no prior experience.

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.

This is not a course focused on VBA grammar. This is a course that will help you understand the entire structure of VBA at a glance.

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

Through this course, learners will be able to acquire the skills necessary to obtain a Computer Application Skills certification. This course is structured according to the examination standards for obtaining the Computer Application Skills certification. You can learn and apply fundamental knowledge of Computer Application Skills subjects to prepare for certification acquisition. (Computer Application Skills Level 1 & 2 Practical - Spreadsheet Practice)

AI Excel that automates perfectly for your tasks without any company security concerns. From data preprocessing to visualization, everything is OK in just a few minutes—without any coding knowledge!

Data Analysis that Determines Online MD Performance! Learn essential data analysis and strategy formulation techniques necessary for MDs to maximize sales and profit in the e-commerce market.

Artificial Intelligence is transforming the way professionals work with data. Microsoft Copilot in Excel allows you to analyze, clean, format, automate, and optimize spreadsheets faster than ever before. But using Copilot effectively requires more than just typing prompts — it requires understanding Excel fundamentals, structured thinking, and prompt engineering. This course gives you exactly that. You will learn how to combine Excel expertise with AI-powered automation to dramatically improve productivity, accuracy, and workflow efficiency. What You Will Gain From This Course • Save hours every week using AI-driven Excel automation • Analyze large datasets in seconds using Copilot • Clean and fix messy data effortlessly • Write powerful formulas with AI assistance • Master prompt engineering for Excel Copilot • Build professional reports and dashboards faster • Improve decision-making with AI-powered insights • Optimize workflows for real-world business scenarios By the end of this course, you will not just “use” Copilot — you will control it. What This Course Covers Foundations What is Microsoft Copilot How to activate and use Copilot in Excel Introduction to Excel basics and navigation Data types and conversions Data entry and validation techniques Excel Core Skills Mathematical, logical, and time functions Nested functions for complex calculations Combining logical and LOOKUP functions Conditional statements and formatting Pivot tables and advanced formatting Data Analysis with Copilot Data general analysis and Q&A Sorting, filtering, and profiling data Handling and fixing missing data Identifying and correcting common data errors Transposing data for trend analysis Date-time formatting techniques AI-Powered Excel Automation Generating synthetic data Adding formula columns with Copilot Subtotals and advanced calculations Optimizing workflows using Copilot Enhancing data presentation Editing spreadsheets intelligently Prompt Engineering for Excel Copilot Writing effective prompts Advanced prompt engineering techniques Evaluating prompt performance Optimizing prompts for better results Customizing Copilot for improved outcomes Real-World Application Creating a travel budget using Copilot Practical exercises and activities Performance evaluation and improvement strategies Why This Course Is Different Most Excel courses teach formulas. Most AI courses teach theory. This course bridges both. You will learn Excel fundamentals and advanced skills alongside AI-powered Copilot usage. That combination makes you significantly more productive than someone who only knows Excel or only knows AI prompts. This course is structured for clarity, practical application, and real-world efficiency. Who This Course Is For • Business professionals who work with Excel daily • Data analysts and aspiring analysts • Managers who want faster reporting • Students preparing for corporate roles • Entrepreneurs handling business data • Anyone who wants to leverage AI inside Excel No prior AI experience is required. Excel basics are covered before advancing into automation and Copilot optimization. Why You Should Enroll Today Microsoft Copilot is becoming a core productivity tool across organizations. Professionals who understand how to use AI effectively inside Excel will have a measurable competitive advantage. Instead of spending hours writing formulas, cleaning data, or building reports manually, you will learn how to work smarter. If you want to future-proof your Excel skills and become significantly more efficient with data, this course is for you. Enroll now and master Microsoft Copilot in Excel with confidence.

This is a practice-oriented course designed to increase work efficiency by automating repetitive Excel tasks with Python. You will learn how to automate the entire workflow—from opening files to data processing, inspection, consolidation, and saving—and will also be provided with practical automation code using pywin32.