Advanced Excel and Basic MS Access Karama Language & Computer Center
Price: AED 1,200

    Course details

    Why do I need to learn MS Excel and MS Office Access?

    MS Excel is use to create spreadsheets and analyze data with charts and graphs. A "must know" program for anyone in the work force now, or soon to be! MS Access is a powerful program to create and manage your databases. It has many built in features to assist you in constructing and viewing your information. These two platforms when combined can resolve your information management challenges.

    Designed For:

    For those who would like to know how to manage and store information for reference, reporting and analysis. For those who would like to use Microsoft access to analyze large amounts of information, and manage related data more efficiently than Microsoft excel or other spreadsheet applications.

    Course Overview:

    MS Excel:

    • Simple Functions
    • Other advanced functions like: If, VLOOKUP, PMT, and other useful functions
    • Managing Charts
    • Using Sort and Filter
    • Subtotals, custom views, comments
    • Data Validation
    • Pivot Tables and Pivot Charts
    • Chart Tables, Consolidate
    • Group and Outline
    • Goal Seek, Scenarios
    • Outsourcing Data
    • Formula Auditing
    • Conditional Formatting, Auto Correct Options
    • Managing Multiple Documents
    • Usage of Freeze Panes and Split
    • Managing Tables
    • MS Access
    • MS Excel Migration
    • MS Access Database creation and manipulation
    • o Database Fundamentals
    • o Tables
    • o Queries
    • o Forms
    Updated on 21 July, 2020

    About Karama Language & Computer Center

    Karama Language and Computer Centre (KLCC) established in 2005, is a highly professional training institute, approved by Knowledge & Human Development Authority (KHDA), U.A.E, offering a wide range of training programs for enhancing skills in diverse fields.

    We are based in Dubai, the thriving business hub of the Middle East and it offers a wide scope of activities for the business community in the U.A.E.

    Whether your employees need computer training or language training KLCC offers a complete learning experience irrespective of nationality or skill level.

    The training offered by us has helped numerous organizations improve their overall work & quality standards.

    See all Karama Language & Computer Center courses
    Courses you can instantly connect with... Do an online course on Microsoft Access starting now. See all courses

    Is this the right course for you?

    Rate this page

    Didn't find what you were looking for ?