comp
COMP REVIEWER
Cell styles - combination of formatting options
Predefined styles - built in styles
Customization - create your own
Quick formatting - format cells quickly
Consistency- consistent formatting
How to use
Select a cell
Go to home tab
Choose a style
customize
Sparklines - miniature charts
Line sparkline - shows data trends overtime
Column sparkline - data vertical bars
win/loss sparkline - positive or negative values
Quick data analysis - spot at a quick glance
Compact visualization - fit inside a single cell
Dashboard reporting - quick summaries
Charts - powerful tools for visually representing data
Column chart - comparing different categories
Line chart - visualize trends overtime
Pie chart - slices of pie
Bar chart - easy comparisons
Area chart - combines the figure of line chart and bar chart, illustrates trend overtime
Scatter chart - represent data points for two variables in a two dimensional space
Map chart - geographical regions
Stock chart - displays stock prices data
Surface chart - shows relations among data
Slicers
- powerful filtering tool
- provide a clear, visual representation
- easier to use than drop-down filters
- allows multiple filters at once