Module 2:Sort And Filter Data With Excel

♦ Sort, Perform a Quick Sort by a Single Field

♦ Perform a Multi field Sort for Finer Sorting

♦ Sort by a Custom Sort Order

♦ Filter a to Find Records That Match Criteria

♦ Perform Quick Filtering with AutoFilter Create Custom Filters

♦ Using Advanced filter

Module 3:Create Effective Charts To
Present Data Visually

♦ Understand the Basics of Excel Charts

♦ Create a Chart with the Chart Wizard

♦ Choose the Right Type of Chart for Your Data

♦ Use the Chart Toolbar, Select Objects in a Chart

♦ Configure Chart Options, Change the Chart Type

♦ Change a Chart's Source Data

♦ Change the Format ,the Chart Area, Plot area

♦ Configure and Change the Scale of an Axis

♦ Liven Up Charts with Patterns, Fills, and Pictures

♦ Format Individual Chart Elements, Print Charts

♦ Editing Chart data series

Module 6:Working with Multiple
Workbooks

♦ Linking Workbooks

♦ Editing the Link

♦ Consolidating Workbook &worksheets

Module 7:Protecting And Sharing The
Work Book

♦ Restrict Data and Protect Workbooks

♦ Check Data Entry for Invalid Entries

♦ Protect Cells, a Worksheet, or a Workbook

♦ Protect a Workbook with Passwords

♦ Work with Comments and Add a Comment to Cell

♦ Display and Hide the Comments in a Worksheet

♦ Edit and Format Comments, Delete a Comment

♦ Insert Excel Objects in Word Documents

♦ Insert a Chart in a Word Document

♦ Insert Excel Objects in PowerPoint Presentations

♦ Insert Word Objects in Worksheets

♦ Insert PowerPoint Objects in Worksheets

Module 8:Use Macros To Automate Tasks

♦ Display the Developers Tab

♦ Changing Macro Security Setting

♦ Running a Macro

♦ Recording a Macro

♦ Deleting a Macro

♦ Assigning a Macro to an Object