• Advanced Excel (Winter 2019)

    • Share:
    •  
    Name: Advanced Excel (Winter 2019)
    Date: February 25, 2019
    Time: 8:00 AM - 10:30 AM EST
    Registration: Register Now
    Event Description:
    Program Objective: Participants will learn how to create more advanced Charts, database functions, logical formulas, creating Range Names, and working with large spreadsheets more efficiently.
     
    Course Outline:
    Various methods of selecting cells
    Creating Range Names
    Absolute Reference
    Working with Logical formulas
    Conditional formatting
    Inserting Comments
    Track Changes – the snitch report!
    Working & Printing large Spreadsheets
    Using Data Sort & Filters
    Creating an Outline
    Goal Seek
    Creating Scenarios
    Macros
    Creating Subtotals
    Grouping Spreadsheets
    Advanced Linking of Spreadsheets
     
    Participants will work on 11 practice examples throughout this 10-hour course and are certain to leave with a very good understanding of the more advanced features of working with a spreadsheet!
     
    Prerequisite: Introduction to Excel and a good working knowledge of the computer.
    Location:
    Shearer Technical: 727 Penn Ave, West Reading, PA 19611
    Date/Time Information:
    Four weeks on Mondays: February 25, March 4, 11 and 18
    8:00 - 10:30 a.m.
    Contact Information:
    Kristen Stubblebine, Coordinator - Training and Development / 610-898-8197
    Fees/Admission:
    $220/person - Chamber Members;
    $320/person - Not-Yet Chamber Members
    Set a Reminder:
    Enter your email address below to receive a reminder message.