• Advanced Excel Fall 2017 (Morning)

    • Share:
    •  
    Name: Advanced Excel Fall 2017 (Morning)
    Date: September 14, 2017
    Time: 8:00 AM - 10:30 AM EDT
    Registration: Online registration for this event has been closed, please call 610.376.6766 to register.
    Event Description:
    Students will learn how to create more advanced charts, database functions, logical formulas, creating range names, and how to work with large spreadsheets in Excel more efficiently including:
    • Everything you can do in  Pivot Tables
    • Consolidating Workbooks
    • Creating a Shared Workspace
    • Creating a Saved Workspace
    • Data Validation in Range Names
    • Creating a One Variable Input Table
    • Creating a Two Variable Input Table
    • Working with Advanced Macros
    • Using the Text To Columns command
    • Protecting Cells that contain formulas
    • Creating a Pareto Chart
    • Creating a Histogram
    • Advanced Goal Seek
    • Working with V Lookup functions
    Location:
    Shearer Technical Computer Consultants
    727 Penn Ave., West Reading
    Date/Time Information:
    Four Sessions on Thursdays:
    September 14, 21, 28 & October 5

    8:00 a.m. - 10:30 a.m.
    Contact Information:
    Mark Dolinski, Director of Business Services 610-898-8386
    Fees/Admission:
    $220/person
    Set a Reminder:
    Enter your email address below to receive a reminder message.