Class / Schedule

-

PC End User

Excel 2016 Level 2 (2 Days) - Virtual or In-person

01-04-D724

Today’s business requires data to be compiled, analyzed and presented visually to make informed decisions. This course builds on the basic concepts of Excel 2016 level 1, providing more advanced tools for analysis and presentation of complex, realistic data. Practice the advanced skills necessary for working with complex workbooks, building complex function, using data analysis tools, making an impact with charts and collaborating with others.

This course covers Excel 2016; however, the similarities with 2013 version are such that all users should be successful learning this latest product.

Performance Objectives: Upon successful completion of this course you should be able to:

  • Use named ranges in formulas
  • Learn logical, date, and text functions
  • Analyzing data with table functions
  • Creating and modifying charts
  • Use PivotTables to summarize and rearrange large amounts of data in a list, and how to use PivotCharts to present such data
  • Use custom conditional formatting
  • How to use Quick Analysis features to conveniently analyze data

Prerequisite: Completion of the Microsoft Excel 2016 Level 1 course or equivalent knowledge and experience is strongly recommended.

Books: Microsoft® Office Excel® 2016: Part 2 (Logical Operations)

Scheduled Class Location and Dates
City / Facility Date and Time Course Cost Cancel Date Instructor
1 Virtual

Virtual Training
Online
,
  • Sep 23 2020 8:00am-4:30pm
  • Sep 24 2020 8:00am-4:30pm
$255.00 Sun, 09/06/2020 - 17:00 Debbie Lonborg
2 Virtual

Virtual Training
Online
,
  • Oct 12 2020 8:00am-4:30pm
  • Oct 13 2020 8:00am-4:30pm
$255.00 Wed, 09/23/2020 - 17:00 Darin Murphy
3 Virtual

Virtual Training
Online
,
  • Nov 9 2020 8:00am-4:30pm
  • Nov 10 2020 8:00am-4:30pm
$255.00 Wed, 10/21/2020 - 17:00 Debbie Lonborg