Analysing information using Pivot Tables

• Building a Pivot Table
• Pivot Table structure
• Data formatting
• Subtotalling data

Using external data sources for Pivot Tables

• Creating a Pivot Table with an external data source
• Data source options
• Pivot Table options
• Publishing to a web page

External data sources

• Creating database queries
• Setting external data range properties
• Creating web queries

Data structure

• Importing text files
• Data layout and structures
• Merging and consolidating information

Dashboard charting techniques

• Creating and customising charts
• Adding more data
• Creating user-defined chart types
• Changing the default chart type
• Creating miniature charts suitable for dashboards

Data analysis in charts

• Target vs actual charts
• Using bubble charts
• Creating charts directly in cells

Creating a dashboard

• Dashboard layouts, best practice
• Linking to analysed data

Advanced charting techniques

• Using invert if negative (not available in 2007)
• Combining different chart types in one chart
• Creating custom markers

Creating advanced background formats

• Creating a quadrant background
• Emphasising data with vertical banding
• Mean and Standard Deviation lines

Using conditional formatting to highlight data

• Conditionally format stacked columns
• Conditional formatting based on values
• Conditionally format axis labels

Specialist charts

• Simple Waterfall chart
• Thermometer chart
• Tornado chart

Create a dashboard example using your own data

• Bring along some of your own data and our trainer will help you build a dashboard