Analyzing Data with Excel
Please Note: Learners who successfully complete this IBM course can earn a skill badge — a detailed, verifiable and digital credential that profiles the knowledge and skills you’ve acquired in this course. Enroll to learn more, complete the course and claim your badge!
This course provides students with the fundamental knowledge required to use Excel spreadsheets to perform basic data analysis.The course consists of several videos, demos, examples, and hands-on labs to help you learn, and ends with a final assignment project which will help you put what you have learned into practice.
Excel is an important tool when working with data - whether it is for business, marketing, research, or data analysis purposes. This course is targeted at those people who have ambitions in Data Analytics or Data Scientist roles, as well as those who just have a need to use Excel to perform data analysis in their own company or environment.
Learners will gain useful experience in the cleaning and wrangling of data using functions, and in analyzing data using methods such as sorting, filtering, and pivot tables. This course starts with an introduction to spreadsheet applications such as Microsoft Excel and Google Sheets and discusses importing data from multiple different formats. During this introduction you will learn to carry out some basic-level data wrangling and data cleaning tasks and then you will expand your knowledge of data analysis via the use of sorting, filtering, and pivot tables in a spreadsheet.
The emphasis is on applied learning and hands-on practice in this course, and with each hands-on lab, you will gain further experience in the manipulation and handling of data and start to understand the important role that spreadsheets can perform in a data analysis environment. The final assignment project will allow you to apply these newly acquired skills to analyze data in a business scenario. By the end of this course, you will have worked with several data sets and spreadsheets and demonstrated the basics of cleaning and analyzing data all without having to learn any code.
This course makes it simple to get started using Excel for data analysis, as it does not require any previous spreadsheet or code-writing experience. The course also does not require you to perform any software downloads or installations. All that is required is a device with a modern web browser, and the ability to use (or create) a Microsoft account to access Excel online at no-cost. Although the hands-on labs steps are specifically related to using ‘Excel for the web’, if you already have the full desktop version of Excel, you should be able to use that to follow along quite easily with the labs.
What you'll learn
- The fundamentals of spreadsheet applications
- How to perform basic spreadsheet tasks
- About the importance of data quality
- How to import file data into Excel
- The fundamentals of analyzing data using a spreadsheet
- How to filter and sort data
- How to clean and prepare data
- How to analyze data using an Excel spreadsheet
Get a Reminder
Rating | Not enough ratings |
---|---|
Length | 5 weeks |
Effort | 5 weeks, 2–3 hours per week |
Starts | On Demand (Start anytime) |
Cost | $99 |
From | IBM via edX |
Instructors | Sandip Sasha Joy, Steve Ryan, Sandip Saha Joy |
Download Videos | On all desktop and mobile devices |
Language | English |
Subjects | Data Science |
Tags | Data Analysis & Statistics |
Get a Reminder
Similar Courses
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
Institutional Research Specialist in Data Analysis $42k
Professional-Data Analysis - SQL $63k
Business and Data Analysis $67k
Data Management and Analysis Fellowship - CDC $68k
Data Analyst, Marketing & Analysis $68k
Senior Data Analyst, Marketing & Analysis $77k
Data Scientist (Social Network Analysis) $84k
Analyst, R&D IT and Data Analysis Lead $88k
Data Management and Analysis Tech. $94k
Senior Data Analysis - ITSM Analyst $101k
Senior Data Analysis Engineer u2013 Engineering Data Analysis $149k
Data Architect - Financial Planning and Analysis $156k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
Rating | Not enough ratings |
---|---|
Length | 5 weeks |
Effort | 5 weeks, 2–3 hours per week |
Starts | On Demand (Start anytime) |
Cost | $99 |
From | IBM via edX |
Instructors | Sandip Sasha Joy, Steve Ryan, Sandip Saha Joy |
Download Videos | On all desktop and mobile devices |
Language | English |
Subjects | Data Science |
Tags | Data Analysis & Statistics |
Similar Courses
Sorted by relevance
Like this course?
Here's what to do next:
- Save this course for later
- Get more details from the course provider
- Enroll in this course