Print

Training Programme on Advance Excel - Batch 3

Event

Title:
Training Programme on Advance Excel - Batch 3
When:
Mon, 2. December 2024, 09:00 h - 16:00 h
Where:
Fooks House, Level 7 Room 1 - Port Louis, Port Louis
Category:
Digitalization and Information Technology
Created by:
Super User

Description

Course code:
11508
Category:
Digitalization & Information Technology
Level:
Middle Management/Supervisory Level

 

Course Title: Advanced Microsoft Excel   

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

       

         

   

 

 

Contact information

Name:
Civil Service College, Mauritius
Telephone:
+230 208 7653


Venue

Location:
Fooks House, Level 7 Room 1
Street:
Bourbon Street
ZIP:
11320
City:
Port Louis
State:
Port Louis
Country:
Mauritius