Excel Data Processing 'Copy-Paste Techniques' for Those Who Can't Build Macros
"I can't build macros, so I have no choice but to do this massive data reconciliation and monotonous work by hand." — Are you thinking that? Mr. Aoki, an AI instructor at YouWorld, is a professional who has promoted rock-solid system development and project management (PMO) for 21 years at companies like the Hitachi Group. Without using any advanced techniques like macros or programming, he teaches an innovative data processing method that allows you to finish daily Excel tasks in just a few minutes by simply 'copying and pasting into AI'.
The evolution observed since the days when AI was still 'not useful'
It was about a year and a half ago that Mr. Monzen volunteered to be the company's AI promotion leader and began utilizing it. At first, the accuracy of the AI was not yet sufficient, and when trying to roll it out company-wide, he faced a harsh wall where it would even get the company president's name wrong. However, Mr. Monzen has continued to calmly assess the speed of its evolution.
At the beginning of 2025, the accuracy of AI responses was still inconsistent. When we were considering a company-wide rollout, many employees tried searching for 'our company president's name' as a test, but the AI gave off-target answers, and there was a history of the project being stopped once because 'it's still difficult to introduce this company-wide.' At that time, it wasn't linked to internet searches and relied only on past training data, so the answers were unstable. However, now it returns information with almost the expected accuracy for the information we request. From there, we fully launched the company-wide rollout, and as a result of holding regular briefing sessions and repeated individual consultations for business labor saving, we have now established it to the point where we can maintain a company-wide usage rate in the 70% range.
Manual work that made buyers cry every week is now done in 5 minutes with a single copy-paste
Among the business improvements promoted by Mr. Aoki, this is the achievement most appreciated by the field. It was a task where staff in charge at each store spent time manually extracting the products and quantities they handled from the massive product and inventory lists issued by headquarters every week. Without using macros or VBA, just by 'copying and pasting the prompt provided,' the work time changed drastically from 2-3 hours to an instant 5 minutes. This is a case that realized an environment where they are freed from the stress of data processing and can concentrate on the original work of the retail industry, such as creating sales floors and customer service.
There was a task where staff in charge at each store manually extracted 'products handled at their own store' from massive product and inventory lists. I created a mechanism that doesn't use VBA or macros at all, just 'copying the prompt I provided and pasting it into the AI.' Then, I received feedback from those actually working in the field saying, 'What used to take 2-3 hours every week now finishes in 5 minutes!' and they were happy that they were freed from the stress of PC data processing and could devote time to the store's original work, such as creating sales floors and customer service. After all, it is most gratifying to be able to make such daily, tedious work visibly easier and be useful to the field. By the way, the prompts I provide are designed with scalability in mind so that they can also be used by others in the workplace doing similar tasks.
We will even provide a 'complete review manual' as a set after the instruction
The target Mr. Monzen assumes is general employees who use Word and Excel daily but do not have difficult knowledge such as programming. Even after the instruction is over, we will provide a procedure manual with careful captures so that you can reproduce it completely by yourself at your desk starting tomorrow.
As for the deliverables provided, in addition to the prompts that can actually be used in business, our policy is to also provide the explanatory text and screen captures at the time of execution as a set.
If you are interested in 'data processing techniques centered on copy-paste without using macros' like the teacher's, or 'Excel x AI utilization that shortens manual work to 5 minutes,' why not take a peek at the school's atmosphere first? →
Take a peek at the school
Mr. Aoki's Strengths and Achievements
Approximately 20 years of financial institution system construction x 21 years of rock-solid system development and PMO achievements at Hitachi: A professional who has thoroughly promoted progress, quality, and cost management as a PMO (PMP holder) for large-scale financial and securities projects (up to 8 billion yen scale, up to 270 person-months).
1.5 years of real-world field knowledge and business shortening achievements as an in-house AI promotion leader: Led AI promotion at the company and achieved company-wide dissemination (over 70% utilization rate) while assessing the evolution of response accuracy. Created overwhelming business improvements such as 'shortening Excel manual work that buyers spent 2-3 hours on every week to 5-10 minutes using prompts for Copilot'.
Careful instruction ability that allows beginners to learn step-by-step without 'macros': Without using advanced processing such as VBA or macros, we can teach general office workers who use Excel, Word, and PowerPoint daily how to master AI step-by-step.
An overwhelming deliverable package that ensures students don't get lost: Not only teaching verbally, but also presenting a set of 'prompts that can be used immediately in business + their explanatory text + screen captures at the time of execution,' making it easy to review and immediately establish in your own work.
First, why not spend 60 minutes organizing your 'massive data and monotonous Excel manual work that you repeat every week' together?
Single lessons start from 10,000 yen.
In addition, you can also take the [For Project Leaders and Mid-level Employees] 'Direct from a Former Hitachi PMO! AI x Project Launch and Management Practice Course (5 sessions total, 60 minutes each, 75,000 yen)' or the [For Administrative Staff Overwhelmed by Large Volumes of Data and Manual Work] 'No Macros Needed! Copilot/Claude Data Processing Course to Reduce 2-3 Hours of Excel Manual Work to 5 Minutes (3 sessions total, 60 minutes each, 30,000 yen)'.
*Prices shown are reference prices as of August 7, 2026.
Please check here for the latest pricing and course details.
📩 Information on Applications and Inquiries
👉 [Free] Service Introduction by the Secretariat (approx. 20-30 minutes)
This is a free online consultation for those who want to discuss which course or instructor is right for them. Secretariat staff will neutrally listen to your needs and propose the optimal learning plan. *Technical instruction is not included.
👉 [Paid] 'Single Trial Data Processing Lesson' with Mr./Ms. Aoki (60 minutes, 10,000 yen)
This is a practical lesson for those who say, 'I can't write macros, but I want to somehow reduce the massive amount of Excel and data aggregation work in front of me to 5 minutes.' You can take home a step-by-step manual with screenshots.
[Free Service Introduction/Counseling]
Apply here →
Why not let go of your 'anxiety about not being able to write macros and the enormous time spent on data processing' through AI learning that starts with your goals?
いいなと思ったら応援しよう！
子供の金融教育アプリ開発にむけて取り組んでおります。
ご支援頂けましたら幸いです。
頂いたサポートは全てアプリ開発に使わせて頂きます。