Excel 2016 - Part 2

Price
$295.00
Duration
 1 Day
Delivery Methods
 VILT    Private Group

This course builds upon the knowledge presented in the Microsoft® Office Excel® 2016: Part 1 course and helps start students down the road to creating advanced workbooks & worksheets that can help deepen their understanding.

 

Upcoming Class Dates and Times

May 14, 2021
8:00AM - 4:00PM Central
1 Day
Virtual Instructor Led
 GTR
May 19, 2021
8:00AM - 4:00PM Central
1 Day
Virtual Instructor Led
 GTR
May 25, 2021
8:00AM - 4:00PM Central
1 Day
Virtual Instructor Led
 GTR
May 28, 2021
8:00AM - 4:00PM Central
1 Day
Virtual Instructor Led
 GTR
Jun 03, 2021
8:00AM - 4:00PM Central
1 Day
Virtual Instructor Led
 GTR
Jun 10, 2021
8:00AM - 4:00PM Central
1 Day
Virtual Instructor Led
 GTR
Jun 16, 2021
8:00AM - 4:00PM Central
1 Day
Virtual Instructor Led
 GTR
Jun 22, 2021
8:00AM - 4:00PM Central
1 Day
Virtual Instructor Led
 GTR
Jun 28, 2021
8:00AM - 4:00PM Central
1 Day
Virtual Instructor Led
 GTR
Jul 02, 2021
8:00AM - 4:00PM Central
1 Day
Virtual Instructor Led
 GTR
Jul 13, 2021
8:00AM - 4:00PM Central
1 Day
Virtual Instructor Led
 GTR
Jul 19, 2021
8:00AM - 4:00PM Central
1 Day
Virtual Instructor Led
 GTR
Jul 23, 2021
8:00AM - 4:00PM Central
1 Day
Virtual Instructor Led
 GTR
Jul 30, 2021
8:00AM - 4:00PM Central
1 Day
Virtual Instructor Led
 GTR
Aug 09, 2021
8:00AM - 4:00PM Central
1 Day
Virtual Instructor Led
 GTR
Aug 17, 2021
8:00AM - 4:00PM Central
1 Day
Virtual Instructor Led
 GTR
Aug 20, 2021
8:00AM - 4:00PM Central
1 Day
Virtual Instructor Led
 GTR
Aug 25, 2021
8:00AM - 4:00PM Central
1 Day
Virtual Instructor Led
 GTR
Sep 02, 2021
8:00AM - 4:00PM Central
1 Day
Virtual Instructor Led
 GTR
Sep 09, 2021
8:00AM - 4:00PM Central
1 Day
Virtual Instructor Led
 GTR
Sep 17, 2021
8:00AM - 4:00PM Central
1 Day
Virtual Instructor Led
 GTR
Sep 27, 2021
8:00AM - 4:00PM Central
1 Day
Virtual Instructor Led
 GTR
Oct 05, 2021
8:00AM - 4:00PM Central
1 Day
Virtual Instructor Led
 GTR
Oct 11, 2021
8:00AM - 4:00PM Central
1 Day
Virtual Instructor Led
 GTR
Oct 14, 2021
8:00AM - 4:00PM Central
1 Day
Virtual Instructor Led
 GTR
Oct 20, 2021
8:00AM - 4:00PM Central
1 Day
Virtual Instructor Led
 GTR
Oct 28, 2021
8:00AM - 4:00PM Central
1 Day
Virtual Instructor Led
 GTR
Nov 03, 2021
8:00AM - 4:00PM Central
1 Day
Virtual Instructor Led
 GTR
Nov 11, 2021
8:00AM - 4:00PM Central
1 Day
Virtual Instructor Led
 GTR
Nov 22, 2021
8:00AM - 4:00PM Central
1 Day
Virtual Instructor Led
 GTR
Nov 29, 2021
8:00AM - 4:00PM Central
1 Day
Virtual Instructor Led
 GTR
Dec 06, 2021
8:00AM - 4:00PM Central
1 Day
Virtual Instructor Led
 GTR
Dec 10, 2021
8:00AM - 4:00PM Central
1 Day
Virtual Instructor Led
 GTR
Dec 20, 2021
8:00AM - 4:00PM Central
1 Day
Virtual Instructor Led
 GTR

Who Should Attend

This course is designed for students who already have foundational knowledge and skills in Excel 2016 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.

Course Objectives

    Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions. You will: Work with Functions Work with Lists Analyze Data Visualize Data with Charts. Create advanced formulas. Analyze Data with PivotTables and PivotCharts.

Agenda

1 - Working with Functions
  • Work with Ranges
  • Use Specialized Functions
  • Work with Logical Functions
  • Work with Date & Time Functions
  • Work with Text Functions
2 - Working with Lists
  • Sort Data
  • Filter Data
  • Query Data with Database Functions
  • Outline and Subtotal Data
3 - Analyzing Data
  • Create and Modify Tables
  • Apply Intermediate Conditional Formatting
  • Apply Advanced Conditional Formatting
4 - Visualizing Data with Charts
  • Create Charts
  • Modify and Format Charts
  • Use Advanced Chart Features
5 - Analyzing Data with PivotTables and PivotCharts
  • Create a PivotTable
  • Analyze PivotTable Data
  • Present Data with PivotCharts
  • Filter Data by Using Timelines and Slicers

Prerequisite Courses Recommended

  • Excel 2016 - Part 1

Next Course Recommendations

  • Excel 2016 - Part 3
 

Do You Have Additional Questions? Please Contact Us Below.

contact us contact us 
Contact Us about Starting Your Business Training Strategy with United Training