Follow along as an Excel beginner, and you’ll create a weekly report dashboard with accurate numbers.

This course selects only the essential content that can be applied immediately in practice, providing a kind and easy-to-follow process that helps you use Excel as naturally as your own hands to increase work efficiency.

The Computer Literacy Exam (COM-HWAL) written test is no longer difficult! We have summarized only the core points so that anyone can understand them easily. With this lecture, passing in a short period is definitely possible. Start right now!

This is a practical lecture designed for passing the ITQ Excel Grade A exam in a short period. You will master the four-step process—from data entry to pivot tables and charts—and learn time-saving skills to finish with 15 minutes remaining in the 60-minute exam. Rather than rote memorization, you will understand functions through intuitive pattern matching and complete your Excel skills to be immediately applicable in real-world tasks.

To help those who want to do well in the new year of 2025, we have updated it to the latest version. Learn how to create and manage projects, teams, and your own tasks using MS Planner and become a "professional worker🤩".

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.

[Problems This Course Solves] - The limitations of planners who have ideas but cannot build them directly - Inefficient decision-making based on imagination: "Please make it like this" - Bottlenecks caused by requesting and waiting for the development team for every data analysis or API verification - The reality of using AI tools but remaining at the level of simple ChatGPT Q&A [What You Will Learn] 1. Redesigning the Planning Process in the AI Era - Traditional: Planning → Design → Development (Sequential waiting) - Shift: Writing PRD → Generating Prototype → Decision-making based on the actual product → Delivery after confirmation - Moving from planning explained through documents to planning demonstrated through actual products 2. Designing AI Agents for PMs - Harness Engineering: Designing a working structure rather than just asking AI questions - CLAUDE.md, Rules, Hooks, MCP, Plugins — The roles and design principles of each layer - Agent Router: A structure where a single request is automatically assigned to the optimal agent - PGE Pipeline: Planner → Generator → Evaluator, quality control design for large-scale tasks 3. Building Your Own AI Team - Planning/Research, Product, Design, Development, Marketing — 20+ agents across 5 columns - Actual workflows where a solo planner manages a team of experts - Connecting external tools via MCP (Notion, Figma, Slack, data sources) - Automating repetitive tasks with one-command "Skills" 4. Practical Automation of Supplementary Tasks - GA4 + Clarity + GSC + BigQuery → Integrated dashboard + automatic weekly insight generation - Direct calling of in-house APIs → Scenario verification → Quality evaluation reports - BigQuery cohort analysis → Aha Moment hypothesis verification - A/B testing, Notion synchronization, UI/UX audit automation --- Who should take this course: - PM/PO/Service Planners tired of waiting times and review cycles in the planning process - Those who want to properly design AI as a professional work tool - Those who want to make data-driven decisions themselves but lack analysis team resources - Non-developers who want to move past their fear of the "terminal" [Prerequisites] - None. We guide you through everything from installation to setup. - No coding experience required. We focus on design and application from a PM's perspective. [Changes After Taking the Course] - Increase decision-making speed by creating working prototypes directly from a single PRD.md - Design and operate your own team of AI agents - Directly automate data analysis, API verification, and report generation

Are you still using Google Sheets simply like Excel? If you use Google Sheets properly, you can significantly reduce the time spent on collecting data through copy-pasting, getting confused by the latest files, and fixing formula errors. Try automatically operating reports and dashboards that are always up-to-date based on real-time data connections.

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

Even complex data becomes clear at a glance with Tableau! From a single drag to a finished dashboard, master data visualization for real-world business.

Experience Google's integrated smart work innovation. Start right now. 1. Gmail: The Center of All Communication Gmail is not just a simple email service. It's a 'communication hub' that organically connects with all of Google's collaboration tools. While checking emails, you can immediately add events to Google Calendar, save received files to Google Drive, and start quick conversations with Google Chat. Its powerful search function instantly finds any past content, ensuring work continuity. - Core Features: Drive file attachment, Calendar event creation, Meet video conference initiation, Chat integration 2. Google Drive: Secure Cloud Storage Google Drive is a secure 'online drawer' that stores and manages all documents, images, and videos. You can access the same files from computers, smartphones, and tablets anywhere, and simply share a single link with colleagues. No more need to compress large files and send them via email. You can set folder-specific access permissions for systematic and secure file management. - Core Features: Cloud file storage, sharing and synchronization, Docs/Sheets/Slides file creation 3. Google Docs: Real-time Collaborative Document Work Google Docs is an innovative word processor that allows multiple people to edit 'one document simultaneously'. You can see in real-time who is editing which part, and complete documents by exchanging opinions through 'comments' and 'suggestions' features. All modifications are automatically saved, and you can return to any previous state through version history, eliminating concerns about document loss. - Core Features: Real-time collaborative editing, comment and suggestion features, version history checking, automatic Drive saving 4. Google Sheets: Creating Data Together Google Sheets is an 'online Excel' that allows complex data analysis and visualization work with team members. From organizing various data to calculations using functions and chart creation, all team members can share and edit the latest data in real-time. When integrated with Google Forms, survey responses are automatically organized in sheets, making data compilation very convenient. - Core Features: Simultaneous data editing and analysis, function and chart features, survey response integration 5. Google Slides: Collaborative Planning Presentations Using Google Slides, you can gather ideas with team members to create 'one complete presentation'. Each person can work on their assigned slide parts simultaneously, and use comment features to give each other feedback to enhance presentation quality. You can easily insert YouTube videos or Google Sheets charts to create rich content presentations. - Core Features: Collaborative presentation creation, YouTube video and Sheets chart insertion 6. Google Meet: Simple Video Conferencing Google Meet is a 'high-quality video conferencing solution' that allows face-to-face meetings with team members anytime, anywhere. When you schedule meetings in Google Calendar, participation links are automatically generated for easy attendee access. Screen sharing features allow discussing presentation materials or work together, enabling efficient collaboration even in remote work environments. - Core Features: Calendar schedule integration, screen sharing, high-quality video and audio support 7. Google Calendar: Team Schedule Sharing and Management Google Calendar is a core tool that goes beyond personal scheduling to 'manage the entire team's time'. You can subscribe to colleagues' calendars to check each other's schedules and easily find available meeting times. When creating events, you can add video conference links (Meet) and attach related documents (Docs) to manage all meeting information in one place. - Core Features: Schedule management and sharing, meeting booking, Meet video conference integration 8. Google Keep: Capturing Fleeting Ideas Google Keep is a 'digital sticky note' that helps you not miss suddenly occurring ideas or simple tasks. It supports not only text but also images and voice memos, and you can create checklists to manage work. Written notes can be easily transferred to Google Docs or Slides, allowing systematic development of ideas. - Core Features: Quick note taking, idea capture, task management, Docs/Slides integration 9. Google Sites: Easy Website Creation No coding knowledge needed. Using Google Sites, you can simply create 'team project websites' or information sharing pages just by dragging and dropping with your mouse. You can easily insert various Google services like Google Drive documents, Calendar, and Maps into web pages to collect and manage all project-related information in one place. - Core Features: Simple website creation, Drive/Calendar/Maps content insertion 10. Google Photos: Memories and Materials in One Place Google Photos goes beyond being a space for storing personal memories to become a 'smart image hub' for sharing and managing team visual materials. You can create shared albums for project progress, event photos, design drafts, etc., and manage them together with team members. Powerful AI search functions allow you to easily find desired images like 'last week's meeting whiteboard photos'. - Core Features: Team shared album creation, AI-based image search, secure cloud backup 11. YouTube: The Most Powerful Visual Resource YouTube is not just a video platform, but a vast 'visual resource library' that can be utilized for work. You can directly insert product demos, educational videos, webinar recordings, etc., into Google Slides or Sites to make presentation materials and team pages richer. Internal training videos can be uploaded as unlisted to safely share only with specific team members. - Core Features: Video insertion into Slides/Sites, private internal training video sharing 12. Google Maps: Location-based Collaboration Google Maps goes beyond navigation to become a 'location-based visualization tool' that adds spatial context to business. Using the 'My Maps' feature, you can customize and share client locations, sales management areas, field survey routes, etc., with team members. When these maps are inserted into Google Sites, all team members can intuitively understand project-related location information. - Core Features: Custom map (My Maps) creation, project-related location visualization, Site integration 13. Google Translate: Breaking Language Barriers Google Translate is a 'reliable communication partner' that breaks down language barriers in an era where global collaboration is essential. You can easily translate emails exchanged with foreign partners and overseas market research materials to speed up work. Particularly, using the translation feature within Google Docs allows you to easily convert entire documents to other languages for efficient multilingual material management. - Core Features: Multilingual document/email translation, global collaboration support, direct in-document translation Now you understand that Google's collaboration tools are not just a collection of simple functions, but one powerful ecosystem organically connected together. Becoming a 'Google utilization expert' means going beyond simply knowing how to use various apps to acquiring problem-solving abilities that innovate work processes themselves through integrated utilization of these tools. Through capabilities to compile data in real-time, lead borderless collaboration, and quickly materialize creative ideas, you can become a 'smart work designer' who performs core roles in any team. Jump onto the Google ecosystem right now and complete your digital collaboration capabilities, the most certain competitive advantage for an unpredictable future!

Data-driven decision-making, an essential skill in the era of digital transformation! As companies are going all out to find talent with digital capabilities, develop your BA skills to successfully solve organizational problems through this course!

A practical AI automation series that plugs directly into your work If you’ve learned about AI but still feel unsure how to use it in your work, what you need now isn’t an explanation of features, but practical ways to use AI that immediately transform your work. The SMART WORK ORDER series is a hands-on AI automation series designed to reduce repetitive tasks across roles—including marketing, planning, HR and general affairs, sales, customer support, data analysis, and team leader and manager responsibilities—and turn them into real work deliverables. Content drafts, meeting minutes, proposals, consultation scripts, FAQs, VOC reports, data analysis reports, team prompt libraries, and more. Each course is designed not as a “lecture you watch and understand,” but as a hands-on program where you follow along and create actual deliverables. The prompts and templates you learn today can be applied to your work tomorrow, expanding into practical assets that improve not only individual work speed but also team productivity. An AI-powered transformation of work that reduces repetitive tasks and raises the quality of deliverables. SMART WORK ORDER is a role-specific, practical AI program that changes the way you work to make it faster, more accurate, and smarter.

We transform distribution reports that merely list numbers into a single page that supports decision-making. Drawing on 24 years of experience in distribution operations and headquarters, we use Excel and AI to analyze changes in sales and contribution margin and examine hypotheses about their causes. By calculating simulated distribution data ourselves, we complete performance reports containing key conclusions, execution conditions, and approval requests.

This course introduces how to efficiently manage project schedules using ProjectLibre, a free-to-use open-source tool. As an alternative to MS Project, it allows for more systematic integrated management of schedules, resources, and costs than Excel. Furthermore, because it is similar to MS Project, completing this course will allow you to quickly adapt to MS Project in the future. This course uses a practical, follow-along approach that enables anyone to easily create a real-world project schedule. If you want to enhance your scheduling capabilities and increase the likelihood of project success without any cost burden, be sure to take this course! * Version used: 1.9.8 Windows version

Data is piling up, but are you feeling lost about who to target? Find your key customers through data summarization and design the optimal targeting logic.

Copilot Chat will become more than just a simple AI assistant - it will be your reliable work secretary that maximizes your productivity and creativity. In this course, learn Copilot Chat's core features and usage methods, practical cases that can be applied immediately to real work, and customized tips tailored to each task, and start experiencing how your way of working changes with Copilot Chat!

Python + xlwings Work Automation Course Summary 1. Basic Section: Excel Control Fundamentals Cell Handling / Format Application / Image & Chart Insertion 2. Application Section: Automation Scenarios Automatic Email Sending / Report Summary Automation (LLM) / Image Classification Tasks (Teachable Machine)

This course teaches you how to save time and maximize work productivity using NotebookLM.

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

This course is for those who want to use JIRA to perform team work more efficiently. It explains the basic background knowledge for using JIRA, project creation, management, issue registration/management, and helps you understand the agile project execution lifecycle such as Scrum and Kanban and apply it to actual work.