Entre Technology Services, LLC.

406-265-5700

www.entremt.com

Excel 2016: Intermediate

Upcoming Dates

Excel 2016: Intermediate

Course Specifications

Course Length: 1/2 day
Rate: $99
Call 406-256-5700 or email entretraining@entremt.com for customized training or group pricing

Course Description

Take your Excel 2016 skills to the next leavel and learn how to build Charts, work with Pivot tools, build Formulas with Functions, and make the most of the Quick Analyis tool.

Course Content

  • Chart Build
    • Data Range
    • Pareto Chart
    • Adding Chart Items
    • Axis Titles
    • Trend Lines
    • Chart Formatting
    • Chart Styles
    • Backgrounds
  • Removing Duplicate Data
  • Pivot Tools
    • Data Sources
    • Using the Pivot Table
    • Field Selection
    • Math Options
    • Working with Data
    • Duplicating the Pivot Worksheet
    • Creating a Pivot Chart
    • Pivot Chart Dialog
    • Pivot Chart Pane
    • Filtering and Slicing Data
  • Preparing the Worksheet
    • Ranges of Data
    • Placing Formulas
    • Named Ranges
  • Building Formulas With Functions
    • Using Insert Function
    • Using Function Lists
    • Using AutoComplete
  • Conditional Functions
    • Criteria
    • IF
    • CountIf and CountIfS
    • SumIf and SumIfS
    • AverageIf and AverageIfS
  • Formulas Across Sheets
    • 3D or Skewer Formulas
    • Selecting Ranges Across Sheets