Microsoft Excel Level 2

Microsoft Excel ClassIn Microsoft Excel Level 1, you became more comfortable with Excel and how it can help you be more productive. In this Level 2 class, you will take your skills to the next level by utilizing some of the advanced functions and tools Excel has to offer. You will learn how to write advanced functions to manipulate and calculate data in creative and time-saving ways.

In addition, you will learn about PivotTables and how they can provide flexibility when analyzing large amounts of data. Other topics in this class include working with graphic objects, printing options, and using charts. This class will open your eyes to the real potential of Excel and how it can save you amazing amounts of time and frustration!

Class Objective: You will 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.

Target Student: This course is meant for those desiring to gain advanced skill sets necessary for calculating data using functions and formulas, sorting and filtering data, using PivotTables and PivotCharts for analyzing data, and customizing workbooks.

Performance-Based Objectives
Upon successful completion of this course, students will be able to:

  • Use advanced formulas
  • Organize worksheet and table data using various techniques
  • Create and modify charts
  • Analyze data using PivotTables, Slicers, and PivotCharts
  • Insert and modify graphic objects in a worksheet
  • Customize and enhance workbooks and the Microsoft Office Excel environment

Pre-requisite: Excel Level 1 or equivalent knowledge

Training Type: Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.  Available for Private or Group Sessions.

Class Includes

  • Professional Textbook
  • Download materials with practice examples
  • Free access to CoWorking space on class days (FC Only)
  • One month of technical support
  • One year for a free re-take (for attended students of public classes only)
  • Certificate of Completion

Class Info

  • Classroom equipped with computers and software
  • 7 hours of training
  • Breaks are taken throughout each session
  • Class size limited
  • Target Audience: Intermediate

Financial Aid

Click here to learn more about financial aid options including DWC’s 6-month payment plan, WIOA Workforce Funding, and more.

Terms and Conditions

Please read our Terms and Conditions before you register.

Certificate Program
This course is part of one of the DWC Certification Programs.

 

Available Classes


Dates/Times InformationONLINE
Mon 7-17-2017
   1:30pm - 5:00pm
Wed 7-19-2017
   1:30pm - 5:00pm

Price: $239.00
Space Available: 14 seat(s)
Course Closing Date: 7-10-2017
Location: Online
Instructor(s): Jonathan Bodell

Dates/Times Information
Mon 7-17-2017
   1:30pm - 5:00pm
Wed 7-19-2017
   1:30pm - 5:00pm

Price: $229.00
Space Available: 9 seat(s)
Course Closing Date: 7-15-2017
Location: Digital Workshop Center - Ft. Collins - View Map
Classroom: Classroom
Instructor(s): Jonathan Bodell
Interested in scheduling a private training session? If the public class schedule above does not meet your availability, please contact us.

Other 1-ON-1 and Group Training Options

Private Class - Contact us for pricing and scheduling

Custom, Hourly Training - Submit a Consulting Request