Microsoft Excel (Advance)

Module 1

WORKING WITH WORKBOOK

§  Arrange the Workbook

§  Using a Workspace

§  Linking the Workbook

§  Merging the Workbooks

§  Share a Workbooks

§  Remove a User From a Shared Workbook

§  Grouping and Outlining Data

§  Preview and Printing Workbooks

Module 2

WORKING NAMED RANGES

§  Adding and Deleting Named Ranges

§  To Create a Named Range

§  To Delete a Named Range

§  To Use a Named Range In A Formula

§  Using VLOOKUP Functions

Module 3

CREATING AND USING EXCEL LISTS

§  Create a Data Form

§  Creating and Formatting a List

§  Searching For Records

§  Sorting Record

§  Setting Up a List Filter

Module 4

DISPLAYING AND FORMATTING DATA

§  Applying Number Format

§  Using Conditional Formatting

§  Performing Calculations and Changing Detail on a List

 Module 5

AUDITING A WORKBOOK

§  Creating a Data Entry List

§  Establishing Valid Data Entries

§  Tracing Errors, Precedent Cells and Dependent Cells

§  Consolidating Worksheet Data

Module 6

PIVOT TABLE

§  Creating a PivotTable

§  Group PivotTable Items

§  Multi-Level PivotTable

§  Frequency Distribution

§  Pivot Chart

§  Slicers

§  Update PivotTable

§  Calculated Field/Item

§  Get Pivot Data

Module 7

SHARING WORKBOOKS

§  Creating, Editing and Removing Comments in Worksheets

§  Tracking Changes in a Workbook

§  Accepting or Rejecting Changes to a Worksheet

§  Applying and Removing Password Protection

§  Protecting Worksheets and Workbooks