Managing data systematically and logically is very important to produce a proper report. The latest Microsoft Excel offers more features and enhancements to better manage your spreadsheet. In this Level, we will explore the usage of Functions and Table to generate and analyse reports as well as digging deeper into the features of selected topics learned in the Basic Level.
Date: 9th & 10th August 2023
Client: ESCATEC Electronics Sdn Bhd, Bayan Lepas, Penang
Course Objectives:
By the end of the course, participant will be able to:
use the IF and VLOOKUP/HLOOKUP functions.
manipulate information.
apply sorting.
filter data.
insert comment and symbol.
working with hyperlinks.
apply charting elements.
use Sparklines to show data trend.
Pre-requisites:
Participant must have attended MICROSOFT EXCEL (Basic) or have the basic knowledge of Microsoft Excel:
Managing Excel Workbooks (create, save, open)
Understanding the Worksheet / Column / Row / Cell
Applying Number Format (Number, Date, Time, Text)
Using Auto Fill for Number Format Data
Using AutoSum Functions
Who Should Attend:
Participant who wants to create a report and perform calculation by using the Excel functions and features.
Training Methodology:
This program will be conducted through interactive lectures, practical exercises and group assignments. Case studies on real-world scenarios are included to demonstrate the practicability of the lessons.
More Training Pictures:
Feel free to contact TSY Consultancy by Call / WhatsApp to +6012-6243921 or email to marketing@tsy.my
Cheers.