Spreadsheets for Beginners using Google Sheets
44,049명이 이미 등록했습니다.
44,049명이 이미 등록했습니다.
This 2-hour long project-based course is an introduction to spreadsheets. We’ll be using Google Sheets in this project, which is the free spreadsheet program offered by Google. With that said, most of the concepts that you will learn in this project will be applicable to other spreadsheet programs, such as Microsoft Excel. We will cover the following concepts in a hands-on manner: - Basic data entry, formatting and calculations - Relative and absolute cell references - Basic functions: concatenate, split, sum, average, median, min, max, count, counta - Advanced functions: vlookup, if, and, or, iferror, countif, countifs, averageif, averageifs, sumif, sumifs - Dealing with error messages - Conditional formatting - Filtering and sorting - Basic charts to visualize our data We will end the project by applying these concepts and create a basic spreadsheet model that helps us analyze household expenses. Note: If you don't have a Google account, you will need to create one to be able to complete the content.
Data Visualization (DataViz)
작업 영역이 있는 분할 화면으로 재생되는 동영상에서 강사는 다음을 단계별로 안내합니다.
작업 영역은 브라우저에 바로 로드되는 클라우드 데스크톱으로, 다운로드할 필요가 없습니다.
분할 화면 동영상에서 강사가 프로젝트를 단계별로 안내해 줍니다.
DA 제공2020년 6월 2일
This course is really good for beginners like me who have zero knowledge about spreadsheets. This course helped me a lot to understand better and do simple task in google sheets.
CA 제공2021년 11월 16일
Great course, My first time doing spread sheet, Instructor was clear and precise. I am happy I took the this class, now I can feel more confident when I am doing a spread sheet.
MM 제공2020년 10월 27일
I don't know if it was my computer or my internet connection that made my workspace so slow to the extent that it would not respond. Other than that it was a nice learning experience.
RS 제공2020년 8월 2일
It was an wonderful learning and hats off to the instructor. Thanks a lot for the detail step by step guidance and explanation which makes the project very easy to understand and complete.