My Excel Power

Level Up Lessons - Resource Folder

Excel Power eGuide

Keyboard Shortcuts

Excel Diagram

Excel Chart (Reference Guide)

Chart Types

Introduction to Charts in MS Excel

Excel Charts: Review the Basics

Excel Charts: Formatting Charts

Excel Charts: Update Charts

Excel Charts: Bar and Column Charts

Excel Charts: Line Chart

Excel Charts: Area Charts

Excel Charts: Histogram/Pareto Charts

Excel Charts: Pie and Donut Charts

Practice Assignment: Intro to Charts

Charts and Graphs Quiz

Excel Chart (Reference Guide)

Excel Creative Charts: Treemap and Sunburst Charts

Excel Creative Charts: Waterfall Charts

Excel Creative Charts: Funnel Charts

Excel Creative Charts: Box and Whiskers

Excel Creative Charts: Scatter Charts

Excel Creative Charts: Bubble Charts

Excel Creative Charts: Maps and Geography data type

Excel Creative Charts: Heat Maps

Excel Creative Charts: Radar Charts

Excel Creative Charts: Sparkline

Practice Assignment: Creative Charts

Creative Charts quiz

Pivot Charts (Reference Guide)

Pivot Tables: Introduction to Pivot Table

Pivot Tables: Working with Large Data Amounts

Pivot Tables: Data Filter Options

Pivot Tables: Slicers and Timelines

Pivot Tables: Refresh/Update Data

Pivot Tables: Auto Update Data Source

Pivot Tables: Table Design Options

Pivot Tables: Update Labels/Format Numbers

Pivot Tables: Report Layout Options

Pivot Tables: Conditioning Formatting Options

Pivot Tables: Grouping Data (Geography Data Source)

Practice Assignment: Pivot Tables

Pivot Table Quiz

Lookup Index Match (Reference Guide)

Introduction: Lookup, Index and Match Functions

Lookup: Lookup Function

Lookup: VLookup Function

Lookup: HLookup Function

Lookup: XLookup Function

Lookup: Index and Match

Lookup: Wildcards and Close Match

Practice Assignment: Lookup, Index, Match

Lookup, Index and Match Quiz