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!
14 learners
Level Basic
Course period Unlimited
Reviews from Early Learners
5.0
히릿
I realized that just by cleanly structuring prompts, most tasks can be automated~ I recommend this for anyone who wants to reduce their work hours!
5.0
애기손 파이
It's so great that I can utilize AI without carelessly uploading company data. I highly recommend it!
5.0
일찍일어나는새가벌레
ChatGPT handles all the data analysis for me, which is really convenient and great 😊
Complete all data analysis in the familiar Excel environment without complex programming languages
K-means clustering, correspondence analysis, RFM, and other carefully selected analysis skills that can be used in practical work
From data visualization to chart creation, super simple automation that's done just by pasting AI-generated VBA code into Excel
Mastering Practical Data Analysis: Adding AI to Familiar Excel While Maintaining Internal Security for Easy Learning
No need to learn customer, market, and revenue pattern analysis yourself anymore.
Just ask AI and get expert-level analysis and strategies completed in an instant!
Just input your data into Excel.
AI will handle clustering, regression analysis, and visualization for you.
Complete professional-level data analysis without any coding!
– From clustering to ARIMA time series forecasting with Excel only, no coding required
– Complete mastery of core analysis techniques including customer segmentation, persona definition, and RFM
– Automated chart creation without data upload using VBA automation
If you want to become someone who speaks with data, now is your chance.
Transform yourself into a data strategist with Excel + AI!
A practical course that completely masters real-world data analysis by adding AI to familiar Excel while maintaining internal security, making it easy to learn.
1. Just Excel needed, zero Python installation
Nocomplex programming languages - complete all data analysis in the familiar Excel environment
2. 'Ready-to-Use' Model Practice from Customer Segmentation to Market Analysis
Carefully selected and taught only the analysis skills you can use in practice, including K-means clustering, correspondence analysis, and RFM
3. AI automatically writes VBA code, you just check the results
From data visualization to chart creation, super simple automation that's complete just by pasting AI-generated VBA code into Excel
4. Accurately Derive Desired Results with Structured Prompts
Master the art of commanding AI through examples, from utilizing markdown and symbols to prompt design principles
5. Complete Time Series Model for Sales Forecasting and Trend Analysis
Automatically generate prediction models and graphs using actual sales data with ARIMA, Exponential Smoothing, and Linear Regression
Don't put off data analysis anymore because it's difficult!
AI completely lowers that barrier to entry.
It's an era where both customers and markets are understood through data!
Stuck on installing Python, statistical terms too difficult... Now with AI, no more worries!
– Office workers who have accumulated data but don't know how to analyze it
– Marketers/planners who need data-driven decision making but don't have time to learn Python
– Sales representatives who need to utilize data for strategies like customer segmentation and sales forecasting
– Strategy managers who want to increase persuasiveness with data-driven reports
– Anyone who wants to gain competitiveness through data analysis skills
Have you ever imagined the moment when data you've only been piling up becomes a strategy?
With Excel and AI, that moment is right now.
STEP 1. Building the Foundation of Excel-Based Data Analysis
Master clustering to time series forecasting step by step using only AI prompts in the familiar Excel environment
STEP 2. Master Advanced Analysis Techniques Previously Only Possible with Python, Now Fully Conquered with AI
Practice and immediately apply difficult models such as clustering, correspondence analysis, regression analysis, and ARIMA
STEP 3. Maximize Productivity While Maintaining Security with Structured Prompts and VBA Automation
Improve AI accuracy using markdown and symbols, and complete visualization with one click through VBA auto-generation without uploading data
STEP 4. Generate a report that connects analysis results to insights and strategies
Creating reports that flow seamlessly from visualization → interpretation → insights → strategic recommendations
STEP 5. Complete Collection of Practical Cases for Immediate Use in Your Work
Build practical skills with real-world cases that can be immediately applied to actual work, such as market positioning and network analysis
Experience analysis where AI sets the direction and Excel executes it.
If you can open Excel, that's all you need!
Experience for yourself how easy analysis can become from now on.
Q. Do I need prior knowledge of artificial intelligence to take this course?
A. This course is designed to provide practical skills that anyone interested in artificial intelligence can immediately apply in their work, so no prior knowledge of artificial intelligence is required.
Q. Are there any requirements or prerequisites for taking this course?
A. No special prior knowledge or skills are required to take this course. However, having a Google account will help you access the generative AI tools more smoothly during the course. If you don't have a Google account yet, we recommend signing up before the course for a seamless learning experience.
Q. Do I need to subscribe to ChatGPT's paid plan to take this course?
A. Subscription and payment are not essential for taking the course. While some features introduced in the course may require payment, the primary goal of this course is to help you gain insights on how to apply the diverse and specific AI practical skills covered in the lectures to your own work.
Since this is a hands-on course, it would be helpful to prepare a dual monitor setup or an extra device so you can separate the lecture screen from your practice screen.
Additionally, since the practice sessions are conducted on Windows OS, we recommend taking the course in a Windows environment.
Who is this course right for?
Data is piling up, but office workers are sitting idle because they don't know how to analyze it
Marketers/Planners Who Need Data-Driven Decision Making But Don't Have Time to Learn Python
Sales representatives who need to utilize data for strategy development such as customer segmentation and sales forecasting
Strategy managers who want to increase persuasiveness with data-driven reports
Need to know before starting?
If you have a Google account, you'll be able to access generative AI tools more smoothly during the course. If you don't have a Google account yet, we recommend signing up before the course begins for a seamless learning experience.
9,318
Learners
1,309
Reviews
113
Answers
4.7
Rating
98
Courses
"어제보다 성장하겠습니다. 그리고, 어제보다 성장하려는 사람을 돕겠습니다."
마소캠퍼스의 진심과 소망을 담은 Actionable Content로,
2013년부터 온오프라인으로 함께해 온 누적 강의 1억시간!
이 소중한 경험과 시간은 언제나 마소캠퍼스와 수강생 모두의 성장의 원천입니다.
마소캠퍼스 팀은 우리의 모두의 성장을 위해 두 가지 원칙을 반드시 지킵니다.
1. 배우면 반드시 쓸 수 있는 Actionable Content
2. 참여자의 시간과 수고를 존중하는 Time-Saving Curriculum
마소캠퍼스의 Actionable and Time-Saving Curriculum으로 성장의 길을 함께 걸어나가길 기원합니다.
All
19 lectures ∙ (6hr 44min)
Course Materials:
All
6 reviews
5.0
6 reviews
Reviews 27
∙
Average Rating 5.0
Reviews 16
∙
Average Rating 5.0
Reviews 23
∙
Average Rating 5.0
Reviews 8
∙
Average Rating 5.0
Reviews 21
∙
Average Rating 5.0
$61.60
Check out other courses by the instructor!
Explore other courses in the same field!
![[Pass ITQ Excel A in One Go] in 3 days강의 썸네일](https://cdn.inflearn.com/public/courses/329652/cover/b44e11b6-a47e-4993-86ea-a85da9836bb5/329652-eng.png?f=avif&w=420)
