Excel Expert

STUDENTS ENROLLED
    In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets,collaborating on worksheets with others, and sharing Excel data with other applications. Course Objectives Learning how to customize Excel sheet interface Learning how to customize menus & toolbars … READ MORE

    In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets,collaborating on worksheets with others, and sharing Excel data with other applications.

    Course Objectives

    • Learning how to customize Excel sheet interface
    • Learning how to customize menus & toolbars
    • Dealing with objects, photos, and forms
    • Understanding how to manage spreadsheets through e-mail
    • Learning how to import and export data
    • Learning filtering and grouping data
    • Learning PivotTable and PivotChart
    • Dealing with functions
    • Applying security and protection concepts on spreadsheets
    • Using Visual Basic Applications

    Course Outline

    Advanced Skills

    • Using Appearance Customization
    • Drawing and Picture Objects
    • Using Format
    • Workbook Management

    Data

    • Using Importing and Exporting
    • Learning How to Limit the Data
    • Grouping Data
    • Using PivotTable and PivotChart

    Analyzing Data

    • Learning How to Analyze Inputs
    • Learning How to Analyze Outputs

    Functions

    • Using Ranges & Formats
    • Errors

    Workgroup Collaboration

    • Applying Security on Spreadsheets
    • Sharing

    Macro

    • Working with Macro
    • Introduction to VBA
    • Macro and VBA
    • Coding Fundamentals
    LESS

    Course Reviews

    No Reviews found for this course.

    TAKE THIS COURSE
    • course Hours: 12
    • course price: EGP
    • Course Dates: