• Advanced Excel (Evening) - Winter 2018

    • Share:
    •  
    Name: Advanced Excel (Evening) - Winter 2018
    Date: January 4, 2018
    Registration: Register Now
    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:
    Location:
    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
    Fees/Admission:
    $220/person
    Set a Reminder:
    Enter your email address below to receive a reminder message.