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.
Comments