Course Outline
Sparklines, Line, Column, Win/Loss
Dealing with duplicate values
Data List
Separate cells, joining cells
Conditional Formatting
Protect Worksheet, Cells
Data Label – Scores – analysis
Pivot Tables, Pivot Charts
Creating Custom Lists
Copying Worksheets
Inserting and Deleting Worksheets
Drop-Down Lists
Filtering data, Filter by Color
Page Break View, edit, remove
Inserting Charts
Repeating Cell Content
Formatting Worksheets
Cutting and Inserting Columns
Hiding/Unhiding Rows and Columns
Functions, If Function, datedif, SumIf, SumIfs, Lookup function, Vlookup, Count, CountA, CountIf, CountIfs, Concatenate, Sumproduct, Match.