Class / Schedule


PC End User

Excel 2016 Level 2 (2 Days)

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. This course will also help in preparation to take a Microsoft Office Specialist exam for Excel.

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

      • Manage workbooks and customize the Excel Environment
      • Work with named ranges in formulas
      • Understand Excel tables and how to sort, filter, use structured references and validate data
      • Consolidate data from different ranges or workbooks
      • Use Logical and Lookup functions to make decisions and return information
      • Find and trap errors, control formula options, and use array formulas and functions
      • Perform calculations on dates, manipulate text and use some statistical and financial functions
      • Understand how to use permissions to control access to and prevent changes in your workbooks, and about comments and change tracking

      Competencies covered in this course: Intermediate level Excel skills, advanced formulas

        Intended Audience: Anyone required to use spreadsheets and formulas in their work.

          Recommended Pre-requisites: Completion of the Microsoft Excel 2016 Level 1 course or equivalent knowledge and experience is strongly recommended.

          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
          • Aug 26 2019 8:00am-4:30pm
          • Aug 27 2019 8:00am-4:30pm
          $255.00 Wed, 08/07/2019 - 17:00 Debbie Lonborg
          2 Lacey

          SPSCC - LACEY
          4220 6th Ave SE Bldg. 1
          Lacey, WA 98503
          • Sep 23 2019 8:00am-4:30pm
          • Sep 24 2019 8:00am-4:30pm
          $255.00 Wed, 09/04/2019 - 17:00 Debbie Lonborg
          3 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
          4 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