This course is designed to provide you with basic working knowledge for using Excel spreadsheets for Data Analysis. It covers some of the first steps for working with spreadsheets and their usage in the process of analyzing data. It includes plenty of videos, demos, and examples for you to learn, followed by step-by-step instructions for you to apply and practice on a live spreadsheet.
課程信息
您將獲得的技能
提供方

IBM
IBM offers a wide range of technology and consulting services; a broad portfolio of middleware for collaboration, predictive analytics, software development and systems management; and the world's most advanced servers and supercomputers. Utilizing its business consulting, technology and R&D expertise, IBM helps clients become "smarter" as the planet becomes more digitally interconnected. IBM invests more than $6 billion a year in R&D, just completing its 21st year of patent leadership. IBM Research has received recognition beyond any commercial technology research organization and is home to 5 Nobel Laureates, 9 US National Medals of Technology, 5 US National Medals of Science, 6 Turing Awards, and 10 Inductees in US Inventors Hall of Fame.
教學大綱 - 您將從這門課程中學到什麼
Introduction to Data Analysis Using Spreadsheets
In this module, you will learn about the fundamentals of spreadsheet applications, and you will be introduced to the Excel interface and learn how to navigate your way around a worksheet and workbook.
Getting Started with Using Excel Speadsheets
In this module you will learn how to perform basic spreadsheet tasks, such as viewing, entering and editing data, and moving, copying and filling data. In addition, you will learn about the fundamentals of formulas, and learn about the most common functions used by a data analyst. Finally, you will learn how to reference data in formulas.
Cleaning & Wrangling Data Using Spreadsheets
In this module, you will learn about the importance of data quality, and you will learn how to import file data in to Excel. You will also learn about the fundamentals of data privacy. In addition, you will learn how to remove duplicate and inaccurate data, and how to remove empty rows in your data. Finally, you will learn how to deal with inconsistencies in your data and how to use the Flash Fill and Text to Columns features to help you manipulate and standardize your data.
Analyzing Data Using Spreadsheets
In this module, you will learn about the fundamentals of analyzing data using a spreadsheet, and learn how to filter and sort data. You will also learn how to use some of the most useful functions for a data analyst, and how to use the VLOOKUP and HLOOKUP reference functions. In addition, you will learn how to create pivot tables in Excel, and use several pivot table features.
審閱
來自EXCEL BASICS FOR DATA ANALYSIS的熱門評論
Exceptional. Very good for a beginner and intermediate learner. I needed this course to refresh myself on some excel skills and I achieved my goal. Thank you IBM & Cousera!
Great course. Really teaches you the basis. Only feedback is my name was spelled incorrectly on my certificate. But I'm sure that's an easy fix.
Very detailed and easy to follow but could be improved by having a dummy excel sheets for the students to work and follow with the instructor.
Very good for the basics and a little more, I think it could do with a couple more exercises on our own, otherwise a great base!
常見問題
我什么时候能够访问课程视频和作业?
我订阅此证书后会得到什么?
完成课程后,我会获得大学学分吗?
還有其他問題嗎?請訪問 學生幫助中心。