Skip to content
info@sejal-learn.com
Instagram
X-twitter
Youtube
Linkedin
Facebook
Login
Sign Up
info@sejal-learn.com
Instagram
X-twitter
Youtube
Linkedin
Facebook
Login
Sign Up
Course Catalog
About
Contact Us
Home
All Programs
Computers
Data Science
Data Analytics
Getting Started with Data Analysis
Curriculum
5 Sections
25 Lessons
10 Weeks
Expand all sections
Collapse all sections
Learning Basic Data-Analysis Techniques
10
1.1
What Is Data Analysis, Anyway?
1.2
Quiz for What Is Data Analysis, Anyway?
7 Questions
1.3
Analyzing Data with Conditional Formatting
1.4
Quiz for Analyzing Data with Conditional Formatting
6 Questions
1.5
Summarizing Data with Subtotals
1.6
Quiz for Summarizing Data with Subtotals
5 Questions
1.7
Grouping Related Data
1.8
Quiz for Grouping Related Data
5 Questions
1.9
Consolidating Data from Multiple Worksheets
1.10
Quiz for Consolidating Data from Multiple Worksheets
6 Questions
Working with Data-Analysis Tools
8
2.1
Working with Data Tables
2.2
Quiz for Working with Data Tables
6 Questions
2.3
Analyzing Data with Goal Seek
2.4
Quiz for Analyzing Data with Goal Seek
6 Questions
2.5
Analyzing Data with Scenarios
2.6
Quiz for Analyzing Data with Scenarios
6 Questions
2.7
Optimizing Data with Solver
2.8
Quiz for Optimizing Data with Solver
7 Questions
Introducing Excel Tables
6
3.1
What Is a Table and Why Should I Care?
3.2
Quiz for What Is a Table and Why Should I Care?
6 Questions
3.3
Building a Table
3.4
Quiz for Building a Table
5 Questions
3.5
Analyzing Table Information
3.6
Quiz for Analyzing Table Information
7 Questions
Grabbing Data from External Sources
8
4.1
What’s All This about External Data?
4.2
Quiz for What’s All This about External Data?
5 Questions
4.3
Exporting Data from Other Programs
4.4
Quiz for Exporting Data from Other Programs
8 Questions
4.5
Importing External Data into Excel
4.6
Quiz for Importing External Data into Excel
6 Questions
4.7
Querying External Databases
4.8
Quiz for Querying External Databases
7 Questions
Analyzing Table Data with Functions
18
5.1
The Database Functions: Some General Remarks
5.2
Quiz for The Database Functions: Some General Remarks
7 Questions
5.3
Retrieving a Value from a Table
5.4
Quiz for Retrieving a Value from a Table
5 Questions
5.5
Summing a Column’s Values
5.6
Quiz for Summing a Column’s Values
6 Questions
5.7
Counting a Column’s Values
5.8
Quiz for Counting a Column’s Values
5 Questions
5.9
Averaging a Column’s Values
5.10
Quiz for Averaging a Column’s Values
5 Questions
5.11
Determining a Column’s Maximum and Minimum Values
5.12
Quiz for Determining a Column’s Maximum and Minimum Values
6 Questions
5.13
Multiplying a Column’s Values
5.14
Quiz for Multiplying a Column’s Values
5 Questions
5.15
Deriving a Column’s Standard Deviation
5.16
Quiz for Deriving a Column’s Standard Deviation
6 Questions
5.17
Calculating a Column’s Variance
5.18
Quiz for Calculating a Column’s Variance
6 Questions
This content is protected, please
login
and
enroll
in the course to view this content!
Your Journey Starts Here
Course Catalog
About
Contact Us
Login/Sign Up
Modal title
Main Content
