Workforce Solutions

Gateway Community & Technical College > Workforce Solutions

Workforce Solutions

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

Course Catalog > Computer Training

Microsoft Excel, Level 2  

This course teaches students how to use the charting features and organizing data features of Microsoft Excel. It is designed for frequent users.


Chapter 1: Managing workbooks
 Module A: Managing worksheets
Module B: Customizing Excel

Chapter 2: Named ranges
 Module A: Using names in formulas

Chapter 3: Tables
 Module A: Sorting
Module B: Filtering tables
Module C: Validation
Module D: Transposing data

Chapter 4: Summarizing data
 Module A: Consolidation
Module B: Subtotals

Chapter 5: PivotTables
 Module A: Creating and formatting PivotTables
Module B: Manipulating PivotTables
Module C: PivotCharts


Chapter 6: Presentation features
 Module A: Conditional formats
Module B: Graphics

Chapter 7: Advanced charts
 Module A: Special chart types
Module B: Sparklines

Chapter 8: Collaboration
 Module A: Permissions
Module B: Shared workbooks
Module C: Web features

 

  • Microsoft Excel, Level 2

  • Item Number: GT21EXL22002

  • Fee: $130.00

  • Instructor: Sherry Wright

    Capacity Remaining: 15

  • Dates: 3/15/2021 - 3/22/2021

    Times: 6:00 PM - 9:00 PM

  • Sessions: 3

    Days: M W

  • Building: BB&T Classroom & Training Building

    Room: 211

  • Registration deadline is March 8, 2021
    Classes will be held at the Boone Campus, 500 Technology Way, Florence, KY 41042 - BB&T Classroom and Training Building, Room 211