Back

Course Information PDF

Course Category:	Information Technology
Course Title:	Data Analysis and Decision Making with Microsoft Excel

Course Code:

IT036

Medium of Instruction:

Cantonese

Duration:

30.0 hour(s)

Pre-requisites:

Have a basic knowledge of MS Excel.

Course Fee:

Macao Resident: MOP2,250

Non-Macao Resident: MOP2,250

Certificate:

Students who have obtained an overall passing grade of the course and met the attendance requirement will be issued a course certificate by UTM. The passing grade of the course is 50.

Course Code	Sub Code	Course Start Date	Course End Date	Class Schedule
IT036	2401	2024/02/20	2024/03/21	View

Objective:

This course aims to let students learn how to use Microsoft Excel to conduct data analysis and solve decision-making and management problems in enterprises.

Outline:

Lookup & reference functions, logical functions and financial functions
Array formulas
Advanced filter
Create a named range
Create an Excel table
Create dependent drop-down lists with conditional data validation
Create and manage advanced PivotTables
Goal seek
Scenario
Solver
Introduction to Big Data analytics tools with PowerPivot and PowerView

Teacher:

Please refer to the schedule

Remarks:

English version of the software is used.

Last Updated: 2023/05/31

Back