Class / Schedule

-

PC End User

Excel 2016 Level 2 (2 Days)

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 Lacey

SPSCC - LACEY
4220 6th Ave SE Bldg. 1
Lacey, WA 98503
  • Nov 21 2019 8:00am-4:30pm
  • Nov 22 2019 8:00am-4:30pm
$255.00 Mon, 11/04/2019 - 16:00 Al Hedstrom
2 Lacey

SPSCC - LACEY
4220 6th Ave SE Bldg. 1
Lacey, WA 98503
  • Dec 18 2019 8:00am-4:30pm
  • Dec 19 2019 8:00am-4:30pm
$255.00 Sun, 12/01/2019 - 16:00 Al Hedstrom
3 Lacey

SPSCC - LACEY
4220 6th Ave SE Bldg. 1
Lacey, WA 98503
  • Feb 24 2020 8:00am-4:30pm
  • Feb 25 2020 8:00am-4:30pm
$255.00 Wed, 02/05/2020 - 16:00 Darin Murphy