[Preparation] Get off work on time and get things done 3x faster! Build your Excel fundamentals.

01 Run and close Excel
02 A peek at Excel's appearance
03 Where all Excel work begins, the cell!
04 Different from Word! How to Use the Mouse in Excel
Excel Mastery Challenge! Master the Mouse! Build Basic Data Editing Skills
05 Excel data is divided into letters and numbers.
06 Let's start with the priority function! - [File], [Home], and [Insert] tabs
07 Priority Excel Function ① [File] Tab
Challenge Excel King! [File] tab - Save
Challenge Excel King! [File] tab - Save As
Challenge Excel King! Save in Excel 2003 and earlier versions, PDF, and other file formats.
Challenge Excel King! [File] tab - Open
Excel Challenge! [File] tab - New, Print
Excel Master Challenge! Work 3x faster with the Quick Access Toolbar!
08 Priority Excel Function ② [Home] Tab
Excel Challenge! [Home] tab - Copy, cut, and paste cells.
Excel Challenge! [Home] Tab - Font Customization
Excel Challenge! [Home] tab - Change font and background colors
Excel Challenge! [Home] Tab - Customize Cell Borders
Excel Challenge! [Home] tab - Indent, Outdent, Justify, Text Direction
Excel Challenge! [Home] Tab - Text Line Break
Excel Challenge! [Home] tab - Merge and Center
Excel Challenge! [Home] tab - Display formats such as won, percentage, and comma.
Challenge Excel King! [Home] Tab - Conditional Formatting
Excel Challenge! Use conditional formatting to get into the top 5.
Excel Challenge! [Home] tab - Table Format
Excel Challenge! [Home] Tab - Cell Styles
Excel Challenge! [Home] Tab - AutoSum
Challenge Excel King! [Home] tab - Fill
Challenge Excel King! [Home] Tab - Sort & Filter
Challenge Excel King! [Home] tab - Find & Select
Challenge Excel King! [Home] tab - Top
09 Priority Excel Function ③ [Insert] Tab
Excel Challenge! [Insert] tab - Create a table
Excel Challenge! [Insert] tab - Insert picture
Excel Challenge! Neatly Draw Diagonals with Shapes
Challenge Excel King! [Insert] tab - SmartArt
Excel Challenge! [Insert] tab - Insert a graph
Excel Challenge! [Insert] tab - Enter symbols
10 Basic Paper Orientation for Printing
Excel Challenge! Setting the Paper Orientation
11 Specify the print area as desired
Challenge Excel King! Print only the parts you want.
Excel Challenge! Adjust the print area to a wider range.
12 Create and print a quotation form
Excel Challenge! Creating a Quotation Form ① Merge Cells
Excel Challenge! Creating a Quotation Form ② Area-Specific Borders
Excel Challenge! Creating a Quotation Form ③: Decorating and Finishing
Challenge Excel King! Create a Quotation Form ④ Print
Creating payment boxes with different column widths
Excel Challenge! Create a payment screen using the camera function.

[First Yard] Accounting & Finance Team Excel King

14 Expense Request Form - Create two documents at once using the equal sign
Excel Challenge! Automatically Enter Repeated Data with the Equal Sign (=)
15 Expense Receipts - Displaying Thousands with Commas
Excel Challenge! Displaying Amounts Neatly with Comma Style
16 Quotation - Displaying Currency and Accounting Format
Excel Challenge! Displaying amounts neatly in won units
17 Daily Cash Flow Statement - Displaying a Negative Deficit Amount
Excel Challenge! Select only the deficit amount and highlight it in red.
18 Smart Receipts - Find Out If Your Expenses Are Covered
Excel Challenge! Extracting Items from Receipts Without Expense Support
19 Credit Card Usage Log - Fill in the cells that match the conditions
Excel Challenge! Calculate the total gas expenses for your corporate card.
20 Daily Transaction Statement - Managing Receivables with Color Data
Challenge Excel King! Find the customer with the largest receivables.
21 Error-Free Transaction Statement - SUM Function
Excel Challenge! Calculating Supply Price, Tax, and Total
Excel Challenge! Check your calculations using the SUM function.
22. No Counterfeiting! Certificate of Deposit - NUMBERSTRING Function
Excel Challenge! Convert numbers to Korean characters and enter them.

[Second Yard] HR Team Excel King

23 Personnel Records - Sorting Documents with Filters
Excel Challenge! Filtering Data from the Personnel Record Book
24 Organizational Chart - Click to go to the personnel record book
Excel Challenge! Adding Hyperlinks to Your Organizational Chart
25. Personnel Record Card - Sort Data in Desired Order
Excel Challenge! Sort by Date of Hire in Ascending Order
26. Job Distribution Chart - Graphically Displaying the Work Share of Each Employee
Excel Challenge! Editing Graphs with Charts
27 Personnel Evaluation Card - IF Function
Challenge Excel King! Marking Promotion Confirmations on the Performance Evaluation Card
Challenge Excel King! List only those confirmed for promotion.
28 Monthly Training Attendance Status - COUNTA, COUNTBLANK Functions
Challenge Excel King! How many monthly training attendees will there be?
29 Attendance Record - COUNTIF Function
Challenge Excel King! Score your commute.
30 Payroll - ROUND Function
Excel Challenge! Rounding Your Salary to the Next Decimal (256)
31 Part-timer Payroll Ledger - SUM Function
Excel Challenge! Calculate a part-timer's weekly holiday allowance and total salary.

[Third Yard] General Affairs & Management Support Team Excel King

32 Departmental Ranks and Personnel Status - Quickly Create a Beautiful Table
Excel Challenge! Quickly Organize Tables with Cell Styles
33 Document Management Ledger - Official Documents Edited Only by the Author
Excel Challenge! Password-protect the publication year and expiration date cells.
34. Change department names in bulk in the business partner management ledger.
Excel Challenge! Transforming Sales Department 1 into Sales Department 4
35 Consumables Usage Log - Check at a glance with the frame fixing function
Excel Challenge! Applying the Fix Horizontal Data Frame Feature
36 A/S Customer Management Ledger - ROW Function
Excel Challenge! Automatically Ordering with the ROW Function
37 Vehicle Management Register - MAX, MIN, LARGE Functions
Excel Challenge! Finding the Maximum and Minimum Values ​​in Data
Challenge Excel King! Pick the top three by data size.
38 Parts List - LEFT, RIGHT, MID Functions
Excel Challenge! Extract only the letters you want from the part names.
39 Intern Training Log - IF Function
Excel Challenge! Find the Top Intern with High Education Scores Using the IF Function
40 Financial Statement - DATEDIF Function
Excel Challenge! Find and manage expired office supplies.
41 Donation Payment Management Ledger - RANK Function
Excel Challenge! Ranking Donations with the RANK Function
42 Cost Calculation Statement - INDEX, MATCH Functions
Excel Challenge! Use the INDEX function to select the lowest-priced vendor and secure a contract.
43 Seminar Participant List - COUNTIF and COUNTIFS Functions 326
Challenge Excel King! Create a list that automatically changes when the number of attendees changes, with no participants automatically removed. 327
44. Membership List for Men's Clubs - CHOOSE and MID Functions 333
Challenge Excel King! Determine gender by resident registration number 335

[Fourth Yard] Materials & Production Team Excel King

45 Daily Work Log - Creating a Defect Rate Chart 340
Excel Challenge! Calculating the Defect Rate Using Division
Excel Challenge! Charting the hourly defect rate.
46 Purchasing Plan - Creating a Table That Can Be Calculated Automatically
Excel Challenge! Calculate mixed addition and multiplication equations at once.
47 Production Plan Performance Table - Entering a 3D Graph
Excel Challenge! Graph production rates by machine in 3D.
48 Order Status List - Automatically Analyze Information by Segmentation
Excel Challenge! Divide Complex Text into Four Parts
49 Materials List - VLOOKUP Function 362
Excel Challenge! Get the data you need with the VLOOKUP function.
50 Production Housing Provided List - SUMIF Function 366
Excel Challenge! Sort employees by nationality.
Excel Challenge! Find the number of users per accommodation.
51 Order Form - IF, RIGHT Nested Function
Excel Challenge! Extracting Color Names with Nested IF and RIGHT Functions
52 Material Receipt Management Ledger - IFERROR Function
Excel Challenge! Change the error value (#VALUE) to "OK."
53 New Business Selection Report - AND Function
Challenge Excel King! Select a company with 5 points in manufacturing and 3 points or more in other categories.
54 Quality Log - FREQUENCY Function
Excel Challenge! Finding Frequency with the FREQUENCY Function

[Fifth Yard] Sales Team Excel King

55 Weekly Schedule - Swap Row and Column Contents
Excel Challenge! Transform a Table with the Transpose Icon
56 Sales Branch Management Status - REPLACE Function
Excel Challenge: Adding a "-" Between English Letters
57 Sales Status by Employee - SUMIFS Function
Excel Challenge! Calculate Total Sales by Employee in January with the SUMIFS Function

supplement
Appendix 1: Lotto Winning Number Tracker
Appendix 2: Ask the Excel God! Black Lovely Q&A
Appendix 3: Summary of 28 Business-Related Functions
Coupon Code 73: Work-related Forms Secretly Used Even by Employees of Large Corporations

TIP
Insert a diagonal line in the [Cell Format] → [Border] tab
Calculating the number of holiday pays using the COUNTIFS function
A complete summary of functions that include COUNT
Calculating length of service using the DATEDIF function
Calculating the number of months and days with the DATEDIF function
Analyzing Shopping Mall Order Numbers with LEFT, RIGHT, and MID Functions
How to replace multiple characters with the REPACE function?
6 Basic Excel Shortcuts
Create a list that automatically changes age
Autofit column width with double-click
Creating a courier invoice using the equal sign
A complete guide to creating documents
What if the color you want for the background isn't available?
Distinguish positions by background color
Enter data quickly
Relative and absolute references
What if I want to sort only the selection area in descending order?
Organizing documents and files vertically
How to use shortcut keys to select a range of cells
How to use Shift and Ctrl keys when selecting cells
Use cell addresses! Jump to distant cells instantly.
$ sign to fix cells
Useful frame fixing function for shopping mall daily sales status table
Ink formulas useful for entering formulas
For documents that are frequently modified, use equal signs rather than copies.
[File] tab 'Options' features that are good to know and good to not know
Excel's various toolboxes that are good to know and good to not know
Excel 2007's [File] tab features
Excel 365 version
Graphs added to Excel 2019
How to attach an email or send as a PDF from Excel?
Round up ROUNDUP function and round down ROUNDDOWN function
Enter numbers starting with 0, such as postal codes and phone numbers.
Check the paper orientation on the worksheet screen
When to use a flat chart?
Upper field printing
5 Principles for Easily Understanding Printing Functions
Do not print blank pages when printing
Create a calendar with auto-fill feature for naming files that will make your work flow.
Difference between double-clicking and dragging the autofill handle
Creating a business partner management ledger with automatically updated numbers
Automatically fill ranks
Setting the absolute value
Download your card statement and calculate your total monthly usage amount.
Special characters for each Korean consonant on the keyboard
Convert table data to general data
Learn the basic rules of using functions
Capture the screen and insert it into Excel

#1 Downloadable Excel Template for 7 Million Office Workers!
Practical Excel God who will lead you to Excel!
Black Lovely, the owner of Naver's No. 1 Excel blog visited by 7 million office workers, has compiled the Q&A she had with subscribers over the past five years into a book.
The author couldn't find the Excel template he urgently needed online, so he started creating his own Excel template and uploading it to his blog.
As expected, I uploaded only the Excel formats that were absolutely necessary for the field and received an explosive response from office workers.
It was especially helpful for Excel beginners because they could complete urgent tasks in a day by simply changing the numbers in the format.
Even if you study function-centered for a hundred days, it is difficult to apply it in practice.
If you're struggling in the middle of a crisis, try finding a solution with the Black Lovely format.
It will be an opportunity to develop real skills.

What if I have a computer skills certificate and a ton of Excel books, but can't get a job?
Reporting is the way to go! Black Lovely's Excel report format!
- How to use Excel formats 200%, worth the money!
- Directly related to specific tasks! Shopping mall invoice management, factory inventory management, marketing sales reports, accounting daily statements, etc.
Because Excel has a reputation as an essential program for practical work, many people obtain computer skills certifications or study Excel books before joining the company.
However, most employees are unable to use the skills they have acquired in their work after joining the company.
Practice speaks for itself.
Data analysis is useless if you can't translate it into a report! "Black Lovely's Ultimate Practical Excel Master" features 73 of the most useful templates frequently requested by departments.
Excel's uses in field work include analysis and reporting, so you should learn the formats needed in the field, such as daily reports, work reports, and sales plans, so you don't forget them easily.
We created examples using Excel formats actually used in large corporations, government offices, etc., so that they can be easily modified and used for various tasks.
Choose one of the 73 copyright-free coupon templates in the book and follow the example.
Anyone—be it a complete beginner, an experienced employee, or a freelancer—can become an Excel expert, editing documents, automating tasks, and creating visual charts.

Is it enough to just know the basic functions in Excel?
Learn in 3 simple steps and use it for a long time!
Even functions that are considered difficult among Excel functions can be used for a long time only if you learn them as they are necessary for practical use.
Although Excel has extensive functions, the functions actually used in the field are limited.
By following the simple 3-step learning plan of "Black Lovely's Strongest Practical Excel King," you can complete your work quickly.
The three steps are: ① Use the coupons in the book to choose the necessary format. ② Edit it to your liking and you'll master the basics! ③ Select and use the 28 functions in the format to get off work on time.
We've removed functions that are not commonly used in practical Excel and organized only 28 functions directly related to work, such as SUM, VLOOKUP, and COUNTIF.
Big data analysis can be easily solved with basic functions, so let's follow this book and complete examples with a goal in mind.
You will experience the fruits of improved performance and increased salary.