Enter/edit.
In times like this, do this!

Creating Your Own Excel Environment
Can I create my own shortcuts?
Wait a minute │ I want to insert a check box into an Excel sheet.
Can I change the default font in Excel to a font of my choice?
Can I remove hyperlinks that are set automatically?
Wait a minute │ Can I stop '(주)' from auto-correcting to special characters?
Can you remove the green triangles that appear in the corners of cells?

Specify a display format to display data in the desired format
Can't I enter the date and time in the same cell?
When I enter a date, an unknown number is displayed.
I want to input a fraction in the format '2/3', but a date is input.
I want to enter a phone number starting with 0.
I want to change the number display unit.
I want to automatically apply formatting to the data in the cell.

Automating tasks with conditional formatting
Is it possible to automatically insert borders into cells where data is entered?
I want to automatically color rows that have matching data.
Is it possible to color only odd rows in table data?
Wait a minute │ Can I only use the table style?

Filter/sort to see only the data you need
Can I filter even if there are merged cells?
Can I filter multiple items at once?
Is it possible to filter only cells containing specific characters?
Can I align the data horizontally?
I want to sort it in any order I want, not ascending/descending.
Can I sort data by more than one condition?

Find and replace to find only the data you need
Can I change the format applied to multiple cells at once?
Wait a minute │ Can I just delete the format while leaving the cell contents intact?
I want to sum only the numbers in specific cells that have been filled with color.
Can I change the date format to year, month, and day separated by periods?
I want to convert unknown Chinese characters into Korean.
Wait a minute │ Isn't the shortcut for auto-sum [Alt]+[=]?

Quickly fix with the Move option
Can I enter the desired data in bulk into blank cells?
Wait a minute │ Is there another way to enter data in bulk into empty cells?
Is it possible to delete rows with empty data at once?
Is it possible to copy/paste only visible cells, excluding hidden cells?
I want to easily move an entire row/column.
Wait a minute │ I want to insert rows/columns easily.
I want to separate text and numbers entered in one column.

Increase work efficiency with data validation
Is it possible to automatically convert Korean/English text to match the data to be entered?
Is it possible to insert a list so that only specified items can be entered?
Can I create multiple lists and sublists?
Is it possible to prevent duplicate data entry?
Wait a minute │ What is a comparison operator?
Is it possible to insert a data entry method into an Excel sheet?

Quickly input and edit without overtime
Is there a way to quickly enter a weekday date excluding weekends?
I want to enter the column numbers from 1 to 100 at once.
I want to input them directly in order of rank.
Can I create multiple sheets at once?
Can I calculate data from multiple sheets at once?
Wait a minute │ Can I do the same task on multiple sheets at once?
Is it possible to copy only cells with content, excluding spaces?

Shortcut Dictionary

Function.
In times like this, do this!
You can do this with a function too
Can you check the Excel version on your PC?
Can I display as many stars (★) as I enter in numbers?
Is it possible to clean up text data with irregular spaces at once?
Wait a minute │ Can I copy/paste only the results?
I want to capitalize the first letter of my first name and last name entered in English.
I want to keep the serial numbers in order even if I delete rows.
I want to extract and calculate only the numbers from cells that contain mixed text and numbers.
Is it possible to have the serial number automatically entered when entering data?
Is it possible to get all matching values ​​into one cell?
Is it possible to count a specific number of texts within a cell?
Is it possible to combine text entered in multiple cells into one?
Is it possible to extract only the text before a specific text?

Calculating time and date using functions
I want to calculate the cumulative working hours excluding lunch time.
Is it possible to separate the date and time entered in one cell?
I want to separate the date data entered in one cell into year, month, and day.
I want to find the day of the week by referencing the date.
Can I find out the current length of employment of the employees?
Is it possible to get the monthly total of one year's cumulative data, separated by year, month, and day?

How to properly use functions for complex calculations/analysis
Is it possible to automatically get the ranking?
Is it possible to get the overall ranking of data divided into multiple tables?
Can you find the maximum and minimum values?
I want to round down the calculated amount to the desired unit.
I want to get the sum of the filtered cells.
Is it possible to keep the order of the numbers even when filtering?
Is it possible to reference each array and calculate the total sum at once?
Can you find the sum of odd/even columns?
Wait a minute │ Can you tell me how many empty cells there are?

Quickly process data with find/database functions
Can you find out how many employees have exceeded their corporate card usage limit?
Is it possible to sum the cells that contain a specific test?
Is it possible to automatically calculate the cumulative total sales for a specified month?
Can I determine gender by referencing the resident registration number?
Can I extract part of the resident registration number by marking it with '*'?
Is it possible to automatically collate data organized in different sheets?
Is it possible to get the value on the left side of the reference cell without using the XLOOKUP function?
Can I enter the column numbers to be extracted with the VLOOKUP function all at once?
Wait a minute │ Can I use array formulas in the VLOOKUP function in versions lower than M365?
Can I get exact matching data using the VLOOKUP function when there are people with the same name?
Is it possible to get the value to the left of the reference cell?

Resolving Excel Error Messages
#Can I prevent the N/A error from appearing?
Can you check my formula for errors?
Wait a minute │ Is it possible to display a formula directly in a cell, rather than the result of a function?

Practice.
In times like this, do this!
Visualizing data with charts
Is there a way to quickly insert a chart?
I want to insert an image of my choice into the chart background.
I want to insert an image above each series in a bar chart.
Wait a minute │ Is it possible to make specific cells with content invisible?
Can I create a mini chart inside a cell?
Wait a minute │ Can I insert a bar chart inside a cell?
Is it possible to continue a broken line chart that has no data?
Wait a minute │ Can you improve the readability of line charts?
Can I adjust the spacing and size of the bars in a vertical bar chart?
Can I mix bar and line charts?
Wait a minute │ Can you improve the readability of mixed charts?

Leveraging Data with PivotTables
Can I view monthly data quarterly?
Is it possible to sort a pivot table with more than one row label in a desired manner?
I want to insert a dashboard-type chart that links to a table.

Print without double-sided paper
Is it possible to output only a specific area?
Can I insert page numbers in any format I want?
Is it possible to fix a specific row and repeat the output?
Excuse me │ Can you print the entire sheet at once?
Can I print an Excel sheet with my company logo inserted?

Mastering Excel Image Utilization
Can I filter images too?
Can I remove the background of an image?
Is it possible to align the spacing of images accurately in one go?
Is it possible to resize multiple images to fit the size of a cell?
Wait a minute │ Can I extract the image inserted into an Excel sheet as a file?
Can I import an image into an Excel sheet using the image address on the web?

Document Management Methods of a Successful Worker
Can I protect a specific sheet from being modified by others?
Can I password protect a workbook?
Can I edit sheets within a single workbook simultaneously?
Can I create multiple folders at once using Excel?
Wait a minute │ What are BAT files and ANSI?

Function Dictionary

Excel...
It provides a clear answer to the question, 'What should I do in this situation?'

Excel, an essential tool for office workers, is a vast collection of tools, so there's no single right answer to solving a specific problem.
Many job seekers and office workers, despite having basic Excel skills, find practical Excel tasks challenging because they lack the knowledge and experience to flexibly utilize Excel's various functions.
The goal of this book is to present practical solutions that can be applied immediately in practice, rather than complex and difficult solutions.

When data entry/editing leads to overtime due to simple repetitive tasks, try this.

Let's start by creating an Excel environment that allows you to utilize Excel effectively. Even if you just master basic Excel features like cell formatting, find and replace, conditional formatting, and filter/sort, your work efficiency will dramatically increase.
Now you can leave work on time! Data entry/editing work.
In this case, try this!

A function that I wanted to process quickly and in one go, but was at a loss.
In this case, try this.

If you've ever wondered, "Can't this be done with a function?" or "What does this function do?", we present a clear solution that can be quickly and easily handled in one go.
From essential functions you need to know to creative ways to use Excel functions that no one has ever thought of! Try this in these situations.

The practical work of printing, charts, etc., which changed from time to time, was confusing.
In this case, try this!

Charts and pivot tables help you discover patterns, trends, and insights hidden in your data.
In addition, we generously share practical Excel know-how that enhances data security and consistency, and improves work efficiency, from printing to image and document management.
When you have a difficult Excel job, try this.