MICROSOFT

MS ADVANCED EXCEL 2007

DESCRIPTION
This course will surely increase your office productivity. Find out more functions that you thought never exist in Excel.
COURSE CONTENT

Duration: (24 hours)

 

Module I

  • Benchmarking Excel 2007 with previous versions
  • Migrating files to Excel 2007
  • Synchronizing participant's level in Excel
  • Global/general configurations
  • Customizing appearance
  • File management/security
  • Workbook/spreadsheet management
  • Templates
  • Graphics/objects
  • Advance charts

Module II

  • Formulas/functions
  • Excel as database/database concepts
  • Entering, editing and searching data
  • Auditing, validating and analyzing data
  • Data sources/queries
  • Sharing workbooks/ publishing spreadsheets
  • Network/internet issues
  • Mail/Form Merging
  • Tracking changes/Versions

 Module III

  • Printing issues
  • Pivot tables
  • Reporting Tools/Services
  • Programming excel/macros
  • Excel tips and tricks