• Advanced Microsoft Excel Fall 2017 (Morning)

    • Share:
    Name: Advanced Microsoft Excel Fall 2017 (Morning)
    Date: October 11, 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
    Shearer Technical Computer Consultants
    727 Penn Ave., West Reading
    Date/Time Information:
    Four Sessions on Wednesdays:
    October 11, 18, 25 & November 1
    8:00 a.m. - 10:30 a.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.