Switch to the Home tab. Click on the Conditional Formatting Let’s add a few visualizations to this button. report to make it easy for end-users to understand the numbers. We’ll start with Conditional Formatting, a native feature of Excel. Then add Data bars to the annual numbers for each category. Select Data Bars. Select the Green Gradient Fill. Sparklines Click Instructions Presenter Script Switch to the Insert tab. Excel 2010 includes new formatting and visualization features that further enhance the way complex data can be visualized to improve understanding and help business users like Richard’s boss make better decisions. Click on the Line sparkline type. The new Sparklines feature works like a mini-line chart to give you a quick, historical or series visualization. This makes it easier to draw comparisons
Switch to the Home tab. Click on the Conditional Formatting button. Let’s add a few visualizations to this report to make it easy for end-users to understand the numbers. We’ll start with Conditional Formatting, a native feature of Excel. Then add Data bars to the annual numbers for each category. Select Data Bars. Select the Green Gradient Fill. Sparklines Click Instructions Presenter Script Switch to the Insert tab. Excel 2010 includes new formatting and visualization features that further enhance the way complex data can be visualized to improve understanding and help business users like Richard’s boss make better decisions. Click on the Line sparkline type. The new Sparklines feature works like a mini-line chart to give you a quick, historical or series visualization. This makes it easier to draw comparisons
PowerPivot%20Demo.docx