top of page

TSY In House Training #121: MICROSOFT EXCEL: Intermediate Level


TSY In House Training #120: Train the Trainer Workshop
Practical Session ongoing.

This course is intended to help all users get up to speed on the different features of Excel and to become familiar with its more advanced selection of features. We will cover how to create and use advanced formulas, analyze data, organize worksheet data with tables and visualize data with charts.


Date: 14th December 2019

Venue: Toyo Memory Technology Sdn. Bhd., Kulim HiTech, Kedah


Course Objectives:

  • How to use range names in formulas and functions, as well as how to use specialized functions.

  • How to analyze data by using text, logical, lookup, date and financial functions.

  • How to create and modify tables, sort and filter data, use subtotal features, and work with database functions.

  • How to create charts, as well as how to modify and format existing charts. They will also learn how to create a trendline and advanced charts.

Who Should Attend:

This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know and understand and want to further enhance their knowledge and practical uses of Microsoft Excel.


Training Methodology:

This program will be conducted through interactive lectures, practical exercises and group assignments.


PREREQUISITES:

Basic knowledge of Windows is essential with the following pre-requisites:

  • Have attended Microsoft Excel – Foundation Level; OR

  • Able to switch between task applications

  • Able to create a spreadsheet with simple formatting

  • Able to apply Freeze Pane command

  • Able to create basic formulas – Addition, Subtraction, Multiplication and Division

  • Able to use basic functions – AutoSum, Count, Max, Min and Average functions.


Feel free to contact TSY Consultancy by Call / WhatsApp to +6017-4036965 or email to marketing@tsy.my


Cheers.


15 views0 comments

Comments


bottom of page