Advanced Formatting Techniques
o Applying, Modifying & Creating Cell Styles
o Applying, customizing & saving Themes
o Working with Templates
o Using Conditional Formatting
Working with Illustrations
o Inserting pictures, Screenshots & Clip Art
o Inserting SmartArt Graphics
o Formatting and Organizing Illustrations
Working with Data
o Importing and Exporting Data
o Applying Custom & Advanced Filter
o Setting Data Validation Criteria
o Using Data Forms
Summarizing and Analyzing Tools
o Displaying Data Outline & Subtotals
o Consolidating Data in Multiple Worksheets
o Design PivotTable and PivotChart
o Analyzing Inputs Using Scenario Manager & Data Tables
o Analyzing Outputs Using Goal Seek
Advanced Functions and Formulas
o Managing Named Ranges
o Using Lookup Functions
o Using Conditional Functions
o Tracing & Correcting Formula Errors
Collaboration & Workgroup Skills
o Protecting Cells, Worksheets & Workbooks
o Checking Workbooks for Compatibility, Accessibility & Personal Information
o Preventing Accidental Changes
o Inserting Digital Signatures
o Sharing Workbooks
o Tracking Changes
o Inserting Comments
o Exchanging, Comparing & Merging Files
Automation and Customization
o Working with Macros
o Designing Worksheet Forms
o Saving Custom Views
o Customizing the Workbook Properties
o Customizing the Program Interface
