Iverson Computer Associates Page 1 of 3

Course Code : EXC 262

Duration 1 Day

The program is designed for experienced Excel users who need to know the advance features of Excel 2007.

The program will equip participants with skills to customize the Excel environments for office automation.

Hands - on exercises related to actual business applications will help participants to reinforce concepts &

features covered

Prerequisites

• Working knowledge of the Microsoft Windows 2000 or XP interface such

as configuring the desktop, using Control Panel, moving and sizing

windows, and switching between tasks

• Must have attended Excel 2007 (Basic & Intermediate)

Module 1 :

Analyzing Worksheet

Data

• Understanding Tables (New)

• Creating Table (New)

• Formatting a Table (New)

• Creating or Madifying a Table Style (New)

• Formatting Table Elements (New)

• Creating Calculations in a Table (New)

• Working with Table

• Removing Table Rows and Columns

• Entering Data in a table Using a Drop-Down List

• Sorting Data in a Table (New)

• Displaying Parts of a Table with AutoFilter (New)

• Creating Custom Searching

• Analyzing Data Using a PivotTable or PivotChart (New)

• Updating a PivotTable or PivotChart (New)

• Modifying a PivotTable (New)

• Formatting a PivotTable (New)

• Charting a PivotTable (New)

• Creating Groups and Outlines

• Converting Text to Columns

• Adding Data Validation to a Worksheet

• Creating a Drop-Down List

• Exporting a Table to a SharePoint List (New)

Module 2 :

Building More Powerful

Worksheet

• Using Data Analysis Tools

• Creating Conditional Sums

• Looking at Alternatives with Data Tables

• Asking “What-If” with Goal Seek

• Creating Scenarios

• Using Solver

• Using Lookup and Reference Functions

• Using Text Functions

• Summarizing Data Using Subtotals

• Summarizing Data Using Functions

• Determining Specific Dates

Microsoft Excel 2007

Advanced

Iverson Computer Associates Page 2 of 3

Module 3 :

Protecting and Securing

a Workbook

• Inspecting Documents (New)

• Protecting a Worksheet

• Locking and Unlocking Worksheet Cells

• Adding Security Encryption to a Workbook

• Adding Password Protection to a Workbook

• Restriction Workbook Access

• Adding a Digital Signature

• Adding a Signature Line

• Avoiding a Harmful Attacks

• Using the Trusted Center (New)

• Selecting Trusted Publisher and Locations (New)

• Setting Add-in Security Options (New)

• Setting ActiveX Security Options (New)

• Setting Macro Security Options (New)

• Changing Message Bar Security Options (New)

• Setting Privacy Options (New)

• Setting External Content Security Options (New)

• Working with Office Safe Modes (New)

• Marking a Workbook as Read-Only

Module 4 :

Reviewing and Sharing

Workbook Data

• Sharing Workbooks

• Creating and Reading a Cell Comment

• Editing and Deleting a Cell Comment

• Tracking Changes

• Sending a Workbook for Review Using E-mail

• Sending a Workbook by Internet Fax

• Working with XML

• Creating an XML Data Map

• Exporting and Saving Data ini XML

• Sharing Information Between Programs

• Exporting and Importing Data

• Linking and Embedding Files

• Consolidating Data

• Linking Data

• Getting External Data

• Managing Connections (New)

• Getting Query Data from a Database

• Getting Data form Microosft Access

• Getting Text Data

Module 5 :

Publishing Data on the

Web

• Opening a Workbook as a Web Page

• Previewing a Web Page

• Creating a Hyperlink

• Formatting a Hyperlink (New)

• Changing Web Page Options

• Saving a Worksheet as a Web page

• Publushing a Web Page

• Copying a Web Table to a Worksheet

• Creating Refreshable Web Queries

• Getting Data from Web Queries

• Saving Web Queries

• Accessing Office Infromation on the Web

• Getting Documents form a Web

Iverson Computer Associates Page 3 of 3

Module 6 :

Tools for Working More

Efficiently

• Setting Popular Excel Options (New)

• Setting New Workbook Options

• Setting Editing Options

• Setting Display View Options (New)

• Setting Workbook and Worksheet Display Options

• Setting Advanced Options

• Setting Formula Options

• Changing Advanced Document Properties

• Changing Research Options

• Customizing the Way You Create Objects

• Accessing Commands Not in the Ribbon (New)

• Scanning and Imaging Documents (New)

• Managing Picture

• Using Multiple Languanges

Module 7 :

Expanding Excel

Functionality

• Viewing and Managing Add-ins

• Loading and Unloading Add-in

• Enhancing a Workbook with VBA*

• Viewing the Visual Basic Editor*

• Setting Developer Options (New)

• Understanding How Macro Automate Your Work

• Recording Macro

• Creating a Macro

• Running a Macro