How to Use Excel to Finish Presentations, Reports, and More Smartly with My AI Assistant
Innovative presentation writing with AI, from planning to presentation.

Have you ever felt like you were stamping your feet the day before a presentation? If so, it's time to change the way you work.
From data collection to content composition and presentation creation, AI can help you work more efficiently and systematically.
First, during the presentation material research phase, you can quickly collect reliable data using AI search tools like Perplexity and GenSpark.
Second, in the content composition stage, a logical and persuasive storytelling structure is completed through conversational AI such as ChatGPT and Claude.
Third, in the design and production stages, various AI-based presentation tools such as Gamma, Miricanvas, Felo, Mango Board AI, and Napkin are used to create presentations easily and conveniently.
In particular, the ability to create custom images using Recraft can greatly improve the visual perfection of your presentation.


Generative AI makes Excel work surprisingly convenient.
It intelligently tells you how to process the data you want and creates complex formulas in an instant.
Additionally, if you upload data and order the work you want, ChatGPT will automatically process the work and create an Excel file with the results.
Therefore, you can experience the effect of work speed being significantly faster than before.
Leveraging AI for data cleaning and transformation, formula and function creation, data analysis and visualization, VBA and macro writing, error resolution and debugging, and report and document automation can have tremendous benefits, like having a dedicated assistant at your side.
If you follow along with the practical examples and specific situational prompts presented in this book, you will gain various tips and significantly improve your work skills.

Information gathering is a crucial step that lays the foundation and starting point for all work.
Recently, tools like Perplexity and Goover have emerged to help you quickly research information and organize the necessary materials systematically.
Perplexity provides clear summaries with reliable sources, while Goover helps you understand complex content with custom content organization and visual information organization.
These AI tools are revolutionizing how we gather information and dramatically increasing work efficiency.

--- p.16

From the beginning, you can just give AI a topic and leave everything from researching to organizing the data.
However, there are a few caveats to this method.
This is because the latest data may not be reflected, and there is a risk of ‘hallucination’, where AI creates false information that appears to be fact.
So a smarter approach is needed.

--- p.30

AI-based competitive analysis requires automatically collecting and organizing massive amounts of data.
Some of the most commonly used tools include SEMrush, Ahrefs, Google Trends, ChatGPT, and NLP-based crawling tools. In this chapter, we'll use the free Google Trends tool to find out which keywords are driving our competitors' main traffic.

First, enter the following dessert-related keywords into Google Trends to check the search volume trends (analysis period: last 12 months, region: South Korea).
Click the Download Data button to save the CSV file.
You can also collect related search terms and relevant keywords from the search results screen.
You can see the rankings of keywords that have risen sharply or are popular, which helps you identify trends.

--- p.135

Leveraging AI can go beyond simply organizing sentences, and can also be used to systematically improve the overall readability of reports.
This includes not only revising sentences, but also strengthening logical connections between paragraphs, emphasizing key messages, eliminating redundant expressions, and optimizing the structure to make it easier for readers to understand the information.
--- p.169

Anyone who uses Excel in the field has probably experienced difficulties when encountering data.
You need to use various Excel functions appropriately to collect data, preprocess the data into a usable state, write formulas by selecting appropriate calculation methods and functions for calculations, extract or summarize only the necessary data, analyze the insights from the data, and arrange the analyzed data so that it can be used in reports.

--- p.186

With ChatGPT, writing macro code in Excel is now possible with little effort and in a short period of time, even for non-experts.
However, when actually used in practice, errors often occur or it does not work.
If you encounter an error, you can ask questions like, “Analyze this error and find a solution,” so you can work towards a working code. So, even if you fail once or twice, I recommend being patient and writing the code.
Additionally, as you learn more about code by asking for detailed, easy-to-understand explanations of code, as introduced in this section, you will gradually be able to utilize macros to the point where you can perform simple edits on your own.

--- p.257