MICROSOFT EXCEL – INTERMEDIATE LEVEL

• Learn the building blocks of Intermediate Excel functionality.
• Link Workbooks and Worksheets.
• Work with Range Names and Sort and Filter Range Data.
• Analyze and Organize with Tables.
• Use Conditional Formatting and Display Data Graphically.
• Outline with Subtotals and Groups.
• Understand PivotTables, PivotCharts, and Slicers

COURSE CONTENT

• Linking Workbooks and Worksheets
  • Linking Workbooks and Worksheets
  • Linking Worksheets with 3D References
  • Understanding the Consolidate Feature

• Working with Range Names
  • Using the Name Box and Define Name
  • Using Create from Selection

• Sorting and Filtering Range Data
  • Differences Between Sorting and Filtering
  • Sorting Lists
  • Filtering Lists
  • Creating Subtotals

• Analyzing and Organizing with Tables
  • Creating Tables and Understand the Benefits
  • Understanding the Elements of a Table
  • Formatting a Table
  • Sorting and Filtering Tables
  • Filtering with Slicers
  • Calculating with Tables

• Using Conditional Formatting
  • Highlight Cells and Top Bottom Rules
  • Data Bars, Icon Sets, and Color Scales
  • Using Custom Fonts and Colors
  • Using Custom Conditional Formatting
  • Modifying or Removing Conditional Formatting

• Displaying Data Graphically
  • Creating Charts
  • Understanding Chart Elements
  • Formatting Charts
  • Creating Dual Axis Charts
  • Creating a Chart Template
  • Displaying Trends with Slicers

• Understanding PivotTables, PivotCharts and Slicers
  •  Creating a PivotTable
  • Working with PivotTable Fields Pane
  • Formatting PivotTable
  • Creating a PivotChart
  • Formatting PivotChart
  • Using Slicers and Timeline Slicers