Search

분석을 위한 피벗 테이블 사용

과정
데이터 분석을 통한 해답 찾기
날짜
2024/02/16

계산

Microsoft Excel

피벗 테이블에서 값 계산 - Microsoft 지원
여러 가지 방법을 사용하여 Excel의 피벗 테이블 보고서에 있는 계산 필드의 값을 계산할 수 있습니다.
https://support.microsoft.com/ko-kr/office/피벗-테이블에서-값-계산-11f41417-da80-435c-a5c6-b0185e59da77
Pivot table calculated field example
Standard Pivot Tables have a simple feature for creating calculated fields. You can think of a calculated field as a virtual column in the source data.
https://exceljet.net/pivot-tables/pivot-table-calculated-field-example
Archives - Power Spreadsheets
Power Spreadsheets is about Microsoft Excel and covers a variety of topics. This archive lists most of the blog posts published in Power Spreadsheets until today. Tips & Tricks 350 + Excel Keyboard Shortcuts And Hotkeys: Free PDF Cheat Sheet. Excel Keyboard Shortcuts: How To Quickly Get Or Create Any Keyboard Shortcut You Need. Convert […]
https://powerspreadsheets.com/archives/#Pivot-Tables

Google Sheets

피벗 테이블 만들기 및 사용하기 - 컴퓨터 - Google Docs 편집기 고객센터
직장이나 학교에서 Google Docs를 최대한 활용하고 싶으신가요?
https://support.google.com/docs/answer/1272900?co=GENIE.Platform=Desktop&hl=ko
Adding Calculated Field in Pivot Table in Google Sheets
You might have seen the option to add a calculated field in the Values field of the Pivot table in Google Sheets. Do you know how to use it?
https://infoinspired.com/google-docs/spreadsheet/all-about-calculated-field-in-pivot-table-in-google-sheets/
Pivot Tables in Google Sheets: A Beginner's Guide
Learn how to use Pivot Tables in Google Sheets. Pivot Tables are amazingly powerful and very easy to use once you know how.
https://www.benlcollins.com/spreadsheets/pivot-tables-google-sheets/

데이터 정렬

Microsoft Excel

피벗 테이블 또는 피벗 차트에서 데이터 정렬 - Microsoft 지원
피벗 테이블에서 항목이나 값의 정렬 순서를 변경할 수 있습니다.
https://support.microsoft.com/ko-kr/office/피벗-테이블-또는-피벗-차트에서-데이터-정렬-e41f7107-b92d-44ef-861f-24430830450a
Excel Pivot Tables - Sorting Data
Excel Pivot Tables - Sorting Data - You can sort the data in a PivotTable so that it will be easy for you to find the items you want to analyze. You can sort the data from lowest to highest values or highest to lowest values or in any other custom order that you choose.
https://www.tutorialspoint.com/excel_pivot_tables/excel_pivot_tables_sorting_data.htm
How to sort a pivot table by value
In this video, we show you how to sort items in your pivot table by value.
https://exceljet.net/videos/how-to-sort-a-pivot-table-by-value

Google Sheets

피벗 테이블 맞춤설정하기 - 컴퓨터 - Google Docs 편집기 고객센터
                비즈니스를 위한 고급 Google Work
https://support.google.com/docs/answer/7572895?co=GENIE.Platform=Desktop&hl=ko
How to Sort Pivot Table Columns in the Custom Order in Google Sheets
There is no built-in option to sort Pivot table columns in a custom order in Google Sheets. We should follow a workaround for that.
https://infoinspired.com/google-docs/spreadsheet/pivot-table-columns-in-custom-order-in-google-sheets/
Pivot Table Ascending Descending Order in Google Sheets and Excel: 1-Minute Ultimate Beginner’s…
Hi there!
https://medium.com/actiondesk/pivot-table-ascending-descending-order-in-google-sheets-and-excel-1-minute-ultimate-beginners-8f9f4c560492

데이터 필터링

Microsoft Excel

피벗 테이블의 데이터 필터링 - Microsoft 지원
Excel에서 슬라이서 및 기타 방법을 사용하여 데이터가 매우 많은 피벗 테이블을 필터링하면 데이터의 일부만 표시할 수 있어 심도 있는 분석이 가능합니다.
https://support.microsoft.com/ko-kr/office/피벗-테이블의-데이터-필터링-cc1ed287-3a97-4e95-b377-ddfafe79fa8f
How to Filter Excel Pivot Table Data - dummies
One cool thing you can do with Excel pivot tables is filtering. To filter sales by month, drag the Month PivotTable field to the Filters box. Excel re-cross-tab
https://www.dummies.com/article/technology/software/microsoft-products/excel/how-to-filter-excel-pivot-table-data-152376/

Google Sheets

피벗 테이블 맞춤설정하기 - 컴퓨터 - Google Docs 편집기 고객센터
                비즈니스를 위한 고급 Google Work
https://support.google.com/docs/answer/7572895?co=GENIE.Platform=Desktop&hl=ko
Filter Multiple Values in Pivot Table in Google Sheets
Do you know how to filter multiple values in the Pivot table "Filter by condition" in Google Sheets? There are two methods.
https://infoinspired.com/google-docs/spreadsheet/filter-multiple-values-in-pivot-table-sheets/

데이터 서식 지정

Microsoft Excel

피벗 테이블의 레이아웃 및 서식 디자인 - Microsoft 지원
Excel에서 피벗 테이블 데이터의 레이아웃과 서식을 변경하여 쉽게 읽고 검색할 수 있습니다.
https://support.microsoft.com/ko-kr/office/피벗-테이블의-레이아웃-및-서식-디자인-a9600265-95bf-4900-868e-641133c05a80

Google Sheets

Create & use pivot tables - Computer - Google Docs Editors Help
Want to get more out of Google Docs for work or school?
https://support.google.com/docs/answer/1272900?visit_id=638436618872109355-1701267774&rd=1#group_data_in_a_pivot_table