VR SCHOOL
ONLINE
Courses
Meta Campus
Log In
Join Free
Home
Courses
Excel Data Analysis Essentials
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!
S
Ask SIERA
YOUR DIGITAL ASSISTANT
×
Modal title
Main Content