MS - Excel

The key to success for any business lies in making the right decisions at the right time.


  • MS - Excel


    Objective

    This course covers the basic and advanced features of MS Excel and to learn how to integrate with other Microsoft programs.

    Contents

    • Creating and Modifying workbooks
    • Entering and Formatting cells
    • Using Formula, Finding and Correcting errors in calculations
    • Adding Charts and Images
    • Focusing on specific data by using Filters
    • Reordering and Summarising Data
    • Sorting worksheet data
    • Linking to data in other worksheets
    • Consolidating multiple sets of data
    • What If analysis tools
    • Analysing data by using PivotTables
    • Automating Tasks by using Macros
    • Sharing workbooks