Create Charts and Dashboard using Google Sheets
Perform basic functions and generate basic charts to visualize data.
Generate dynamic charts, sparklines and find duplicate data entries.
Learn how to use slicers and create a robust and dynamic dashboard.
인터뷰에서 이 안내형 체험 보여주기
In this 2-hour long project-based course, you will learn how to create effective charts and a dynamic dashboard to visualize data sets. You will be able to work with vlookups, pivot tables and basic formulas and be able to create dynamic charts, sparklines, and a robust, dynamic dashboard to present the data. By the end of the project you will be able to: - Understand the terminologies of spreadsheets - Work with basic formulas in Google Sheets - Create 8 Basic Charts for visualizing data - Generate Dynamic Charts from a dropdown list - Generate Sparklines to represent data - Build a dashboard and introduce Basic and Advanced Charts - Use Slicers to filter data and create a robust and dynamic dashboard Note: If you don't have a Google account, you will need to create one to be able to complete the content.
Familiarity with Google Sheets or Microsoft Excel is helpful but not required.
개발할 기술
- Spreadsheet
- Google Sheets
- Charts and Graphs
- Data Analysis
- Data Visualization (DataViz)
단계별 학습
작업 영역이 있는 분할 화면으로 재생되는 동영상에서 강사는 다음을 단계별로 안내합니다.
Introduction + Log In to Google Sheets
Basic formulas in Google Sheets
Introducing 8 Basic Charts
Dynamic Charts
Sparklines
Building Dashboard Part 1 - Basic Charts
Building Dashboard Part 2 - Advanced Charts
Building Dashboard Part 3 - Slicers
안내형 프로젝트 진행 방식
작업 영역은 브라우저에 바로 로드되는 클라우드 데스크톱으로, 다운로드할 필요가 없습니다.
분할 화면 동영상에서 강사가 프로젝트를 단계별로 안내해 줍니다.
검토
CREATE CHARTS AND DASHBOARD USING GOOGLE SHEETS의 최상위 리뷰
It was really Great Guide project for beginners ,Those who want the basic knowledge or Good Foundation in this particular Topic .I learnt a Good Basic Knowledge regarding this topic.
the cloud worksheets was a struggle because operation was slow... I don't know if the problem was with my laptop or it is naturally slow. But overload, it was very informative
It's a great course. Thank you. But, since it is meant for beginners. the instructor may want to explain why she chooses a particular formula over (similar sounding) others.
It was great experience to learn , how to use Google-sheets. Instructor guide me very well. i recommended this course to everyone who wanted to enhance their IT skills.
자주 묻는 질문
자주 묻는 질문
데스크톱과 모바일에서 안내 프로젝트를 이용할 수 있습니까?
안내 프로젝트 강사는 누구입니까?
작업 완료 후 안내 프로젝트에서 해당 작업을 다운로드할 수 있습니까?
이 안내 프로젝트를 수행하려면 경험이 얼마나 필요합니까?
소프트웨어를 별도로 설치하지 않아도 바로 웹 브라우저를 통해 이 안내 프로젝트를 완료할 수 있습니까?
안내 프로젝트를 통해 어떤 학습 경험을 할 수 있습니까?
궁금한 점이 더 있으신가요? 학습자 도움말 센터를 방문해 보세요.
Coursera Footer
