COM6018 - Microsoft Excel Intermediate

Maui College - Continuing Education

Validation error

You must correct the following errors to continue:

The current information for the selected course has expired. To see the latest information, please search for this course again, then proceed with your enrollment.

Course Description

Tap into the power of Excel by using more functions that are built-in and explore the needed techniques to build multiple sheet workbooks and to link and consolidate data among them.

Learner Outcomes

Upon successful completion of this course participants will be able to: 1. Manage workbooks and customize the Excel environment 2. Use named ranges in formulas 3. Work with Excel tables and how to sort data, use filtering features, use structured references, validate data, and transpose rows and columns 4. Consolidate data from more than one range or workbook, and how to use subtotals

Prerequisites

Microsoft Excel Essentials or instructor permission.