Intermediate Excel
CATALOG COURSE
DESCRIPTION:
This hands-on computer course is designed to provide an intermediate
understanding of spreadsheets. Learn how to analyze data through list
management, using autofilter, sort and pivot table features. Work with
multiple worksheets and workbooks, and then create a shared workbook,
resolve conflicts, and track changes. Finally, plan and prepare an
application using Excel’s data validation feature and button creation using
macros. This course completes topics required in preparation for the core
level Microsoft Excel Office Specialist certification exam.
COURSE OBJECTIVES:
Upon successful completion of the course, the student will be
able to:
- Analyze data using list management features such as sort and
autofilter.
- Work with multiple worksheets and workbooks.
- Collaborate on a workbook and a web page.
- Develop intermediate spreadsheet applications.
- Determine and apply problem solving techniques using Help and
reference material for successful creation of intermediate business
documents using Microsoft Office products.
 |
