Course Brief

This course is designed to allow participants an appreciation of using new and familiar features Microsoft Excel 2016 to table, calculate, analyze and present information in spreadsheets that are easily secured, shared and, collaborated on, and printed.


  • This course is covered in 36 contact hours

The following is a list of topics that will be covered during this programme:

  • Creating Basic Excel 2016 spreadsheets with calculations and summary functions; choosing from a variety of borders, cells styles and workbook themes; manipulating sheets, columns, rows and the data contained within.
  • Selecting or composing appropriate formulas and functions; troubleshooting and solving function errors; assigning names to cells and ranges; formatting values and creating custom number types; enforcing data validation, sheet level and workbook level protection.
  • Analyzing and presenting worksheet data using Charts, Sparklines, Diagrams, PivotTables, PivotCharts, What-if Analysis, and new Excel 2016 features
  • Collaborating, Exporting, Printing and Automating Excel 2016 with Comments, Tracking Changes, Consolidating, The Macro Recorder and Excel 2016 UserForms.

Champs Fleurs

Start DateEnd DateDaysTimeCost
11-Feb-1718-Mar-17Sat9:00am-3:00pm$1,350
9-May-1722-Jun-17T/T5:30pm-8:30pm$1,350
1-Jul-175-Aug-17Sat9:00am-3:00pm$1,350
5-Sep-1712-Oct-17T/T5:30pm-8:30pm$1,350
31-Oct-177-Dec-17T/T5:30pm-8:30pm$1,350

 

Trincity

Start DateEnd DateDaysTimeCost
10-Jun-1715-Jul-17Sat9:00am – 3:00pm$1,350

 

Please note that all information given above is subject to change without prior notice.

  • Microsoft Excel 2016

    This course is designed to allow participants an appreciation of using new and familiar features Microsoft Excel 2016 to table, calculate, analyze and present information in spreadsheets that are easily secured, shared and, collaborated on, and printed.

     

    CONTACT HOURS

    This course is covered in 36 contact hours

     

    INDICATIVE CONTENT

    The following is a list of topics that will be covered during this programme:

    • Creating Basic Excel 2016 spreadsheets with calculations and summary functions; choosing from a variety of borders, cells styles and workbook themes; manipulating sheets, columns, rows and the data contained within.
    • Selecting or composing appropriate formulas and functions; troubleshooting and solving function errors; assigning names to cells and ranges; formatting values and creating custom number types; enforcing data validation, sheet level and workbook level protection.
    • Analyzing and presenting worksheet data using Charts, Sparklines, Diagrams, PivotTables, PivotCharts, What-if Analysis, and new Excel 2016 features
    • Collaborating, Exporting, Printing and Automating Excel 2016 with Comments, Tracking Changes, Consolidating, The Macro Recorder and Excel 2016 UserForms.

    SCHEDULE

    Champs Fleurs

    Start DateEnd DateDaysTimeCost
    11-Feb-1718-Mar-17Sat9:00am-3:00pm$1,350
    9-May-1722-Jun-17T/T5:30pm-8:30pm$1,350
    1-Jul-175-Aug-17Sat9:00am-3:00pm$1,350
    5-Sep-1712-Oct-17T/T5:30pm-8:30pm$1,350
    31-Oct-177-Dec-17T/T5:30pm-8:30pm$1,350

     

    Trincity

    Start DateEnd DateDaysTimeCost
    10-Jun-1715-Jul-17Sat9:00am - 3:00pm$1,350

     

    Please note that all information given above is subject to change without prior notice.

     

    REGISTRATION INFORMATION

    There is an administration fee of $150 to be paid when registering. The deadline to register is one week before the start date of class after which a late administration fee of $175 will be charged. The credit price will apply if you wish to pay a down payment and installments. The down payment is 60% of the credit price plus the administration fee. The remainder is paid in installments before the end of the course.