Skip to content
Home
Programs
Close Programs
Open Programs
Cybersecurity
Courses
Community
News
Knowledgebase
GIS
Courses
Community
News
Knowledgebase
Agile Methodologies
Courses
Community
News
Knowledgebase
Catalog
About
News
Contact Us
Login
Sign Up
Login
Sign Up
Login
Sign Up
Home
All Programs
Computers
Data Science
Data Analytics
Getting Started with Data Analysis
Getting Started with Data Analysis
Curriculum
5 Sections
25 Lessons
Lifetime
Expand all sections
Collapse all sections
Chapter 1: Learning Basic Data-Analysis Techniques
10
1.1
What Is Data Analysis, Anyway?
1.1
Quiz for What Is Data Analysis, Anyway?
7 Questions
1.2
Analyzing Data with Conditional Formatting
1.2
Quiz for Analyzing Data with Conditional Formatting
6 Questions
1.3
Summarizing Data with Subtotals
1.3
Quiz for Summarizing Data with Subtotals
5 Questions
1.4
Grouping Related Data
1.4
Quiz for Grouping Related Data
5 Questions
1.5
Consolidating Data from Multiple Worksheets
1.5
Quiz for Consolidating Data from Multiple Worksheets
6 Questions
Chapter 2: Working with Data-Analysis Tools
8
2.1
Working with Data Tables
2.1
Quiz for Working with Data Tables
6 Questions
2.2
Analyzing Data with Goal Seek
2.2
Quiz for Analyzing Data with Goal Seek
6 Questions
2.3
Analyzing Data with Scenarios
2.3
Quiz for Analyzing Data with Scenarios
6 Questions
2.4
Optimizing Data with Solver
2.4
Quiz for Optimizing Data with Solver
7 Questions
Chapter 3: Introducing Excel Tables
6
3.1
What Is a Table and Why Should I Care?
3.1
Quiz for What Is a Table and Why Should I Care?
6 Questions
3.2
Building a Table
3.2
Quiz for Building a Table
5 Questions
3.3
Analyzing Table Information
3.3
Quiz for Analyzing Table Information
7 Questions
Chapter 4: Grabbing Data from External Sources
8
4.1
What’s All This about External Data?
4.1
Quiz for What’s All This about External Data?
5 Questions
4.2
Exporting Data from Other Programs
4.2
Quiz for Exporting Data from Other Programs
8 Questions
4.3
Importing External Data into Excel
4.3
Quiz for Importing External Data into Excel
6 Questions
4.4
Querying External Databases
4.4
Quiz for Querying External Databases
7 Questions
Chapter 5: Analyzing Table Data with Functions
18
5.1
The Database Functions: Some General Remarks
5.1
Quiz for The Database Functions: Some General Remarks
7 Questions
5.2
Retrieving a Value from a Table
5.2
Quiz for Retrieving a Value from a Table
5 Questions
5.3
Summing a Column’s Values
5.3
Quiz for Summing a Column’s Values
6 Questions
5.4
Counting a Column’s Values
5.4
Quiz for Counting a Column’s Values
5 Questions
5.5
Averaging a Column’s Values
5.5
Quiz for Averaging a Column’s Values
5 Questions
5.6
Determining a Column’s Maximum and Minimum Values
5.6
Quiz for Determining a Column’s Maximum and Minimum Values
6 Questions
5.7
Multiplying a Column’s Values
5.7
Quiz for Multiplying a Column’s Values
5 Questions
5.8
Deriving a Column’s Standard Deviation
5.8
Quiz for Deriving a Column’s Standard Deviation
6 Questions
5.9
Calculating a Column’s Variance
5.9
Quiz for Calculating a Column’s Variance
6 Questions
This content is protected, please
login
and
enroll
in the course to view this content!
Login
or
Sign Up
Home
Programs
Close Programs
Open Programs
Cybersecurity
Courses
Community
News
Knowledgebase
GIS
Courses
Community
News
Knowledgebase
Agile Methodologies
Courses
Community
News
Knowledgebase
Cybersecurity
Courses
Community
News
Knowledgebase
Catalog
About
News
Contact Us
Linkedin
Instagram
Modal title
Main Content
