Colleges and Universities
Digital Technology
Textbook Publishers
ITI 092 MS Excel 2013 Level III
Course Outline:
This course builds on the skills and concepts taught in MS Excel—Level II. Learn how to work with advanced formulas, as well as lookup functions. Learn about data validation and how to import and export data. Work with PivotTables and PivotCharts. Finally, learn how to export and import data, use the analytical features of Excel such as Goal Seek and the new Analysis tool, and run and record macros. This course follows the curriculum for the Microsoft Office Specialist core-level for Excel 2013 (exam 77-420) and the Microsoft Office Specialist Expert for Excel 2013 (exams 77-427 & 428). For comprehensive certification training, students should complete MS Excel—Levels I, II, and III.
Prerequisites:
MS Excel-Level I and II or equivalent experience.
Required Textbook & Materials
- Title: MICROSOFT EXCEL 2013:LEVEL 3 OF 3
- Author: Eric A. Weinstein
- ISBN: 978-1-59136-493-1
- Publisher: Labyrinth Books
Materials:
Please bring a Flash Drive/Memory Stick 512MB or larger to class which will enable you to save your class work.
Meeting Information:
Lesson Plan:
Day 1 - Tuesday, March 31, 2015
- • Course Overview Presentation
- • Lesson 12 - Using Lookup Functions, PivotTables, and Macros
- • Lesson 13 - Using Advanced Formatting and Analysis Tools
- • Lesson 14 - Collaboration in Excel
Session 2 - Thursday, April 2, 2015
- • Lesson 15 - Sharing Workbooks
- • Lesson 16 - Integrating Excel with Other Programs
In-Class Material: