Back to Catalog

Excel Fundamentals for Data Analysis 

Premium
IntermediateCourse

Build essential skills in Excel that data analysts and data scientists use every day in just 5 weeks. No prior experience required.

Language

  • English

Topic

  • Data Analysis

Skills You Will Learn

  • Data Science, Data Analysis, Spreadsheet, Pivot Table, Microsoft Excel

Offered By

  • IBMSkillsNetwork

Estimated Effort

  • 11 hours

Platform

  • SkillsNetwork

Last Update

  • April 22, 2025
About this Course
Excel plays a crucial role in enhancing your ability to make informed decisions (Forbes). Aspiring data professionals, analysts, and scientists who can use Excel for key data analysis tasks are highly productive. This course gives you the solid foundation in Excel for data analysis you need to be of great value to an employer. No prior experience with spreadsheets or coding is required.  
  
During this course, you’ll gain hands-on experience with datasets and spreadsheets, starting with an introduction to Microsoft Excel and Google Sheets.  
  
You’ll learn how to:  
  • Load data 
  • Perform basic data wrangling  
  • Perform basic cleansing 
  • Filter 
  • Sort 
  • Use pivot tables.  
Throughout the course, you’ll get lots of opportunities to apply your knowledge in practice. You’ll complete labs where you’ll manipulate data and gain hands-on experience using Excel. Plus, you’ll master cleaning and formatting data efficiently and convert it into pivot tables. By the end of the course, you’ll have a strong foundation in using Excel for data analysis and the skills and knowledge to clean and analyze data effectively.  
  
If you want to build essential skills in Excel that data analysts and data scientists use every day, enroll now and get ready to add new competencies to your resume! 

Course Syllabus

Module 1: Introduction to Data Analysis using Spreadsheets 
Module 2: Getting Started Using Excel Spreadsheets 
Module 3: Cleaning and Wrangling Data Using Spreadsheets 
Module 4: Analyzing Data Using Spreadsheets 
Module 5: Final Project 

Learning Objectives

  • Display working knowledge of Excel for data analysis. 
  • Employ techniques to import and clean data in Excel. 
  • Perform basic tasks, including navigation, data entry, and formulas. 
  • Analyze data using filters, and features such as Sort, Look-up, and pivot tables

Recommended Skills Prior to Taking this Course

No prior skills recommended

Instructors

Sandip Saha Joy

Cognitive Data Scientist

An aspiring data scientist who enjoys connecting the dots: be it ideas from different disciplines, people from different teams, or applications from different industries. Have an academic background in computing science and strong technical skills in computer vision, machine learning and data science.

Read more

IBM Skills Network

IBM Skills Network Team

At IBM Skills Network, we know how crucial it is for businesses, professionals, and students to build hands-on, job-ready skills quickly to stay competitive. Our courses are designed by experts who work at the forefront of technological innovation. With years of experience in fields like AI, software development, cybersecurity, data science, business management, and more, our instructors bring real-world insights and practical, hands-on learning to every module. Whether you're upskilling yourself or your team, we will equip you with the practical experience and future focused technical and business knowledge you need to succeed in today’s ever-evolving world.

Read more