Microsoft Excel - Expert

نظرة عامة على البرنامج

This advanced Microsoft Excel course equips students with expertise in data analysis and summarization using VLOOKUP, Pivot Tables, and other advanced skills. It prepares learners for the Excel Expert MOS certification and offers an assessment-first approach to cater to individual learning needs. Learners are expected to have prior experience with Excel or complete a foundational course before enrollment.

مخطط البرنامج

Degree Overview:

This course is designed to help students become experts in Microsoft Excel. It covers advanced-level skills such as VLOOKUP and Pivot Tables, which are essential for analyzing and summarizing data.

Outline:

• Manage advanced workbook options and settings
• Format workbooks with advanced tools
• Generate formulas using conditional functions, logical operations, and data look up functions
• Troubleshoot formulas using advanced error checking tools
• Create charts with advanced functionality
• Manage and define named tables and ranges
• Perform what-if analysis using the Goal Seek tool
• Create and manage pivot tables and pivot charts with advanced functionality
• Enable and create macros

Assessment:

The course follows an assessment-first approach. Students will be assessed at the beginning of the course and then receive an individualized learning plan.

Other:

• It is recommended that learners take COMP9302 Microsoft Excel - Core or have equivalent experience prior to taking this course.
• The cost of Jasperactive and G-Metrix software is included in the course.
• A printable eBook and links to video tutorials are provided in Desire2Learn (D2L), the learning management system.
• Registration usually closes 24 – 48 hours before the course starts.
Register early to secure your seat.