Code&Data Insights
[Google Data Analytics Professional Certificate] Analyze Data to Answer Questions 본문
[Google Data Analytics Professional Certificate] Analyze Data to Answer Questions
paka_corn 2023. 5. 20. 08:40[ The 4-Phases of Analysis ]
1) Organize data
2) Format and adjust data
3) Get input from others
4) Transfrom data ( make calculation based on the data, find the relationship )
[ Organize data ]
- Sorting
: Sort Sheet in spreadsheet
: ORDER BY in SQL
- Filtering
: WHERE in SQL
[ Data Formatting ]
- From one type to another
: CAST in SQL
: CONVERT in spreadsheet
[ Data validation ]
Data validation
: allows you to control what can and can't be entered in the worksheet
(cut down. data cleaning process!)
: Data validation In Spreadsheet
=> add dropdown lists with predetermined options
=> create custom checkboxes
=> protect structured datas and formulas
- Conditional formatting In Spreadsheet
(using color code!)
https://learntocodewith.me/posts/excel-skills/
19 Most Useful Excel Skills, Functions & Formulas (Beginner to Advanced)
We've identified the most useful Excel skills for you, whether you want to learn how to become proficient in Excel or how to become an Excel expert.
learntocodewith.me
https://exceljet.net/functions
350 Excel Functions
Over 350 built-in functions, with examples and videos. VLOOKUP, XLOOKUP, INDEX & MATCH, FILTER, RANK, ROUND, SUMPRODUCT, AVERAGE, COUNTIFS, SUMIFS, UNIQUE, SORT, TEXTSPLIT, SEQUENCE, FIND, SEARCH, DATE, and more.
exceljet.net
500 Excel Formulas
Over 500 working Excel formulas with detailed explanations, videos, and related links. Includes key functions like VLOOKUP, XLOOKUP, INDEX & MATCH, FILTER, RANK, ROUND, AVERAGE, COUNTIFS, SUMIFS, UNIQUE, SORT, TEXTSPLIT, and more.
exceljet.net
https://www.slideshare.net/markjhonoxillo/advanced-spreadsheet-skills
Advanced Spreadsheet Skills - Empowerment Technologies
ADVANCED SPREADSHEET SKILLS Prepared by: Mark Jhon C. Oxillo What is a Spreadsheet Software? • allows users to organize data in rows an columns and perform ca...
www.slideshare.net
[ Data Aggregation ]
Data aggregation : the process of gathering data from multiple sources in order to combine it into a single summarized collection
< VLOOKUP - for Data Aggregation in spreadsheet >
VLOOKUP : it searches for a certain value in a spreadsheet column and returns a corresponding piece of information from the row in which the searched value is found.
- Populating data in a spreadsheet
- Merging data from one spreadsheet with data in another
https://www.youtube.com/watch?v=d3BYVQ6xIE4
[ ]
