Autoplay
Autocomplete
Previous
Complete and Continue
Data Analysis with Excel | Online Excel Course
Introduction
Introduction
Chapter 1: Getting Started!
Fill out your Student Profile
Install Microsoft Excel
Chapter 2: Introduction to Microsoft Excel: UI basics
Introduction: UI Basics
What is Excel?
Workbooks and Worksheets
Shortcuts
Rows, Columns, and Cells
Freeze Panes
Number Formats
Input Types
Cell Formatting
Paste Special
Sorting
Filtering
Conditional Formatting
Chapter 3: Function basics
Introduction: Function basics
What is a formula?
Basic mathematical functions
Basic cell references
Nested functions
Absolute and relative cell references
Using tables
Chapter 4: Mathematical functions
Introduction: Mathematical functions
Basic arithmetic
SUM
Cumulative SUM
SUMPRODUCT
AVERAGE
MAX
MIN
COUNT
COUNTA
LARGE
RANK
Chapter 5: String functions
Introduction: String functions
What is a String?
CONCATENATE
LEFT
RIGHT
MID
SEARCH
LEN
VALUE
Chapter 6: Dates and Times
Introduction: Dates and Times
Date and time overview
DAY, MONTH, YEAR, WEEKDAY
HOUR, MINUTE, SECOND
EOMONTH
Chapter 7: Logical functions
Introduction: Logical functions
TRUE and FALSE
Logical operators
AND OR
NOT
IF
SUMIF
SUMIFS
COUNTIF
COUNTIFS
AVERAGEIF
AVERAGEIFS
Chapter 8: Lookups
Introduction: Lookups
VLOOKUP + Exercise
HLOOKUP + Exercise
Index match + Exercise
Index MATCH MATCH + Exercise
Index MATCH multiple criteria + Exercise
Match types + Exercise
Offset + Exercise
Indirect + Exercise
Chapter 9: Pivot Tables
Introduction: Pivot Tables
What is a Pivot Table?
Preparing the data + Exercise
One-dimensional Pivots + Exercise
Formatting a Pivot Table + Exercise
Grouping Headings
Chapter 10: Charts
Introduction: Charts
Prepping chart data + Exercise
Creating the chart + Exercise
Formatting a chart + Exercise
Data labels and data tables + Exercise
Regressions + Exercise
Chapter 11: Building a model
Introduction: Building a model
What is a model?
Assumptions
Diagramming the flow + Exercise
Wireframing + Exercise
Preparing the data + Exercise
Linking up formulas + Exercise
Goalseek and solver + Exercise
Sensitivity analysis + Exercise
Chapter 12: Case Study: Forecasting with a Model
Introduction to Spreadsheet Modeling
Sample Excel Model: Springboard Office Space
How to build a great Excel model
Chapter 13: Case Study: Forecasting Sales of Chiboodle Inc.
Preview: Chiboodle Case
SUM
Contents locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock