FRAMEWORK
ACADEMY
Courses
Log In
Join Free
Home
Courses
IT: Cybersecurity, Web & Productivity
Data Analysis and Modeling
Curriculum
1 Section
28 Lessons
30 hours
Expand all sections
Collapse all sections
Unit 2 — Data Analysis and Modeling
28
1.1
Using the t-Test Tools
20 mins
1.2
Averages Aren’t So Simple Sometimes
20 mins
1.3
Calculating Present Value
20 mins
1.4
Change the PivotTable Fields Task Pane Layout
20 mins
1.5
Summarizing Data with Subtotals
20 mins
1.6
Analyzing Data with Scenarios
20 mins
1.7
Analyzing Table Information
20 mins
1.8
Importing External Data into Excel
20 mins
1.9
Summing a Column’s Values
20 mins
1.10
Building a PivotTable from an Excel Range or Table
20 mins
1.11
Introducing Custom Calculations
20 mins
1.12
Working with PivotCharts
20 mins
1.13
Transforming Data
20 mins
1.14
Plotting Forecasted Values
20 mins
1.15
Finding the Rank
20 mins
1.16
Calculating a Moving Average
20 mins
1.17
Performing a z-Test
20 mins
1.18
Standard Deviations Describe Dispersion
20 mins
1.19
Determining Loan Payments
20 mins
1.20
Display the Details Behind PivotTable Data
20 mins
1.21
Grouping Related Data
20 mins
1.22
Optimizing Data with Solver
20 mins
1.23
Querying External Databases
20 mins
1.24
Counting a Column’s Values
20 mins
1.25
Creating a PivotTable from External Data
20 mins
1.26
Inserting a Custom Calculated Field
20 mins
1.27
Creating a PivotTable or PivotChart from Your Data Model
20 mins
1.28
Extending a Linear Trend
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