Participants will get the idea and guide how to manage data efficiently and more accurate. Participants will also understand how present data with various styles to emphasize the important data.
Upon completion of this program, participants should be able to:
Create simple to complex formulas and functions, like:
COUNTIF Function
AVERAGEIF Function
SUMIF Function
IF and IFERROR Function
Filter data using Auto & Advanced Filters
Advanced Chart Formatting
Clean Duplicate Records
COURSE PREREQUISITES
Basic knowledge of Microsoft Excel 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 create a basic chart
Able to print a spreadsheet with headers and footers added
Able to use Auto Filter command
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.
WHO SHOULD ATTEND
This course is intended for participants who wish to gain more knowledge from the foundation level of Excel. For participants who are working with lots of formulas and creates report to understand the necessary technique on how an electronic spreadsheet works.
This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know and understand basic concept of Microsoft Excel.
Send your message to IMPACT VOLUTION TRAINING & CONSULTANCY SDN BHD
Main Office
IMPACT VOLUTION TRAINING & CONSULTANCY SDN BHD 201701000237 (1214387-W)
U1, K03-06-13, Tower 3, UOA Business Park. 1, Jalan Pengaturcara, Seksyen U1/51A, 40150 Shah Alam, Selangor, Malaysia.