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   

 

Learn to use advanced formulas and work with various tools to analyze data in spreadsheets. Organize table data, create PivotTables, presentation features, and enhance the look and appeal of workbooks by adding graphical objects.

It's design is 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

 

Refunds are not given after 1st night of class

 
  • Microsoft Excel, Level 2

  • Item Number: GT23EXL22001

  • Fee: $130.00

  • Instructor: Sherry Wright

    Capacity Remaining: 15

  • Dates: 11/14/2022 - 11/21/2022

    Times: 6:00 PM - 9:00 PM

  • Sessions: 3

    Days: M W

  • Building: Truist Classroom & Training Building

    Room: 211

  • Deadline to register is November 7, 2022.

    Classes will be held at the Boone Campus located at 500 Technology Way, Florence, KY 41042 - Truist Classroom & Training building, room 211.