Data Analysis Basics with Excel and R

Davidson College via edX Professional Certificate

Go to class Write review

Details

Go to class

Provider

edX Professional Certificate
Pricing

$498.00
Languages

English
Certificate

Certificate Available
Effort

8 weeks, 3-10 hours a week
Sessions

Self-Paced
Level

Beginner

Found in

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

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.
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

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
1 review

View details

If you’re seeking to grow your knowledge of spreadsheets from zero to basic comfort and competence in Excel, then this is a perfect course for you.

The goal of this course is to provide you with a foundation on which you can build more advanced skills in the future. In this online course you will learn foundational Microsoft Excel (also applicable to Google Sheets) knowledge including spreadsheet and workbook anatomy, data entry, summary, and manipulation, plotting and visualization, and powerful tools such as functions, conditional formatting, vlookup, mathematical formulas, graphs, macros, keyboard shortcuts, cell references, filters, sorts, and pivot tables.

Not only will this Excel tutorial provide you with a step-by-step training to obtain strong skills in Excel basics, but you will also find several pathways to continue learning the skills you need after the course. Basic Excel skills are required for many jobs, but more advanced skills are often learned on the job. This course can help you quickly get to the point of being able to learn more advanced skills on your own or on the job.

The approach of this course will be different from a typical software course. Rather than focusing on moving through as many tools and skills as quickly as possible, this course will emphasize gaining comfort and familiarity with some of the most useful and foundational skills, the skills that will be key to your success in using Excel now and in the future. You will have the opportunity to practice these skills and identify general principles of successfully working with spreadsheets to be more efficient, reliable, and effective in your work.