Data Analysis Basics with Excel and R

Offered By: Davidson College via edX

Course Description

Overview

Gain a strong foundation in data in two of the most commonly used programs R and Excel. In this professional certificate program, you have the opportunity to build and leverage your data skills for upward mobility at any stage in your career. You’ll learn the six steps of the data lifecycle, using different case studies and contexts. You will analyze, manage, and communicate data, working in R to achieve basic R programming competencies. You will gain a foundation on which you can build more advanced R skills in the future. You will then learn foundational Excel knowledge like spreadsheet and workbook anatomy, data entry, summary, and manipulation, plotting and visualization, and powerful tools such as filters, sorts, and pivot tables. This program will get you ready to do basic data manipulation, analysis, and visualizations and then be able to learn more advanced skills on your own, on the job, or in an advanced program.

Syllabus

Courses under this program:
Course 1: The Essentials of Data Literacy Online Course

Essentials of Data Literacy Course

Learn fundamental data skills with an online course that teaches you how to analyze, manage, and visualize data. Audit for free or obtain a certificate.

Course 2: Excel for Beginners

No prior knowledge or experience with Excel? No problem!

Mastering a basic skills in Excel will open the door to new opportunities, jobs, and more advanced skills that can help you be more efficient in your work or advance your career in your current or a future position. Come join us and reduce barriers to working with Excel!

Courses

0 reviews
4 weeks, 5-10 hours a week, 5-10 hours a week
View details

Learn data literacy online using R programming

What is data literacy and why is it important? In this data literacy course, you will learn how to become data literate. This will be accomplished by performing data analysis, data visualization, and communicating with data, using real datasets and examples that are relevant to a variety of audiences and academic disciplines. Data is part of every field, but not everyone has had the opportunity to gain the skills necessary to find the data they need and use it in ways that add to their work. Whether you are in public health, healthcare, banking, law, education, graduate school, or a variety of other fields, there is a way to understand and make use of related data.

Earn your data literacy certificate online

This free four-week course will give you the opportunity to build and leverage your data skills for upward mobility at any stage in your career. It will take you through the six steps of the data lifecycle, using different case studies and contexts, and teach you how to analyze, manage, and communicate data, working in R to achieve basic R programming competencies. R is a statistical programming language that is a great resource to analyze data, manage data, and visualize data.

No experience is required to learn this in-demand skill. By the end of this data literacy training course, you will be able to identify key principles of data analysis, use critical thinking skills, and become proficient in building powerful visuals. If you are interested in building a career in data analytics, first learning these foundational lessons is vital.

Photo by NASA on Unsplash

Taught by

Kevin Smith and Che Smith