VR SCHOOL
ONLINE
Nexus Home
Course Catalog
Meta-Campus
Status
Enter The Nexus
Home
Courses
Part 1: Getting Started with Data Analysis
Curriculum
5 Sections
25 Lessons
10 Weeks
Expand all sections
Collapse all sections
Chapter 1: Learning Basic Data-Analysis Techniques
5
1.1
What Is Data Analysis, Anyway?
10 mins
1.2
Analyzing Data with Conditional Formatting
10 mins
1.3
Summarizing Data with Subtotals
10 mins
1.4
Grouping Related Data
10 mins
1.5
Consolidating Data from Multiple Worksheets
10 mins
Chapter 2: Working with Data-Analysis Tools
4
2.1
Working with Data Tables
10 mins
2.2
Analyzing Data with Goal Seek
10 mins
2.3
Analyzing Data with Scenarios
10 mins
2.4
Optimizing Data with Solver
10 mins
Chapter 3: Introducing Excel Tables
3
3.1
What Is a Table and Why Should I Care?
10 mins
3.2
Building a Table
10 mins
3.3
Analyzing Table Information
10 mins
Chapter 4: Grabbing Data from External Sources
4
4.1
What’s All This about External Data?
10 mins
4.2
Exporting Data from Other Programs
10 mins
4.3
Importing External Data into Excel
10 mins
4.4
Querying External Databases
10 mins
Chapter 5: Analyzing Table Data with Functions
9
5.1
The Database Functions: Some General Remarks
10 mins
5.2
Retrieving a Value from a Table
10 mins
5.3
Summing a Column’s Values
10 mins
5.4
Counting a Column’s Values
10 mins
5.5
Averaging a Column’s Values
10 mins
5.6
Determining a Column’s Maximum and Minimum Values
10 mins
5.7
Multiplying a Column’s Values
10 mins
5.8
Deriving a Column’s Standard Deviation
10 mins
5.9
Calculating a Column’s Variance
10 mins
This content is protected, please
login
and
enroll
in the course to view this content!
Modal title
Main Content