Training Programme on Advance Excel - Batch 3

Course Description 

Today most organisations require people with IT skills and Microsoft Excel is a tool which is commonly used for records or basic interpretations of data. IT is becoming an essential tool in many organisations which help to enable the performance of employees. Moreover, Microsoft Excel is necessary in most work environment and help businesses to manage, track and analyse organisation’s data. This Advanced Microsoft Excel course has been designed to enable participants to learn Excel as tool to be used in to their daily operations. The course will cover the following:

• Advanced formula
• Chart layout / Styles
• Formatting/Protecting Worksheet
• Pivot Tables
• VLookup
• Formatting a Pivot table

Course Objectives  

The objectives of the course are to enable participants to:

• Create and format a worksheet;
• Manage and edit workbooks;
• Use advanced formula while working with Excel;
• Create and use charts/pivot tables to interpret data;
• Use Excel with other program;
• Apply VLookup.

Learning Outcomes

By the end of this course, participants will be able to:

• Apply formulas in their day-today work;
• Articulate with excel as a tool for operations in the workplace;
• Create, format and feed data on a worksheet;
• Use/edit/copy formulas in the worksheet;
• Create charts and pivot tables for interpretation of data;
• Use Excel with other programmes
• Use VLookup.

    Duration

           2 days

    Hours To Be Earned

           12 Hours

    Certificate

    Price

           Rs 4000