Introduction to Data Analysis using Microsoft Excel

Course Cover
compare button icon

Course Features

icon

Duration

2 hours

icon

Delivery Method

Online

icon

Available on

Limited Access

icon

Accessibility

Desktop, Laptop

icon

Language

English

icon

Subtitles

English

icon

Level

Intermediate

icon

Teaching Type

Self Paced

icon

Video Content

2 hours

Course Description

This project will teach you the basics of data analysis using Microsoft Excel. It will use sales data from a sample business. Learn how to use filtering and sorting tools to organize your data and get specific information. Learn about how to use functions such as IF and VLOOKUP to create new data or relate data from various tables. You will also learn how to create PivotTables that allow you to compare data. These skills will allow you to efficiently analyze data from many types and provide the foundation for expanding your data analysis toolbox.

Course Overview

projects-img

Virtual Labs

projects-img

International Faculty

projects-img

Case Based Learning

projects-img

Post Course Interactions

projects-img

Case Studies,Instructor-Moderated Discussions

projects-img

Case Studies, Captstone Projects

Skills You Will Gain

What You Will Learn

​Create an account with Microsoft Office 365 online and upload a document

U​se sorting and filtering tools to perform simple data analysis

U​se functions such as IF, VLOOKUP and create PivotTables to perform more advanced data analysis

Course Cover