Excel Basics for Data Analysis

Instructor: Sandip Saha Joy , Steve Ryan

Beginner Level • 1 week at 10 hours a week • Flexible Schedule

What You'll Learn

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

Skills You'll Gain

Excel Formulas
Microsoft Excel
Data Cleansing
Data Import/Export
Pivot Tables And Charts
Information Privacy
Data Manipulation
Data Quality
Data analysis
Google Sheets
Data Wrangling
Data Visualization Software
Spreadsheet Software

Shareable Certificate

Earn a shareable certificate to add to your LinkedIn profile

Outcomes

  • Learn new concepts from industry experts
  • Gain a foundational understanding of a subject or tool
  • Develop job-relevant skills with hands-on projects
  • Earn a shareable career certificate

There are 5 modules in this course

In this module, you will learn about the fundamentals of spreadsheet applications, and you will be introduced to the Excel interface and learn how to navigate your way around a worksheet and workbook.

In this module you will learn how to perform basic spreadsheet tasks, such as viewing, entering and editing data, and moving, copying and filling data. In addition, you will learn about the fundamentals of formulas, and learn about the most common functions used by a data analyst. Finally, you will learn how to reference data in formulas.

In this module, you will learn about the importance of data quality, and you will learn how to import file data in to Excel. You will also learn about the fundamentals of data privacy. In addition, you will learn how to remove duplicate and inaccurate data, and how to remove empty rows in your data. Finally, you will learn how to deal with inconsistencies in your data and how to use the Flash Fill and Text to Columns features to help you manipulate and standardize your data.

In this module, you will learn about the fundamentals of analyzing data using a spreadsheet, and learn how to filter and sort data. You will also learn how to use some of the most useful functions for a data analyst, and how to use the VLOOKUP and HLOOKUP reference functions. In addition, you will learn how to create pivot tables in Excel, and use several pivot table features.

Great! You have now completed all four modules of this course. In this final module, you will be introduced to a hands-on lab where you will complete a graded assignment for cleaning and preparing data, and then analyzing data using an Excel spreadsheet. This final assignment will be graded by your peers.