This class is designed for people who have basic knowledge of Excel, and who want to improve the presentation of data in Excel. Excel provides many tools for analyzing data however it is often a challenge to present the data in a meaningful way for others to use. By the completion of this class participants will have a thorough knowledge of Excel data presentations tools including Data Validation, Conditional Formatting, Advanced Charts, PivotTables, and PivotCharts. This is the second half of our Excel Intermediate Class. The Excel Intermediate Part 1 is focused on managing your data through the use of a variety of Excel features and functions, while the Excel Intermediate Part 2 class is focused on presenting your data.
Duration:
1 Day
Audience:
The class has been designed for users of Excel who have a basic knowledge of Excel.
Prerequisites:
Participants must have basic knowledge of entering data, formatting and simple formulas or have equivalent knowledge of Excel Intermediate Part 1 class.
Course Content:
- Understanding Data Validation
- Data Validation Rule Setting
- Data Validation Tool Tips
- Data Validation Custom Error Messages
- Understanding Conditional Formatting
- Highlight Cell Rules
- Top/Bottom Rules
- Data Bars
- Color Scales
- Icon Sets
- Custom Rules
- Advanced Rules based on Formulas
- Creating a Schedule (Gantt Chart) using Conditional Formatting
- Waterfall Chart
- Histogram Chart
- Pareto Chart
- Box & Whisker Chart
- Treemap Chart
- Sunburst Chart
- Sparkline Cell Chart
- Preparing the Data
- Anatomy of a PivotTable
- Slicing and Dicing with a PivotTable
- Grouping Data
- Sorting Data
- Custom PivotTable Field Names
- PivotTable Slicers
- PivotCache
- Refreshing Data
- Customize Subtotals
- Showing Values as Calcuations
- Calculated Fields
- Calculated Items
- Creating a PivotChart
- PivotChart Control Buttons
- PivotChart and PivotTable Filters
Bookings
This class is full. Bookings are closed for this class.