Course Highlights
  • Display working knowledge of Excel for Data Analysis.
  • Perform basic spreadsheet tasks including navigation, data entry, and using formulas.
  • Employ data quality techniques to import and clean data in Excel.
  • Analyze data in spreadsheets by using filter, sort, look-up functions, as well as pivot tables.
Curriculum

11 Topics
Course Introduction
Introduction to Spreadsheets
Spreadsheet Basics - Part 1
Spreadsheet Basics - Part 2
Viewpoints: Using Spreadsheets as a Data Analysis Tool
Summary and Highlights
Graded Quiz
Practice Quiz
Reading: Excel Keyboard Shortcuts
Hands-on Lab: Getting Started with Excel Online
Hands-on Lab 2: Spreadsheet Basics

10 Topics
Viewing Entering and Editing Data
Copying Filling and Formatting Cells and Data
The Basics of Formulas
Intro to Functions
Referencing Data in Formulas
Summary and Highlights
Graded Quiz
Practice Quiz
Hands-on Lab 3: Entering and Formatting Data
Hands-on Lab 4: Simple Use of Functions

12 Topics
Introduction to Data Quality
Importing File Data
Basics of Data Privacy
Viewpoints: Data Quality and Privacy
Removing Duplicated or Inaccurate Data and Empty Rows
Dealing with Inconsistencies in Data
More Excel Features for Cleaning Data
Viewpoints: Issues with Data Quality
Summary and Highlights
Graded Quiz
Practice Quiz
Hands-on Lab 5: Cleaning Data

14 Topics
Intro to Analyzing Data Using Spreadsheets
Filtering and Sorting Data in Excel
Viewpoints: Filtering and Sorting
Useful Functions for Data Analysis
Using the VLOOKUP and HLOOKUP Functions
Introduction to Creating Pivot Tables in Excel
Viewpoints: Pivot Tables
Pivot Table Features
Summary and Highlights
Graded Quiz
Practice Quiz
Reading: Advanced Excel Formulas: COUNTIFS SUMIFS and XLOOKUP
Hands-on Lab 6: Filtering and Sorting Data
Hands-on Lab 7: Using Pivot Tables

5 Topics
Congratulations and Next Steps
Course Credits and Acknowledgements
Final Assignment - Part 3: Submit Your Work and Peer Review
Final Assignment - Part 1: Clean and Prepare the Data
Final Assignment - Part 2: Analyze the Data

  Write a Review

Excel Basics for Data Analysis

Go to Free Course