This is for personnel who are involved in:

• Preparing, modifying and analyzing a large number of data in spreadsheets
• Producing summary reports in different presentable format in a short time
• Integrating Excel and others Microsoft Applications
• Sharing worksheets data among colleagues
• Working with confidential data and require protection on the data & formulas
• Adding in Charts and Graphics objects to make your worksheet data more presentable

The training will guide you through on using the various analysis tools available in Excel to fast and easily analyze, share, protect and present your large collection of data.

Working with Formulas Create Lookup Formulas Create Date & Time Formulas	Working with PivotTables  Analyze large amounts of data  View different summaries of data
Working with Lists Create List Filter/Sort List Use Forms for data entry	Working Excel in Multi-user Environment  Share Workbook with others  Apply Security for protecting formula/data
Publishing Sheet Create Style AutoFormat	Enhancing Charts  Insert Logo to Chart  Replace Data Markers with Pictures
Working with Graphic Objects  Use Word art  Use Clipart	Applying Group, Outlines and Subtotals  Apply Colors to Subtotal rows Using Conditional Formatting  Apply Auto Outline
Working with Templates  Create Template  Open Template upon Opening Excel	Integrating Excel with Other Applications  Share information  Use Linked and Embedded Object
Customizing Excel  Create Custom List Customize Toolbar/Menu