LONESTAR
ACADEMY
Courses
Log In
Join Free
Home
Courses
IT: Cybersecurity, Web & Productivity
Advanced Excel Analysis & Forecasting
Curriculum
1 Section
27 Lessons
30 hours
Expand all sections
Collapse all sections
Unit 4 — Advanced Excel Analysis & Forecasting
27
1.1
Pivoting a Field to a Different Area
20 mins
1.2
Deleting a Custom Calculation
20 mins
1.3
Calculating Exponential Trend Values
20 mins
1.4
Calculating the Standard Deviation
20 mins
1.5
Using the Anova Tools
20 mins
1.6
Probability Distributions Aren’t Always Confusing
20 mins
1.7
Determining the Internal Rate of Return
20 mins
1.8
Rename the PivotTable
20 mins
1.9
Deriving a Column’s Standard Deviation
20 mins
1.10
Grouping PivotTable Values
20 mins
1.11
Plotting a Logarithmic Trend Line
20 mins
1.12
Finding the Correlation
20 mins
1.13
Performing an f-Test
20 mins
1.14
Parameters Aren’t So Complicated
20 mins
1.15
Calculating Straight-Line Depreciation
20 mins
1.16
Turn Off Grand Totals
20 mins
1.17
Calculating a Column’s Variance
20 mins
1.18
Filtering PivotTable Values
20 mins
1.19
Plotting a Power Trend Line
20 mins
1.20
Skewness and Kurtosis Describe a Probability Distribution’s Shape
20 mins
1.21
Returning the Fixed-Declining Balance Depreciation
20 mins
1.22
Reduce the Size of PivotTable Workbooks
20 mins
1.23
Plotting a Polynomial Trend Line
20 mins
1.24
Confidence Intervals Seem Complicated at First But Are Useful
20 mins
1.25
Determining the Double-Declining Balance Depreciation
20 mins
1.26
Use a PivotTable Value in a Formula
20 mins
1.27
Creating a Forecast Sheet
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