EL403

MS Office 2010: Advanced Excel - Online Training

  • Duration 8 hours
  • Regular fee 190
SUMMARY
DETAILS

Objectives

Mastering the advanced fonctions of Excel 2010.

Targeted audience

End users seeking proficiency in the use of Microsoft Excel 2010 at an advanced level.

Prerequisite

Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment; an understanding of the Internet and web-page functionality.

Special Note

  • COMPLETE ONLINE SELF PACED PROGRAM
  • 6 MONTHS TO COMPLETE THE TRAINING

Content

  • Customizing Visual Elements in Excel 2010
  • Workbook Settings, Conditional Formatting, and Number Formats in Excel 2010
  • Organizing Data and Objects in Excel 2010
  • Verifying Excel 2010 Data and Formulas
  • Automating Excel 2010 Tasks Using Macros
  • Analyzing Data with What-if Analysis in Excel 2010
  • PivotTables and PivotCharts in Excel 2010
  • PivotTable Filters, Calculations, and PowerPivot

General Note

SUPPORTED OPERATING SYSTEM VERSIONS Microsoft® Windows Vista, Microsoft® Windows XP, Microsoft® Windows 7, Microsoft® Windows 8, Microsoft® Windows RT, Mac OS® X™: 10.5.8, 10.6.8, 10.7.5, 10.8.5, 10.9.2, 10.10, 10.10.1 and above (Version 10.6 32-bit kernel is supported.) SUPPORTED BROWSERS (MINIMUM VERSIONS) Internet Explorer® (Internet Explorer 8 on Windows 7 only, Internet Explorer 9 or later is recommended, Internet Explorer 8 may hinder performance and result in minor visual problems.), Firefox 31 or later, Chrome 29 or later, Safari: 5.1.8 or later (Safari on Windows platforms is not supported.) HARDWARE REQUIREMENTS Skillsoft supports the minimum hardware specifications for all supported operating systems.

Subscription

  • Subscription french version

  • Subscription english version