LONESTAR
ACADEMY
Courses
Log In
Join Free
Home
Courses
IT: Cybersecurity, Web & Productivity
Advanced Excel Statistical and Financial Analysis
Curriculum
1 Section
28 Lessons
30 hours
Expand all sections
Collapse all sections
Unit 3 — Advanced Excel Statistical and Financial Analysis
28
1.1
Determining the Nth Largest or Smallest Value
20 mins
1.2
Determining Rank and Percentile
20 mins
1.3
Determining the Regression
20 mins
1.4
An Observation Is an Observation
20 mins
1.5
Calculating a Loan Payment’s Principal and Interest
20 mins
1.6
Apply a PivotTable Style
20 mins
1.7
Consolidating Data from Multiple Worksheets
20 mins
1.8
Averaging a Column’s Values
20 mins
1.9
Refreshing PivotTable Data
20 mins
1.10
Inserting a Custom Calculated Item
20 mins
1.11
Calculating Forecasted Linear Values
20 mins
1.12
Creating a Grouped Frequency Distribution
20 mins
1.13
Generating Random Numbers
20 mins
1.14
Calculating the Correlation
20 mins
1.15
A Sample Is a Subset of Values
20 mins
1.16
Calculating Cumulative Loan Principal and Interest
20 mins
1.17
Create a Custom PivotTable Style
20 mins
1.18
Determining a Column’s Maximum and Minimum Values
20 mins
1.19
Adding Multiple Fields to a PivotTable Area
20 mins
1.20
Editing a Custom Calculation
20 mins
1.21
Plotting an Exponential Trend Line
20 mins
1.22
Calculating the Variance
20 mins
1.23
Creating a Frequency Distribution
20 mins
1.24
Calculating the Covariance
20 mins
1.25
Inferential Statistics Are Cool But Complicated
20 mins
1.26
Finding the Required Interest Rate
20 mins
1.27
Preserve PivotTable Formatting
20 mins
1.28
Multiplying a Column’s Values
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