Undergraduate Admission
    Graduate Admission

    Microsoft Office Excel Advanced, SC 541

    About this Course:
    In this course, advanced features of Microsoft Excel are covered.

    This course may be taken in MS Office 2003 or MS Office 2007. Course schedule will indicate which version is included in each offering.

    Prerequisites:
    Knowledge of the Windows Operating System, entry and editing of data in Excel worksheets, working knowledge of Excel's formatting menus, knowledge of formula structure, editing and copying and printing worksheets and workbooks.

    Who Should Attend:
    This course is a follow-on to the Excel : Basics (SC 531) and Excel : Intermediate (SC 567) courses that expanding on the advanced capabilities of Excel. The course is designed to promote usage of Excel beyond the basic spreadsheet functions and calculations.

    Expected Outcomes:
    Participants will be able to apply the following operations to their workbooks.

    Generate information based on the data entered in selected cell.
    Query and filter data to display specific information.Format reports using styles or auto formats.
    Use pivot tables and pivot charts for interactive display of information.
    Link to workbooks and/or worksheets for calculations.
    Work with macros for repetitive tasks, their creation and editing.
    Work with workbooks on the Web.
    Consolidate information in large worksheets.
    Work with text strings.

    Course Outline:
    Working with Advanced Formulas
    Lookup and Data Tables
    Advanced List Management
    Working with Pivot Tables
    Exporting and Importing
    Using Analytical Options
    Working with Macros
    Interactive Web Pages
    Text or String Functions

    CEU:
    0.7

    Presented By:
    Professional Learning Programs