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

Register for this free course here: {externalLink} text=\"COVID-19: What You Need to Know\" ... more
This capstone course in the Health Informatics Specialization will allow learners to create a comprehensive plan for an informatics intervention of their choosing, and that will demonstrate to... more
This course provides a comprehensive guide to mastering Visual Studio Code for C# developers. Starting with an introduction to the basics of VS Code, you\'ll learn how to set up the editor,... more
Using the pay statement as our roadmap, this course covers the basics of payroll that everyone who receives a paycheck should know. Starting with your classification as an employee, you\'ll learn... more
The field of analytics is typically built on four pillars: Descriptive Analytics, Predictive Analytics, Causal Analytics, and Prescriptive Analytics. Descriptive analytics (e.g., visualization, BI)... more

CONTINUE SEARCH

FOLLOW COLLEGE PARENT CENTRAL