Juniata Classifieds>Juniata Online Courses>Introduction to Data Analysis using Microsoft Excel

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

This Specialization is well suited for managers, leaders, team members and others who work in diverse environments that require effective teamwork and communication with a wide array of... more
This course covers the essential information that every serious programmer needs to know about algorithms and data structures, with emphasis on applications and scientific performance analysis of... more
In this course students will learn the why the Spring Framework is one of the dominant Java development Frameworks. the course covers a variety of techniques for Java Object Dependency Injection... more
This is a self-paced lab that takes place in the Google Cloud console. Use BigQuery to explore the NCAA dataset of basketball games, teams, and players. The data covers plays from 2009 and scores... more
Do you think an e-commerce application can be created as one large application? Imagine there is an ongoing sale, or some new features are to be added. How, according to you are the changes made... more

CONTINUE SEARCH

FOLLOW COLLEGE PARENT CENTRAL