Enterprise Services Engineering and Architectural Services is open and providing full level services for funded projects

Class / Schedule

PC End User

Excel 2013 Level 2 (2 Days)

01-04-D694
Data can make or break a business. Expand your data manipulation capabilities using Excel in this next step of our Excel series. Learn to use advanced formulas and work with various tools to analyze data in spreadsheets. You will also organize table data, present data as charts, and enhance the look and appeal of workbooks by adding graphical objects.

Practice the advanced skill sets necessary for calculating data using functions and formulas; sorting and filtering data; using PivotTables, PivotCharts, and Slicers for analyzing data; and customizing workbooks.

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

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

      • Customize, configure and enable add-ins
      • Use range names and specialized functions
      • Use array formulas
      • Analyze data using text and logical functions
      • Apply advanced conditional formatting
      • Create and modify tables
      • Sort and filter data
      • Use subtotal and database functions
      • Create, modify and format charts
      • Create, analyze and present data with PivotTables
      • Filter data using Slicers

      Course Competencies: Intermediate Excel

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

          Recommended Pre-requisites: Completion of the Microsoft Excel 2013 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
          Lacey SPSCC - LACEY
          4220 6th Ave SE Bldg. 1
          Lacey, WA 98503
          • Sep 18 2017 8:00am-4:30pm
          • Sep 19 2017 8:00am-4:30pm
          $255.00 Wed, 08/30/2017 - 17:00 Darin Murphy
          Lacey SPSCC - LACEY
          4220 6th Ave SE Bldg. 1
          Lacey, WA 98503
          • Oct 11 2017 8:00am-4:30pm
          • Oct 12 2017 8:00am-4:30pm
          $255.00 Sun, 09/24/2017 - 17:00 Debbie Lonborg
          Lacey SPSCC - LACEY
          4220 6th Ave SE Bldg. 1
          Lacey, WA 98503
          • Nov 7 2017 8:00am-4:30pm
          • Nov 8 2017 8:00am-4:30pm
          $255.00 Thu, 10/19/2017 - 17:00 Debbie Lonborg