Buy Now AED 170.99 + VAT

Monthly Subscription Starting at AED 99 + VAT

Excel Basics for Data Analysis
  • Level Foundation
  • المدة 12 ساعات hours
  • الطبع بواسطة IBM
  • Offered by

عن

Spreadsheet tools like Excel are an essential tool for working with data - whether for data analytics, business, marketing, or research. This course is designed to give you a basic working knowledge of Excel and how to use it for analyzing data. This course is suitable for those who are interested in pursuing a career in data analysis or data science, as well as anyone looking to use Excel for data analysis in their own domain. No prior experience with spreadsheets or coding is required - all you need is a device with a modern web browser and the ability to create a Microsoft account to access Excel online at no cost. If you have a desktop version of Excel, you can also easily follow along with the course. Throughout this course, you'll gain valuable experience working with data sets and spreadsheets. We'll start by introducing you to spreadsheets like Microsoft Excel and Google Sheets, and show you how to load data from multiple formats. From there, you'll learn how to perform basic data wrangling and cleansing tasks using functions, and expand your knowledge of data analysis through the use of filtering, sorting, and pivot tables. There is a strong focus on practice and applied learning in this course. With each lab, you'll have the opportunity to manipulate data and gain hands-on experience using Excel. You'll learn how to clean and format your data efficiently, and convert it into a pivot table to make it more organized and readable. The final project will allow you to showcase your newly acquired data analysis skills by working with real data sets and spreadsheets. By the end of this course, you'll have a solid foundation in using Excel for data analysis. You'll have worked with multiple data sets and spreadsheets, and will have the skills and knowledge needed to effectively clean and analyze data without having to learn any code. So let's get started!

الوحدات

Introduction to Spreadsheets for Data Analysis

    • 5 Videos
    • 1 Readings
    • 3 Plugin
    • 2 Assignment
Show info about module content

2 Assignment

  • Practice Quiz
  • Graded Quiz

5 Videos

  • Course Introduction
  • Introduction to Spreadsheets
  • Spreadsheet Basics - Part 1
  • Spreadsheet Basics - Part 2
  • Viewpoints: Using Spreadsheets as a Data Analysis Tool

1 Readings

  • Summary and Highlights

Getting Started Using Spreadsheets

    • 5 Videos
    • 1 Readings
    • 2 Plugin
    • 2 Assignment
Show info about module content

2 Assignment

  • Practice Quiz
  • Graded Quiz

5 Videos

  • Viewing, Entering, and Editing Data
  • Copying, Filling, and Formatting Cells and Data
  • The Basics of Formulas
  • Intro to Functions
  • Referencing Data in Formulas

1 Readings

  • Summary and Highlights

Basics of Data Quality and Privacy

    • 4 Videos
    • 1 Readings
    • 2 Assignment
Show info about module content

2 Assignment

  • Practice Quiz
  • Graded Quiz

4 Videos

  • Introduction to Data Quality
  • Importing File Data
  • Basics of Data Privacy
  • Viewpoints: Data Quality and Privacy

1 Readings

  • Summary and Highlights

Cleaning Data

    • 4 Videos
    • 2 Readings
    • 1 Plugin
    • 2 Assignment
Show info about module content

2 Assignment

  • Practice Quiz
  • Graded Quiz

4 Videos

  • Removing Duplicated or Inaccurate Data and Empty Rows
  • Dealing with Inconsistencies in Data
  • More Excel Features for Cleaning Data
  • Viewpoints: Issues with Data Quality

2 Readings

  • Disclaimer: About Flash Fill features covered in the next "More Excel Features for Cleaning Data" video
  • Summary and Highlights

Data Analysis Basics, Filtering and Sorting Data

    • 5 Videos
    • 1 Readings
    • 2 Plugin
    • 2 Assignment
Show info about module content

2 Assignment

  • Practice Quiz
  • Graded Quiz

5 Videos

  • 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

1 Readings

  • Summary and Highlights

Using Pivot Tables

    • 3 Videos
    • 1 Readings
    • 1 Plugin
    • 2 Assignment
Show info about module content

2 Assignment

  • Practice Quiz
  • Graded Quiz

3 Videos

  • Introduction to Creating Pivot Tables in Excel
  • Viewpoints: Pivot Tables
  • Pivot Table Features

1 Readings

  • Summary and Highlights

Final Course Project: Your First Deliverable as a Data Analyst

    • 1 PeerReview
    • 2 Plugin
Show info about module content

1 Peer Review

  • Final Assignment - Part 3: Submit Your Work and Peer Review

Course Wrap-Up

    • 2 Readings
Show info about module content

2 Readings

  • Congratulations and Next Steps
  • Course Credits and Acknowledgements

Auto Summary

"Excel Basics for Data Analysis" is designed for aspiring data analysts or anyone needing to use Excel for data analysis in various fields. Taught by Coursera, this foundational course requires no prior experience, only a device with a browser. It covers essential skills like data wrangling, cleansing, filtering, sorting, and creating pivot tables. With a strong emphasis on hands-on practice, learners will gain practical experience working with real data sets. The course spans 720 minutes and is available under the Starter subscription. Dive in to build a solid Excel foundation and enhance your data analysis capabilities.

Sandip Saha Joy
Instructors

Sandip Saha Joy

Steve Ryan
Instructors

Steve Ryan