• Advanced Excel (Evening) - Winter 2018

    • Share:
    Name: Advanced Excel (Evening) - Winter 2018
    Date: January 4, 2018
    Time: 3:00 PM - 5:30 PM EST
    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
    Event Media:
    Shearer Technical Computer Consultants
    727 Penn Ave., West Reading
    Date/Time Information:
    Four Sessions on Thursdays:
    January 4, 11, 18 and 25, 2018
    3:00 p.m. - 5:30 p.m.
    Contact Information:
    Mark Dolinski, Director of Business Services 610-898-8386
    Set a Reminder:
    Enter your email address below to receive a reminder message.