Class / Schedule

PC End User

Excel 2016 Level 3 (2 Days)

01-04-D734
If you are an experienced Excel user who wants to build on knowledge and skills, this course is for you. This course will build on your prior knowledge in excel and will provide advanced tools for solving real-world problems.

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

      • Use function to make decisions and to return information from arrays and tables
      • 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
      • Import or create a connection to external data, use Power Pivot and cube functions to access information in the Power Pivot Data Model, and export Excel worksheets to other formats
      • Perform what-if analyses by using a watch window, scenarios, and the Goal Seek utility; and use some of the tools available in the Analysis Toolpak
      • Record and run macros, and create a simple form

      Competencies Covered in the course: Advanced Excel skills to include; charts, pivot tables and analysis tools

        Intended Audience: Anyone required to use advanced formulas and reporting skills in their work

          Recommended Pre-requisites: Completion of the Microsoft Excel 2016 Level 1 & 2 courses 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
          • Jan 23 2018 8:00am-4:30pm
          • Jan 24 2018 8:00am-4:30pm
          $255.00 Thu, 01/04/2018 - 16:00 Debbie Lonborg