Explore

Introduction to Data Analysis Using Excel

Approx. 20 hours to complete

Save Course

Go to Course

Course Summary

Learn how to use Excel for data analysis, including techniques for organizing and visualizing data, and creating interactive dashboards.

Key Learning Points

Understand how to use Excel for data analysis
Learn techniques for organizing and visualizing data
Create interactive dashboards

Learning Outcomes

Ability to use Excel for data analysis
Skills in organizing and visualizing data
Ability to create interactive dashboards

Prerequisites or good to have knowledge before taking this course

Basic knowledge of Excel
Access to Microsoft Excel

Course Difficulty Level

Beginner

Course Format

Online self-paced
Video lectures
Hands-on exercises

Similar Courses

Data Management and Visualization
Data Analysis and Presentation Skills: the PwC Approach
Data Analysis with Python

Related Books

Description

The use of Excel is widespread in the industry. It is a very powerful data analysis tool and almost all big and small businesses use Excel in their day to day functioning. This is an introductory course in the use of Excel and is designed to give you a working knowledge of Excel with the aim of getting to use it for more advance topics in Business Statistics later. The course is designed keeping in mind two kinds of learners - those who have very little functional knowledge of Excel and those who use Excel regularly but at a peripheral level and wish to enhance their skills. The course takes you from basic operations such as reading data into excel using various data formats, organizing and manipulating data, to some of the more advanced functionality of Excel. All along, Excel functionality is introduced using easy to understand examples which are demonstrated in a way that learners can become comfortable in understanding and applying them.

To successfully complete course assignments, students must have access to a Windows version of Microsoft Excel 2010 or later. ________________________________________ WEEK 1 Module 1: Introduction to Spreadsheets In this module, you will be introduced to the use of Excel spreadsheets and various basic data functions of Excel. Topics covered include: • Reading data into Excel using various formats • Basic functions in Excel, arithmetic as well as various logical functions • Formatting rows and columns • Using formulas in Excel and their copy and paste using absolute and relative referencing ________________________________________ WEEK 2 Module 2: Spreadsheet Functions to Organize Data This module introduces various Excel functions to organize and query data. Learners are introduced to the IF, nested IF, VLOOKUP and the HLOOKUP functions of Excel. Topics covered include: • IF and the nested IF functions • VLOOKUP and HLOOKUP • The RANDBETWEEN function ________________________________________ WEEK 3 Module 3: Introduction to Filtering, Pivot Tables, and Charts This module introduces various data filtering capabilities of Excel. You’ll learn how to set filters in data to selectively access data. A very powerful data summarizing tool, the Pivot Table, is also explained and we begin to introduce the charting feature of Excel. Topics covered include: • VLOOKUP across worksheets • Data filtering in Excel • Use of Pivot tables with categorical as well as numerical data • Introduction to the charting capability of Excel ________________________________________ WEEK 4 Module 4: Advanced Graphing and Charting This module explores various advanced graphing and charting techniques available in Excel. Starting with various line, bar and pie charts we introduce pivot charts, scatter plots and histograms. You will get to understand these various charts and get to build them on your own. Topics covered include • Line, Bar and Pie charts • Pivot charts • Scatter plots • Histograms

Outline

Introduction to Spreadsheets
Meet the Professor
Reading Data into Excel
Basic Data Manipulation in Excel
Arithmetic Manipulation in Excel
Basic Functions in Excel
Functions Using Absolute and Relative References
Functions Explained
Week 1 Recap
Course FAQs
Pre-Course Survey
Store Sales (Comma delimited).txt
Store Sales (Fixed width).txt
Stores Sales (Tab delimited Text).txt
Reading Data into Excel
Basic Data Manipulation in Excel
Arithmetic Manipulation in Excel
Basic Functions in Excel
Functions Using Absolute and Relative References
Functions Explained
Introduction to Spreadsheets

Spreadsheet Functions to Organize Data
The “IF” Command in Excel
The “IF” Command in Excel Using Numerical Data
The "Nested IF" Command in Excel
The "VLOOKUP" Function in Excel
Another "VLOOKUP" Example
The "HLOOKUP" Function in Excel
Professor 'Know-it-all' Needs Help!
Week 2 Recap
The "IF" Command in Excel
The “IF” Command in Excel Using Numerical Data
The "Nested IF" Command in Excel
The "VLOOKUP" Function in Excel
Another "VLOOKUP" Example
The "HLOOKUP" Function in Excel
Professor 'Know-it-all' Needs Help!
Spreadsheet Functions to Organize Data

Introduction to Filtering, Pivot Tables, and Charts
Using the “VLOOKUP” Function Across Worksheets
Data Filtering in Excel
Use of Pivot Tables in Excel
More Pivot Table Options
Application of Pivot Tables to Numeric Data
Introduction to Charts in Excel
Week 3 Recap
Using the “VLOOKUP” Function Across Worksheets
Data Filtering in Excel
Use of Pivot Tables in Excel
More Pivot Table Options
Application of Pivot Tables to Numeric Data
Introduction to Charts in Excel
Introduction to Filtering, Pivot Tables, and Charts

Advanced Graphing and Charting
Line Graphs
Bar Graphs and Pie Charts
Pivot Charts
Scatter Plots
Histograms Part 1
Histograms Part 2
Week 4 Recap
End-of-Course Survey
Line Graphs
Bar Graphs and Pie Charts
Pivot Charts
Scatter Plots
Histograms Part 1
Histograms Part 2
Advanced Graphing and Charting

Summary of User Reviews

Discover the power of Excel data analysis with this comprehensive course. Students rave about the course and the instructor's expertise in the subject matter. One key aspect that many users thought was good is the practicality of the course material, which is geared towards real-world applications.

Pros from User Reviews

The course material is practical and applicable to real-world scenarios
The instructor is knowledgeable and engaging
The course is well-structured and easy to follow
The assignments and quizzes provide excellent opportunities to practice and reinforce concepts
The course offers a great value for the price

Cons from User Reviews

Some users felt that the course could benefit from more advanced topics and exercises
A few users mentioned technical difficulties with the platform
A small number of users felt that the course was too basic or slow-paced

Recommended for you

Debugging and Unit Testing in Visual Studio 2017

Harness the power of tools and techniques in Visual Studio to test and debug applications Visual Studio 2017 brings powerful tools for testing, which help developers concentrate more on...

Save Course

Creative Programming for Digital Media & Mobile Apps

This course will teach you how to develop and apply programming skills to creative work. Additional resources will be provided for students with no programming background....

Save Course

Algorithms for DNA Sequencing

We will learn computational methods -- algorithms and data structures -- for analyzing DNA sequencing data. We will learn a little about DNA, genomics, and how DNA sequencing is used....

Save Course

Foundations of Computer Science

Welcome to Introduction to Programming: Visual Basic. In the course sequence you will learn to write programs that utilize both procedural and object oriented techniques to solve business problems....

Save Course