ProfBurnett.com

ITI 081 MS Excel 2010 Level II

Course Outline:

Learn how to use multiple worksheets and workbooks efficiently, start working with more advanced formatting options including styles, themes, and backgrounds. Create outlines and subtotals, apply cell names, and work with tables. Learn to save workbooks as Web Pages, insert and edit hyperlinks, and share workbooks by e-mail. This course also covers advanced charting techniques, use of trendlines, and sparklers, worksheet auditing and protection, file sharing and merging, workbook templates, and PivotTables and PivotCharts. This course will follow curriculum for the Microsoft Office Specialist core-level exam for Excel 2010 (exam 77-882) and the Microsoft Office Specialist Expert exam for Word 2010 (exam 77-888). For comprehensive training, you should complete the MS Excel Level I, II, and II. Course manual comes with CertBlaster exam prep software (download).

Prerequisites:

Working with Windows. MS Excel-Level I or equivalent experience.

Required Textbook & Materials

  • EXCEL 2010: INTERMEDIATE + CERTBLASTER
  • Author: AXZO PRESS
  • ISBN: 9781426021589
  • Edition/Copyright: 0
  • Published Date: NA

Meeting Information

  • Days: Wednesday & Thursday
  • Dates: 11/16/2011 - 11/17/2011
  • Number of Sessions: 2
  • Time: 09:00 AM - 03:30 PM
  • Location:(GBTC) 408

Class Presentations