Classroom Instructor Led Microsoft Excel Training 817-841-9560

Excel Intermediate Part 2

When

July 25, 2019    
9:30 am - 4:30 pm

Bookings

Bookings closed

Where

Bedford Training Facility CY
2201 Airport Freeway, Bedford, TX, 76021

Class Overview

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:

Data Validation
  • Understanding Data Validation
  • Data Validation Rule Setting
  • Data Validation Tool Tips
  • Data Validation Custom Error Messages
Conditional Formatting
  • 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
Advanced Charts
  • Waterfall Chart
  • Histogram Chart
  • Pareto Chart
  • Box & Whisker Chart
  • Treemap Chart
  • Sunburst Chart
  • Sparkline Cell Chart
PivotTable Fundamentals
  • 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
PivotTable Calculations
  • Customize Subtotals
  • Showing Values as Calcuations
  • Calculated Fields
  • Calculated Items
PivotCharts
  • Creating a PivotChart
  • PivotChart Control Buttons
  • PivotChart and PivotTable Filters

Loading Map....

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:

Data Validation
  • Understanding Data Validation
  • Data Validation Rule Setting
  • Data Validation Tool Tips
  • Data Validation Custom Error Messages
Conditional Formatting
  • 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
Advanced Charts
  • Waterfall Chart
  • Histogram Chart
  • Pareto Chart
  • Box & Whisker Chart
  • Treemap Chart
  • Sunburst Chart
  • Sparkline Cell Chart
PivotTable Fundamentals
  • 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
PivotTable Calculations
  • Customize Subtotals
  • Showing Values as Calcuations
  • Calculated Fields
  • Calculated Items
PivotCharts
  • Creating a PivotChart
  • PivotChart Control Buttons
  • PivotChart and PivotTable Filters

Bookings

This class is full. Bookings are closed for this class.