Recommendation
Student Reviews
PROLOGUE

Chapter 01_ For those of you who use Excel as graph paper
01 If you have a solid foundation, you won't be confused.
02 Data is hidden
03 Do I really need to memorize shortcuts?
04 When you feel frustrated with repetitive tasks
05 The various faces of cells that trouble beginners
06 Excel is not easy to print either.

Chapter 02_ Data Basics: Filters, Freezing Frames, Conditional Formatting
01 Filter that filters out only the information you want
02 The reason why the manager is annoyed, fixing the frame
03 Conditional formatting that brings data to life

Chapter 03_ Laying the foundation for writing formulas and functions effectively
01 Function is a super calculator
02 Copy and paste is not the end
03 Numeric functions are OK if you know only this.
04 Splitting and pasting text
05 Transform text as desired

Chapter 04_ How to Use Date Formats for Professionals
01 Date functions essential for practical use
02 Can you add and subtract dates?
03 Find the day of the week quickly and easily

Chapter 05_ The transformation of the conditional IF and absolute reference!
01 IF Basic: If ~, then do this
02 IF Application: Complex conditions made simple
03 COUNTIF and Wildcards
04 Absolute reference that you will be in trouble if you don't know!

Chapter 06_ Just by using VLOOKUP well, you can say, 'I know how to use Excel!'
01 Find and match, VLOOKUP
02 Data reference in various ways
03 Let's handle errors cleanly
04 Limitations of VLOOKUP
05 VLOOKUP's Brothers
06 INDEX & MATCH to overcome the limitations of VLOOKUP

Chapter 07_ SUMIF, as widely used as VLOOKUP
01 Find and add, SUMIF
02 When there are multiple conditions, SUMIFS
03 Let's organize the ledger with SUMIFS

Chapter 08_ Data Analysis Cheat Key, Pivot Table
01 Let's create a pivot table.
02 I wonder why I learned other functions
03 Organizing Data with Pivot
04 Pivot Table Utilization Tips
05 What happens when VLOOKUP meets Pivot?

Chapter 09_ Collection of Secret Moves for Finishing Work on Time
01 Your choices are set! Dropdown
Please round to the nearest thousandth
03 Level up your skills with filters
04 What to do when there's a tie? Ranking
05 Three Ways to Capture Images in Excel

Chapter 10_ Pictures are more intuitive than numbers: Creating charts
01 How to draw a mini chart simply
02 Line chart expressing trends
03 Bar chart for easy comparison
04 How to combine line charts and bar charts

Chapter 11_ Google Spreadsheets Optimized for Collaboration
01 Pros and Cons of Google Spreadsheets and How to Use It

EPILOGUE

Foreign MD, former planner at a large corporation
Excel know-how taught by a real practitioner!

The contents of the #1 Excel class in '탈잉' are all in one book!
Sophie, an Excel expert chosen by HR managers at large corporations
Excel skills you need for real work, without wasting a single second!

- Reflects the latest features of MS Office 2021
Free practice materials provided! (QR code download)
-Added shortcuts and usage instructions for MacBook users!

[This kind of person definitely needs this book!]
· Those who are worried about Excel before an internship or job application
· Those who suddenly need Excel due to a job or department change
· Experienced person who is embarrassed to ask people around him about Excel
· People who use Excel only as white graph paper

“The company doesn’t teach you how to use Excel.
“I’ll just give you work.”
A 100% Practical Excel Guidebook That'll Make Your Workday Faster

Now, discover the vivid lecture content of "Excel Know-How Really Needed in the Workplace," the #1 Excel class on the educational VOD platform "Tal-ing," in book form! This book, steeped in the expertise of tutor Sophie, who has taught over 10,000 people through one-on-one tutoring, group study sessions, large-scale lectures, corporate training, and Tal-ing's online and offline classes, explains the essential Excel usage methods for companies, tailored to the beginner's level.


This book organizes only the essential functions among the thousands of functions in Excel, excluding the complicated ones. If you know only the functions in this book, you can handle all the tasks that arise in practice.
In particular, pivot tables and V-lookups, which are most frequently used in practice, are covered with various examples to ensure a thorough understanding.
In addition, we will teach you about the new functions that are frequently used these days, such as 'xlookup' and 'ifs', as well as how to create a sheet in 'Google Spreadsheet', which is similar to Excel but a bit different, and even how to share it with your team members.

This book will quickly and easily answer all your Excel questions, including the basics of filters, frame freezing, and conditional formatting, as well as the date functions that are especially frequently used when organizing data, mini charts that make reports look even better, sparklines, and other charts, and even tips for printing a desired range that many people secretly struggle with.


*Praise comments from students taking Sophie's Excel class

*The thoughts I had most often while listening to the lecture were, 'Why didn't I know about this function until now?' and 'I've been working like an idiot all this time.'
I liked that there was no useless content and that it was explained in an easy-to-understand way for beginners.
- Mr. Yoon*ho

*This curriculum covers the essentials in depth, seemingly at a basic or intermediate level, while boldly leaving out things that are not frequently used.
I guess this is where Koreans' work speed comes from! - Choi*in

*I am an office worker with 10 years of experience.
As I was giving this lecture as a gift to a junior and skimming through its contents, it seemed like the "history of failure" of office workers was all wrapped up in this lecture.
It explains very well the mistakes I made and questions I had while using Excel when I first joined the company.
If you know this much, you won't hear anyone say that you can't use Excel.
- Mr. Kim*Wan

*I have computer-related certifications such as computer skills and MOS, but I was completely useless in practical work.
After meeting Teacher Sophie, I regretted not taking her class sooner.
It feels like a collection of truly practical, useful tips! - Sim*gyeong