Save For Later

Data Analysis Basics with Excel

Save For Later

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.

What you'll learn

  • Master the foundations of data management, including dataset identification, preparation, and lifecycle.
  • Identify and analyze different types of data visualizations and when to use them effectively.
  • Establish good practices for data entry, storage, and manipulation in spreadsheets.
  • Practice common methods of data manipulation and summary such as sorting, filtering, writing simple equations, and using pivot tables.

Read More

OpenCourser is an affiliate partner of edX and may earn a commission when you buy through our links.

From DavidsonX, Davidson College via edX
Hours 22
Instructors Che Smith, Kevin Smith
Language English
Subjects Data Science

Similar Courses

Sorted by relevance

Careers

An overview of related careers and their average salaries in the US. Bars indicate income percentile (33rd - 99th).

Data Order Entry $30k

DATA PROCESSING AND DATA ENTRY $30k

IT/Data Entry $40k

Regional Data Entry $43k

Data Entry Trainer $44k

IT Data Entry $45k

Data Entry/ Operations $46k

Compensation Data Entry $48k

Data Entry - Drafting $51k

Data entry operations $52k

Remote Data Entry $60k

SAP Data Entry $65k

Courses in this Professional Certificate

Listed in the order in which they should be taken

Starts Course Information

On Demand

The Essentials of Data Literacy Online Course

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

edX | DavidsonX, Davidson College

Save

On Demand

Excel for Beginners

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

edX | Davidson College

Save

edX

&

DavidsonX, Davidson College

From DavidsonX, Davidson College via edX
Hours 22
Instructors Che Smith, Kevin Smith
Language English
Subjects Data Science

Careers

An overview of related careers and their average salaries in the US. Bars indicate income percentile (33rd - 99th).

Data Order Entry $30k

DATA PROCESSING AND DATA ENTRY $30k

IT/Data Entry $40k

Regional Data Entry $43k

Data Entry Trainer $44k

IT Data Entry $45k

Data Entry/ Operations $46k

Compensation Data Entry $48k

Data Entry - Drafting $51k

Data entry operations $52k

Remote Data Entry $60k

SAP Data Entry $65k

Similar Courses

Sorted by relevance