Introduction to Data Analysis using Microsoft Excel

About this Course

In this project, you will learn the foundation of data analysis with Microsoft Excel using sales data from a sample company. You will learn how to use sorting and filtering tools to reorganize your data and access specific information about your data. You will also learn about the use of functions like IF and VLOOKUP functions to create new data and relate data from different tables. Finally, you will learn how to create PivotTables to summarize and look at comparisons within your data. These skills will help you efficiently perform data analysis on many different types of data and give you the foundation to expand your toolbox as you explore other strategies for data analysis.

Created by: Coursera Project Network


Related Online Courses

In this lab you will schedule a Cloud Function to identify and clean up unused IP addresses.Created by: Google Cloud more
This specialization is designed for post-graduate students aiming to develop advanced skills in social media analytics and its practical applications. Through four comprehensive courses, learners... more
In this hands-on project, we will build and train an XG-Boost classifier to predict whether a person has a risk of having cervical cancer. Cervical cancer kills about 4,000 women in the U.S. and... more
To promote the engineering skills required for Digital Factories, this proposed specialization on Intelligent Digital Factories offer the learners with strong fundamentals of the microcontrollers... more
Organizations in every industry are accelerating their use of artificial intelligence and machine learning to create innovative new products and systems. This requires professionals across a range... more

CONTINUE SEARCH

FOLLOW COLLEGE PARENT CENTRAL