본문 바로가기

Data Analytics/Excel & GoogleSheets

Google Sheets basics

-Google Sheets shortcuts

https://support.google.com/docs/answer/181110

 

Google 스프레드시트용 단축키 - 컴퓨터 - Google Docs 편집기 고객센터

도움이 되었나요? 어떻게 하면 개선할 수 있을까요? 예아니요

support.google.com

 

-Google Sheets cheat sheet

https://support.google.com/a/users/answer/9300022

 

Google 스프레드시트 요약본 - Google Workspace 학습 센터

도움이 되었나요? 어떻게 하면 개선할 수 있을까요? 예아니요

support.google.com

 

-Sort and Filter your data

https://support.google.com/docs/answer/3540681?co=GENIE.Platform%3DDesktop&hl=en 

 

Sort & filter your data - Computer - Google Docs Editors Help

You can sort data in alphabetical and numerical order, or use filters to hide data you don't want to see. To get an example spreadsheet and follow along with the video, click “Make a Copy” below. Important: When you add a filter, anyone with access to

support.google.com

 

-Edit and Format a spreadsheet

https://support.google.com/docs/answer/46973?co=GENIE.Platform%3DDesktop&hl=en&oco=0 

 

Edit & format a spreadsheet - Computer - Google Docs Editors Help

You can add data to a spreadsheet, then edit or format the cells and data. Edit data in a cell   Open a spreadsheet in Google Sheets. Click a cell that’s empty, or double-click a cell that isn’t empty. Start typing. Optional: To add another line withi

support.google.com

 

'Data Analytics > Excel & GoogleSheets' 카테고리의 다른 글

Converting data  (0) 2023.06.11
새로 알게 된 기능  (0) 2023.05.28
Keyboard Shortcuts for Functions  (0) 2023.05.25
Errors and fixes  (0) 2023.05.25
Microsoft Excel basics  (0) 2023.05.23