FRAMEWORK
ACADEMY
Courses
Log In
Join Free
Home
Courses
IT: Cybersecurity, Web & Productivity
Foundations of Excel Data Analysis
Curriculum
1 Section
28 Lessons
30 hours
Expand all sections
Collapse all sections
Unit 1 — Foundations of Excel Data Analysis
28
1.1
What Is Data Analysis, Anyway?
20 mins
1.2
Working with Data Tables
20 mins
1.3
What Is a Table and Why Should I Care?
20 mins
1.4
What’s All This about External Data?
20 mins
1.5
The Database Functions: Some General Remarks
20 mins
1.6
Understanding PivotTables
20 mins
1.7
Messing around with PivotTable Summary Calculations
20 mins
1.8
Introducing the PivotChart
20 mins
1.9
Understanding Excel Data Models
20 mins
1.10
Plotting a Best-Fit Trend Line
20 mins
1.11
Counting Things
20 mins
1.12
Loading the Analysis ToolPak
20 mins
1.13
Sampling Data
20 mins
1.14
Descriptive Statistics Are Straightforward
20 mins
1.15
Calculating Future Value
20 mins
1.16
Turn the PivotTable Fields Task Pane On and Off
20 mins
1.17
Analyzing Data with Conditional Formatting
20 mins
1.18
Analyzing Data with Goal Seek
20 mins
1.19
Building a Table
20 mins
1.20
Exporting Data from Other Programs
20 mins
1.21
Retrieving a Value from a Table
20 mins
1.22
Exploring PivotTable Features
20 mins
1.23
Working with PivotTable Subtotals
20 mins
1.24
Creating a PivotChart
20 mins
1.25
Managing a Data Model with Power Pivot
20 mins
1.26
Calculating Best-Fit Values
20 mins
1.27
Averaging Things
20 mins
1.28
Generating Descriptive Statistics
20 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