가장 자주 쓰이는 Excel 작업에 대한 단계별 가이드. 수동으로 하기 귀찮으신가요? AI에게 맡겨보세요.
Excel에서 중복 제거하는 방법
중복 제거 도구나 수식으로 중복된 행이나 값을 몇 초 만에 삭제하세요.
Excel에서 VLOOKUP 사용하는 방법
표에서 값을 찾아 다른 열에서 일치하는 값을 반환합니다.
내 VLOOKUP이 작동하지 않는 이유는 무엇입니까? 문제를 해결하는 방법
VLOOKUP이 #N/A 또는 잘못된 값을 반환하는 가장 흔한 6가지 이유와 각각에 대한 한 줄 해결법.
Excel에서 피벗 테이블 만드는 방법
수천 개의 행을 필드를 끌어 재구성할 수 있는 그룹별 합계로 요약합니다.
Excel에서 드롭다운 목록 만드는 방법
데이터 유효성 검사로 셀을 고정된 선택 목록으로 제한합니다.
Excel에서 텍스트 결합하는 방법 (CONCAT / TEXTJOIN)
여러 셀의 텍스트를 구분 기호와 함께 또는 없이 하나로 결합합니다.
Excel에서 텍스트를 여러 열로 나누는 방법
텍스트 나누기나 수식을 사용해 한 열을 여러 열로 나눕니다.
Excel에서 행과 열 고정하는 방법
긴 표를 스크롤하는 동안 머리글이 계속 보이도록 유지합니다.
Excel에서 백분율 계산하는 방법
간단한 수식으로 백분율, 백분율 변화, 전체 대비 비율을 계산하세요.
Excel에서 열 합계 구하는 방법
자동 합계, SUM, 또는 조건부 SUMIF로 열을 더합니다.
Excel에서 텍스트가 있는 셀 세는 방법
COUNTIF로 텍스트, 특정 단어를 포함하거나 조건에 맞는 셀을 셉니다.
Excel에서 빈 행 제거하는 방법
이동 옵션이나 필터로 빈 행을 한꺼번에 삭제하세요.
Excel에서 두 열 비교하는 방법
수식이나 조건부 서식을 사용하여 두 열을 비교하고, 일치하는 값을 가져오거나, 차이점을 표시하세요.
Excel에서 텍스트를 숫자로 변환하는 방법
텍스트로 저장된 숫자를 수정해 올바르게 계산되도록 하세요.
Excel에서 숫자 반올림하는 방법
ROUND 함수로 소수점, 올림, 내림, 또는 가장 가까운 배수로 반올림하세요.
Excel에서 셀 병합하는 방법
제목을 위해 셀을 병합하는 방법 — 그리고 더 안전한 대안인 '선택 영역의 가운데로'.
Excel에서 셀 잠그는 방법
다른 사람이 편집할 수 없도록 수식이나 머리글을 보호하세요.
Excel에서 텍스트 줄 바꿈하는 방법
긴 텍스트를 한 셀 안에서 여러 줄로 표시합니다.
Excel에서 XLOOKUP 함수를 사용하는 방법
VLOOKUP을 대체하는 최신 함수 — 방향에 관계없이 검색하며 기본적으로 정확히 일치하는 값을 찾습니다.
Excel에서 SUMIF 및 SUMIFS를 사용하는 방법
하나 이상의 조건을 충족하는 값을 더합니다.
Excel에서 INDEX 및 MATCH를 사용하는 방법
어떤 방향으로든 작동하는 유연한 조회 — 고전적인 VLOOKUP 대안입니다.
Excel에서 차트 만드는 방법
클릭 몇 번으로 데이터 범위를 막대형, 꺾은선형 또는 원형 차트로 변환해 보세요.
Excel에서 조건부 서식을 사용하는 방법
값이나 수식을 기준으로 셀에 자동으로 색상을 지정합니다.
Excel에서 IF 함수를 사용하는 방법
조건이 참(True)일 때 하나의 값을 반환하고, 거짓(False)일 때 다른 값을 반환합니다.
Excel에서 절대 참조($)를 사용하는 방법
수식을 복사할 때 셀이 이동하지 않도록 $로 셀을 고정합니다.
Excel에서 셀 개수를 세는 방법(COUNT, COUNTA, COUNTIF)
숫자, 비어 있지 않은 셀 또는 조건을 만족하는 셀의 개수를 셉니다.
PDF에서 Excel로 표를 추출하는 방법
PDF 안에 갇혀 있는 표를 다시 입력할 필요 없이 깔끔하고 편집 가능한 Excel 행과 열로 변환하세요.
이미지 또는 스크린샷을 Excel로 변환하는 방법
AI OCR을 사용하여 사진, 스크린샷 또는 스캔한 표를 편집 가능한 Excel 셀로 변환하세요.
How to create a pivot chart in Excel
Learn how to visualize your data by linking a dynamic chart to an existing pivot table.
How to Make a Pie Chart in Excel
Learn how to visualize parts of a whole by creating a professional pie chart in Excel.
How to Make a Line Graph in Excel
Learn how to visualize trends over time by creating a professional line graph in Excel.
How to Make a Scatter Plot in Excel
Learn how to visualize the relationship between two numerical variables using a scatter plot.
How to Add a Trendline in Excel
Learn how to visualize data trends by adding a trendline and equation to your Excel charts.
How to Add a Secondary Axis in Excel
Learn how to plot two different data scales on a single chart using a secondary axis.
How to Add a Slicer to a Pivot Table in Excel
Learn how to create interactive filter buttons for your pivot tables using the Slicer tool.
How to Group Dates in a Pivot Table in Excel
Learn how to automatically roll up daily data into months, quarters, or years in an Excel Pivot Table.
How to Refresh a Pivot Table in Excel
Learn how to update your pivot table to reflect changes made in your source data.
How to add sparklines in Excel
Learn how to visualize data trends directly within a single cell using Excel sparklines.
How to Make a Gantt Chart in Excel
Learn how to visualize project timelines using a stacked bar chart in Excel.
How to Sort Data in Excel
Learn how to organize your spreadsheet data by sorting single or multiple columns.
How to Use Find and Replace in Excel
Quickly locate and swap specific text or numbers across your entire worksheet using the Find and Replace tool.
How to Use Flash Fill in Excel
Learn how to use Flash Fill to automatically extract or combine data without writing complex formulas.
How to fill a series of numbers or dates in Excel
Learn how to quickly populate cells with sequential numbers or dates using the Fill Handle or Series dialog.
How to Create an Excel Table in Excel
Learn how to convert a data range into a structured Excel Table with built-in filters and formatting.
How to Transpose Rows and Columns in Excel
Learn how to flip your data orientation from rows to columns or vice versa using Paste Special or the TRANSPOSE function.
How to remove extra spaces in Excel
Learn how to use the TRIM function to clean up messy data by removing leading, trailing, and double spaces.
How to Change Text Case in Excel
Learn how to use UPPER, LOWER, and PROPER functions to quickly format text case in Excel.
How to count unique values in Excel
Learn how to count distinct items in a list using modern dynamic array functions or classic formulas.
How to Highlight Duplicates in Excel
Learn how to quickly identify and highlight duplicate values in your spreadsheet using Conditional Formatting.
How to highlight blank cells in Excel
Learn how to use Conditional Formatting to automatically identify and highlight empty cells in your dataset.
How to highlight an entire row based on a cell value in Excel
Learn how to use Conditional Formatting with a formula to automatically highlight rows based on specific criteria.
How to combine data from multiple sheets in Excel
Learn how to stack data from different sheets into one master sheet using VSTACK or Power Query.
How to Compare Two Sheets in Excel
Learn how to identify differences between two Excel sheets using side-by-side views or comparison formulas.
How to split a full name into first and last name in Excel
Learn two efficient ways to separate first and last names using Text to Columns or Excel formulas.
How to count characters in a cell in Excel
Learn how to use the LEN function to quickly count the number of characters in any Excel cell.
How to Unmerge Cells and Fill Blanks in Excel
Learn how to unmerge cells and automatically populate the resulting empty cells with the original value.
How to write nested IF formulas in Excel
Learn how to chain multiple logical conditions using nested IF statements or the more efficient IFS function.
How to use IFERROR in Excel
Learn how to replace standard Excel error messages with custom text or values using the IFERROR function.
How to use AND and OR in Excel
Learn how to combine multiple logical conditions using the AND and OR functions in Excel formulas.
How to use SUMPRODUCT in Excel
Learn how to multiply corresponding components in arrays and return the sum of those products.
How to use the SWITCH function in Excel
Learn how to evaluate a single expression against a list of values and return a corresponding result.
How to use the CHOOSE function in Excel
Learn how to select a value from a list based on a specific index number.
How to use the SUBTOTAL function in Excel
Learn how to calculate totals that automatically update when you filter or hide rows.
How to Format Numbers with the TEXT Function in Excel
Learn how to convert numbers and dates into custom-formatted text strings using the TEXT function.
How to use VLOOKUP with multiple criteria in Excel
Learn how to perform lookups based on two or more criteria using helper columns or the modern XLOOKUP function.
How to Rank Values in Excel
Learn how to use the RANK function to order numbers in your dataset from highest to lowest.
How to Find the Highest and Lowest Values in Excel
Learn how to use MAX, MIN, MAXIFS, and MINIFS functions to extract extreme values from your datasets.
How to Create a Running Total in Excel
Learn how to calculate a cumulative sum that updates as you add new data to your list.
How to Calculate a Weighted Average in Excel
Learn how to use the SUMPRODUCT and SUM functions to calculate a weighted average efficiently.
How to Calculate an Average in Excel
Learn how to use the AVERAGE and AVERAGEIF functions to calculate data averages in Excel.
How to Calculate the Median in Excel
Learn how to find the middle value in a dataset using the MEDIAN function.
How to Calculate Standard Deviation in Excel
Learn how to use STDEV.S and STDEV.P functions to measure data variability in Excel.
How to use named ranges in Excel
Learn how to assign descriptive names to cell ranges to make your formulas easier to read and manage.
How to Convert Formulas to Values in Excel
Learn how to replace dynamic formulas with their static calculated results using Paste Special.
How to Show Formulas in Excel
Learn how to toggle between displaying formula results and the actual formulas themselves.
How to Trace Precedents and Dependents in Excel
Use visual arrows to identify which cells influence a formula and which formulas rely on a specific cell.
How to Generate Random Numbers in Excel
Learn how to use the RAND and RANDBETWEEN functions to create random data in your spreadsheets.
How to Calculate Age from a Birthdate in Excel
Learn how to use the DATEDIF function to accurately calculate age based on a birthdate.
How to Calculate the Number of Days Between Two Dates in Excel
Learn two simple methods to find the difference in days between two dates using subtraction or the DAYS function.
How to add months to a date in Excel
Learn how to use the EDATE function to easily add or subtract months from a specific date.
How to Extract Month and Year from a Date in Excel
Learn how to isolate month and year values from date cells using Excel functions.
How to Convert a Date to Text in Excel
Learn how to use the TEXT function to format dates as custom text strings.
How to get the day of the week from a date in Excel
Learn how to display the day of the week using the TEXT or WEEKDAY functions.
How to Calculate Time Difference in Excel
Learn how to subtract two time values and display the result in hours.
How to combine a date and a time in Excel
Learn how to merge separate date and time columns into a single timestamp using simple addition.
How to Insert Today's Date in Excel
Learn how to quickly insert a static date into your spreadsheet using a simple keyboard shortcut.
How to Calculate Percentage Change in Excel
Learn how to calculate the percentage difference between two values using a simple Excel formula.
How to Calculate Percent of Total in Excel
Learn how to divide individual values by a grand total to find their percentage contribution.
How to Calculate Compound Interest in Excel
Learn how to use the FV function to calculate compound interest for your investments.
How to Calculate a Loan Payment in Excel
Learn how to use the PMT function to determine your periodic loan payments.
How to Calculate CAGR in Excel
Learn how to determine the Compound Annual Growth Rate using the RRI function or a standard power formula.
How to Group Rows and Columns in Excel
Learn how to create collapsible outline groups to organize and hide data in your Excel worksheets.
How to Add Subtotals in Excel
Learn how to automatically calculate subtotals for grouped data using the Subtotal feature.
How to Hide and Unhide Columns in Excel
Learn how to easily manage your workspace by hiding and revealing specific columns in Excel.
How to Autofit Column Width in Excel
Quickly resize columns to fit the longest content in your cells.
How to Insert Multiple Rows in Excel
Learn how to quickly add several rows to your spreadsheet at once using the selection method.
How to Add Borders to Cells in Excel
Learn how to use the Borders dropdown and Format Cells dialog to customize cell outlines in Excel.
How to Insert a Hyperlink in Excel
Learn how to link text or objects to websites, files, or specific cells within your workbook.
How to Apply Strikethrough in Excel
Learn how to cross out text in your cells using keyboard shortcuts or the Format Cells menu.
How to Insert Symbols and Special Characters in Excel
Learn how to add non-keyboard characters like currency symbols, checkmarks, or mathematical signs to your cells.
How to Add a Header and Footer in Excel
Learn how to insert custom headers and footers using the Page Layout view in Excel.
How to print a spreadsheet on one page in Excel
Learn how to automatically scale your Excel worksheet to fit perfectly onto a single printed page.
How to Insert a Comment or Note in Excel
Learn how to add collaborative comments or private notes to specific cells in your Excel worksheets.
How to use Goal Seek in Excel
Use Goal Seek to find the specific input value needed to reach a desired target result.
How to use Data Validation in Excel
Restrict cell entries to specific types, lists, or ranges to ensure data accuracy.
How to create a dependent drop-down list in Excel
Learn how to make a second drop-down list update automatically based on the selection in the first list.
How to Create a Searchable Drop-Down List in Excel
Learn how to filter and search through long data validation lists using a helper column and dynamic formulas.
How to Insert a Checkbox in Excel
Learn how to add interactive checkboxes to your Excel worksheets using the Developer tab.
How to Create a Checklist in Excel
Learn how to add interactive checkboxes to your spreadsheet and track completion progress automatically.
How to Record a Macro in Excel
Automate repetitive tasks by recording your actions into VBA code.
How to Protect a Worksheet in Excel
Learn how to lock specific cells and restrict editing permissions on your Excel worksheets.
How to Protect a Workbook in Excel
Learn how to encrypt your Excel file with a password and restrict structural changes to your workbook.
How to count cells by color in Excel
Learn how to count cells based on their background color using a simple VBA function.
How to Sum Cells by Color in Excel
Learn how to calculate the sum of cells based on their background color using VBA or helper columns.