Take your knowledge of Excel to the next level with charts, pivot tables, conditional formatting, IF functions, and more.
Example Curriculum
Course Overview
Available in
days
days
after you enroll
Introduction
Available in
days
days
after you enroll
Conditional Formatting
Available in
days
days
after you enroll
- Conditional Formatting Overview (3:18)
- Conditional Formatting Highlight Cells 1 (3:50)
- Conditional Formatting Highlight Cells 2 (2:40)
- Conditional Formatting Top Bottom Rules (2:12)
- Conditional Formatting Data Bars (3:21)
- Conditional Formatting Color Scales (3:47)
- Conditional Formatting Icon Sets (2:14)
- Conditional Formatting New Rules and Manage Rules (5:06)
- Conditional Formatting Multiple Rules (1:59)
- Remove Conditional Formatting (2:27)
Insert Symbols
Available in
days
days
after you enroll
Good Data Layout
Available in
days
days
after you enroll
PivotTables
Available in
days
days
after you enroll
Subtotaling and Grouping Data
Available in
days
days
after you enroll
Charts
Available in
days
days
after you enroll
- Overview and Basics (2:54)
- Column and Bar (7:18)
- Line (2:36)
- Pie and Doughnut (4:25)
- Scatter Plots (4:44)
- Changing Data (4:51)
- Chart Styles (2:45)
- Quick Layout (2:18)
- Change Colors Option (2:22)
- Chart Elements (4:15)
- Chart Size (2:03)
- Moving Chart and Chart Elements (2:55)
- Rename and Change Legend Labels (2:51)
- Element Color and Text Formatting (3:47)
- Formatting Task Pane (4:31)
Remove Duplicate Entries
Available in
days
days
after you enroll
Text to Columns
Available in
days
days
after you enroll
Concatenate
Available in
days
days
after you enroll
IF Functions
Available in
days
days
after you enroll
COUNTIFS
Available in
days
days
after you enroll
SUMIFS
Available in
days
days
after you enroll
TEXT Function
Available in
days
days
after you enroll
Limiting Allowed Inputs
Available in
days
days
after you enroll
Locking Cells or Worksheets
Available in
days
days
after you enroll
Hiding a Worksheet
Available in
days
days
after you enroll
Two-Variable Analysis Grid
Available in
days
days
after you enroll
Finding a Function
Available in
days
days
after you enroll
Other Resources
Available in
days
days
after you enroll
Conclusion
Available in
days
days
after you enroll