Excel Data Visualization | Everything About Business Charts & Graphs

A 2-hour data literacy introductory course for marketers who give up on math and whose minds go blank when they see numbers

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.

Reading data turns it into money! Even a receipt that would otherwise be thrown away can lead to sales. If you want to turn the data that fills your daily life into results, improve your data literacy.

Is it possible to automate Excel without uploading company data? AI utilization secrets revealed that maintain security while reducing work hours!

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

Search Engine Optimization & Google Analytics Mastery is a practical, results-focused program designed to help you grow websites through organic search and measure performance with precision. This bundle combines SEO strategy, Google Analytics 4, and Google Tag Manager to give you a complete system for attracting the right traffic and making informed decisions based on real data.

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!

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

This is a special lecture that can lay the theoretical foundation to simultaneously prepare for the Microsoft AZ-900 certification, and as the latest content reflecting the scope of questions as of May 2025, by providing content related to core data concepts, Azure's relational data, Azure's non-relational data, and Azure's analytical workloads in a form combining theory and practice, it can be utilized as a meaningful educational opportunity to not only obtain the certification but also take the first step towards becoming a data professional.

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

We'll take a very practical and easy approach to cost accounting and management analysis using Excel, which you may have found difficult before. This course covers the following topics: - Cost Accounting from Basics to Practice: Step-by-step learning from cost concepts, standard costs, actual costs, to indirect cost allocation - Understanding Financial Statements and Accounting Flow: From manufacturing cost flow to accounting treatment and financial statement generation process - Strategic Pricing Methods: Pricing strategies by market type and profitability analysis by product - Analyzing Management Indicators with Excel: Break-even point analysis and financial ratio analysis practice - Management Decision-Making Based on Management Accounting: Short-term/long-term business planning and business feasibility analysis practice

Let's analyze and visualize data and learn machine learning concepts using Orange 3!

This is a course for PMs who want to utilize data. This course covers the entire process of utilizing data in the PM role, including the flow of work from day 1 of a job change through the start and end of a project. It is an introductory data course that covers data-driven thinking, logical thinking, metric definition, log design, experiment design, creating a data culture, and more, to help you develop critical thinking skills. Although created as a course for PMs, it is structured with content that data analysts would also find beneficial (in fact, many analysts have taken the course). In addition, many people in marketing, design, and business planning roles are also taking the course.

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!

We provide an Excel template and instructional video for calculating product costs for your company. Ready for immediate practical application.

Learn Macro VBA with Excel 2019!! However, you can also practice with 2016 and 2013 versions. Macros and VBA fill in the gaps that Excel alone lacks.

Forget boring theories! We're going straight into practice from the beginning of the lecture. Once you start, you'll be captivated by the charm of Excel Macro VBA that you won't be able to stop~!

Repetitive pipeline management in Data Warehouses (DW), now free yourself from that painful cycle with dbt! Building on the efficiency provided by dbt, become a data analytics engineer who creates higher value through business-centric data modeling, effective data lifecycle management, and more.

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.