ProfBurnett.com

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

  • EXCEL 2013: ADVANCED, MOS EDITION, STUDENT
  • Author: AXZO PRESS
  • ISBN: 9781426036866
  • Edition/Copyright: 0
  • Published Date: NA
  • Required CD
  • Title: MICROSOFT OFFICE 2013 CD'S
  • Author: AXZO PRESS
  • ISBN: 9781426037801

Meeting Information

  • Days: Thursday & Friday
  • Dates:10/2/2014 - 10/3/2014
  • Number of Sessions: 2
  • Time: 09:00 AM - 03:30 PM
  • Location:(GBTC) 408

Class Presentations