본문 바로가기

전체 글

 (23)
Keyboard Shortcuts for Functions
Errors and fixes It never feels good when you type in what you are sure is a perfect formula or function, only to get an error message. Understanding errors and how to fix them is a big part of keeping your data clean, so it's important to know how to deal with issues as they come up, and more importantly, not to get discouraged. -Coursera/Google Data Analytics certificate program Error Description Example #DIV/..
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..
Microsoft Excel basics -Microsoft Excel shortcuts https://support.microsoft.com/en-us/office/keyboard-shortcuts-in-excel-1798d9d5-842a-42b8-9c99-9b7213f0040f Keyboard shortcuts in Excel - Microsoft Support This article describes the keyboard shortcuts, function keys, and some other common shortcut keys in Excel for Windows. Notes: To quickly find a shortcut in this article, you can use the Search. Press Ctrl+F, and th..
[Coursera] Course 2. Ask Questions to Make Data-Driven Decisions WEEK 1 - Effective questions [Definition] -Structured thinking: The process of recognizing the current problem or situation, organizing available information, revealing gaps and opportunities, and identifying the options [Six problem types] -Making predictions: Using data to make an informed decision about how things may be in the future -Categorizing things: Assigning information to different g..
시계열 분석 시계열(time series: 시간 순으로 재정렬된 데이터의 배열) 데이터 분석 - 시간에 따른 데이터 변화 이해 및 정량화 - 주요 목표 중 하나는 예측
[Coursera] Course 1. Foundations: Data, Data, Everywhere WEEK 1 - Introducing data analytics [Definition] -Data: A collection of facts -Data analysis: The collection, transformation, and organization of data in order to draw conclusions, make predictions, and drive informed decision-making -Data analytics: The science of data -Data ecosystems: The various elements that interact with one another in order to produce, manage, store, organize, analyze, an..

티스토리툴바