Skip to main content

ITI 436 - Microsoft Excel - Level II

Registration Option: Open Enrollment

Total Course Hours: 12

Materials:  You must purchase Textbook(s)/ materials and bring them to the first class

If you do not see a class listed in our catalog, it is not available for registration at this time.

Description

Excel Level II builds on the basic concepts and skills of our Excel Level I course to provide more advanced tools for the analysis and presentation of complex, realistic data in Microsoft Excel: how to manage complex workbooks, build more complex functions, use data analysis tools, make an impact with powerful charts and presentation features, and collaborate with other users. Key capabilities and functions covered in this course include name ranges and table-structured references. This course follows the curriculum for the Microsoft Office Specialist (MOS).

Please note: Please order your book at www.lablearning.comnew window or  https://montgomerycollege.slingshotedu.comnew window

Prerequisites

MS Excel Level I (ITI435) or equivalent experience.

Objectives

  1. Work with advanced formatting features: styles, themes and background.
  2. Create totals and subtotals.
  3. Apply cell names.
  4. Works with tables.
  5. Save workbooks as web pages