About this Course

This course is a part of the Data Foundations Nanodegree Program.

Spreadsheets are used across all business to store, analyze, and present information. Microsoft Excel is hands down the most common spreadsheet tool, and Excel skills will help you in just about any job. In this course, you'll start by learning the basics, like how to navigate a speadsheet, use shortcuts, and perform calculations. Then you'll dive deeper into more complex formulas and functions, like vlookups, pivot tables, and creating visualizations.

Skill Level
Beginner
Included in Course
  • Rich Learning Content

  • Interactive Quizzes

  • Taught by Industry Pros

  • Real World Projects

  • Student Support Community

  • Personalized Career Support

Join the Path to Greatness

This course is part of a Nanodegree Program. It is a step towards a new career in Data Foundations.

Nanodegree Course

Excel Fundamentals

Enhance your skill set and boost your hirability through innovative, independent learning.

Icon steps

What You Will Learn

Lesson 1

Excel Basics

  • In this lesson you'll learn to get started with spreadsheets: creating and saving a spreadsheet, basic operations, fill, and addressing.
Lesson 1

Excel Basics

  • In this lesson you'll learn to get started with spreadsheets: creating and saving a spreadsheet, basic operations, fill, and addressing.
Lesson 2

Manipulate Data

  • In this lesson, you'll learn to manipulate data in a spreadsheet: formulas, functions, removing duplicate rows, splitting columns, filtering, and sorting.
Lesson 2

Manipulate Data

  • In this lesson, you'll learn to manipulate data in a spreadsheet: formulas, functions, removing duplicate rows, splitting columns, filtering, and sorting.
Lesson 3

Analyze Data

  • In this lesson, you'll learn to analyze data in a spreadsheet: answer questions about the data using aggregation functions, logical functions, pivot tables, and lookup tables.
Lesson 3

Analyze Data

  • In this lesson, you'll learn to analyze data in a spreadsheet: answer questions about the data using aggregation functions, logical functions, pivot tables, and lookup tables.
Lesson 4

Visualize Data

  • In this lesson, you'll learn to present data professionally using spreadsheets: charts, histograms, box-plots, and formatting.
Lesson 4

Visualize Data

  • In this lesson, you'll learn to present data professionally using spreadsheets: charts, histograms, box-plots, and formatting.

Prerequisites and Requirements

This is a beginner course. No experience required!

See the Technology Requirements for using Udacity.

Why Take This Course

In the project for this course, you'll be given a spreadsheet of messy survey data. You'll use your Excel skills to organize and prepare the data, and then you'll use descriptive statistics to explore and summarize the data.

What do I get?
  • Instructor videos
  • Learn by doing exercises
  • Taught by industry professionals
Icon globe

Udacity 现已提供中文版本! A Udacity tem uma página em português para você! There's a local version of Udacity for you! Sprechen Sie Deutsch?

Besuchen Sie de.udacity.com und entdecken Sie lokale Angebote, unsere Partnerunternehmen und Udacitys deutschsprachigen Blog.

前往优达学城中文网站 Ir para a página brasileira Go to Indian Site Icon flag de Zu de.udacity.com continue in English