Course Code: excel2016p2
Duration: 7 hours
Overview:

Once you complete Excel 2016 - Part 2, you’ll be able to apply custom formulas and present data to make informed business decisions.

This course empowers you to:

  • Perform calculations using functions and formulas
  • Sort, filter and query data
  • Create and format tables
  • Visualize data with charts
  • Create advanced formulas
  • Analyze data with PivotTables and PivotCharts
Course Outline:
1 - WORKING WITH FUNCTIONS
  • Define Cell Ranges and Reference Them in Formulas
  • Perform Conditional Calculations
  • Carry Out Logical and Specialized Functions
  • Work with Date and Time Functions
  • Understand and Execute Text Functions
2 - WORKING WITH LISTS
  • Sort and Filter Data
  • Learn the Capabilities of Database Functions
  • Query Data with Database Functions
  • Outline and Subtotal Data
3 - ANALYZING DATA
  • Build and Modify Tables
  • Create Formatting Rules
  • Apply Conditional Formatting to Alter Groups of Cells
4 - VISUALIZING DATA WITH CHARTS
  • Organize and Represent Data with Charts
  • Modify and Format Charts
  • Discover and Implement Advanced Chart Features
5 - ANALYZING DATA WITH PIVOTTABLES AND PIVOTCHARTS
  • Create a PivotTable
  • Analyze PivotTable Data
  • Present Data with PivotCharts
  • Filter Data Using Timelines and Slicers