Silabus Ms Excel 2010 Advance

1.    Building More Powerful Worksheet

·      Understanding Tables

·      Creating Table

·      Formatting a Table

·      Creating or Modifying a Table Style

·      Formatting Table Elements

·      Creating Calculations in a Table

·      Working with Table

·      Removing Table Rows and Columns

·      Sorting Data in a Table

·      Displaying Parts of a Table with AutoFilter

·      Analyzing Data Using a PivotTable or PivotChart

·      Updating a PivotTable or PivotChart

·      Modifying a PivotTable

·      Formatting a PivotTable

·      Charting a PivotTable

2.       Analyzing Worksheet Data

·         Using Data Analysis Tools

·         Creating Conditional Sums

·         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

3.       Protecting and Securing a Workbook

·         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

·         Setting Add-in Security Options

·         Setting ActiveX Security Options

·         Setting Macro Security Options

·         Changing Message Bar Security Options

·         Setting Privacy Options

·         Setting External Content Security Options

·         Marking a Workbook as Read-Only

4.       Reviewing and Sharing Workbook Data

·         Working with XML

·         Creating an XML Data Map

·         Exporting and Saving Data ini XML

·         Exporting and Importing Data

·         Linking and Embedding Files

·         Consolidating Data

·         Linking Data

·         Getting External Data

·         Managing Connections

·         Getting Query Data from a Database

·         Getting Data from Microsoft Access

·         Getting Text Data

5.       Tools for Working More Efficiently

·         Setting Popular Excel Options

·         Setting New Workbook Options

·         Setting Editing Options

·         Setting Display View Options

·         Setting Workbook and Worksheet Display Options

·         Setting Advanced Options

·         Setting Formula Options

·         Changing Advanced Document Properties

·         Changing Research Options

·         Scanning and Imaging Documents

6.       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

·         Understanding How Macro Automate Your Work

·         Recording Macro

·         Creating a Macro

·         Running a Macro