|
Course
Description
Microsoft Excel: Level 3 is an advanced course
for the student looking to enhance their knowledge base.
In this course students will learn to customize workbooks,
collaborate with others using shared workbooks and also
enhance worksheets with charts and graphic objects.
Prerequisites
MS Excel Level 1 and 2 or equivalent
Course Objectives
Upon successful completion of this course, students
will be able to:
-
Customize your workbook by applying conditional formatting,
adding data validation criteria, customizing menus
and toolbars, creating and editing a macro, and grouping
and outlining structured data.
- Work
with multiple workbooks to create a workspace,
consolidate
data, link cells, edit links, export Excel data into
XML, import XML data into Excel, and create a Web
query.
- A variety of techniques to sort and filter
data.
- Collaborate
with other Excel users by protecting your workbook,
sharing your workbook, setting revision tracking,
merging multiple copies of the same workbook, and
tracking changes.
- Chart
non-adjacent data, modify chart items, and create
a trendline.
-
Use multiple graphic objects to enhance your worksheet.
|
