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