Sign In   |   View Cart   |     |   Help
 
Course Catalog
 
Print Course information
E-mail to a friend
Return to Course Catalog

Courses and Programs > Community Education > Alphabetic Class List

Excel 2013 Level 2  

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.

    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


    Prerequisite: Completion of the Microsoft Excel 2013 Level 1 course or equivalent knowledge and experience is strongly recommended.

 

Excel 2013 Level 2

Item: C328 Debbie Lonborg
8:00 AM - 4:30 PM ONLINE
Sessions: 2 W Th Location: ONLINE
, WA
1/13/2021 - 1/14/2021 Fee: $255.00

This class is offered online using Zoom and Excel 2013.

Zoom Requirements:

  • Access to a computer with speakers & microphone (or the ability to call in via phone).
  • A web camera (suggested but not required).
  • Access to high-speed internet.

Zoom link will be sent prior to the start of class. You must have Excel 2013 installed on your computer to participate in the class.

Refund Policy: Cancellations must be received 5 business days prior to the 1st day of class in order to receive a full refund.