Microsoft Excel Intermediate
Price: TBA
  • Duration: TBA

Course details

This ILT Series course, rated 5.0/5.0 in overall quality by ProCert Labs, builds on the skills and concepts taught in Excel 2010: Basic. Students will learn how to use multiple worksheets and workbooks efficiently, and they will start working with more advanced formatting options including styles, themes, and backgrounds. They will also learn how to create outlines and subtotals, how to create and apply cell names, and how to work with tables. Students will save workbooks as Web pages, insert and edit hyperlinks, and learn to share workbooks by email. This course also covers advanced charting techniques, use of trendlines and sparklines, worksheet auditing and protection, file sharing and merging, and workbook templates. Finally, students will learn to work with PivotTables and PivotCharts. Course manual comes with CertBlaster exam prep software .

This course will help students prepare for the Microsoft Office Specialist core-level exam for Excel 2010 (exam 77-882) and the Microsoft Office Specialist Expert exam for Excel 2010 (exam 77-888). For comprehensive certification training, students should complete the Basic, Intermediate, and Advanced courses for Excel 2010.

  • Using multiple worksheets and workbooks
  • Advanced formatting
  • Outlining and subtotals
  • Cell and range names
  • Tables
  • Web and sharing features
  • Advanced charting
  • Documenting and auditing
  • Templates and settings
  • PivotTables and PivotCharts
Updated on 08 November, 2015
Courses you can instantly connect with... Do an online course on Microsoft Office starting now. See all courses

Is this the right course for you?

Rate this page

Didn't find what you were looking for ?

or