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

Class / Schedule

PC End User

Excel 2010/2013 Level 3 (2 Day)

01-04-D720
If you are an experienced Excel user who wants to build on knowledge and skills, this course is for you. Along with streamlining your workflow, you’ll practice features that help you collaborate with others, audit worksheets, perform data analysis, and integrate data with the Web. You will also cover functions to make your work life more automated and other tools that will make Excel do part of your job for you.

Participants will use Excel 2013 in the classroom but there are not drastic differences between the 2007, 2010, or 2013 versions of this product and the features covered will work for any of these versions.

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

      • Use 3-D references, links and external references
      • Consolidate data
      • Collaborate and protect workbooks and worksheets
      • Apply data validation
      • Work with forms and controls
      • Create and edit with macros
      • Use Lookup and combine functions
      • Create formulas and functions to apply conditional formatting
      • Trace cells and search for invalid data and formula errors
      • Use data tables and scenarios to determine potential outcomes
      • Use goal seek and the solver tool
      • Analyze data with analysis ToolPak tools
      • Create Sparklines and use advanced chart features

      Course Competencies: Advanced Excel

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

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