Advance Excel Course

by Delhi Institute of Computer Education (DICS)

S.No

Contents

Duration (hour)

1

Naming Ranges

1.5

1.1

Define named ranges

1.2

Use named ranges in formulas

2

VLookUp and HLookUp Functions

1.5

2.1

Using V LookUp

2.2

Using H LookUp

3

Linking Multiple Workbooks

1.5

3.1

Use formulas to link workbooks

3.2

Create a workspace

4

Importing Data

1.5

4.1

Import from external sources

4.2

Using Microsoft Query

5

Pivot Tables and Charts

3

5.1

Creating a PivotTable

5.2

Changing field settings

5.3

Creating a chart

6

Templates and Styles

3

6.1

Working with templates

6.2

Working with templates

6.3

Macros

3

6.4

Creating macros

6.5

Adding custom controls

7

Analysing Data

12

7.1

Using GoalSeek

7.2

Using Solver

7.3

Using Data Tables

7.4

Scenario Manager

8

Security and Proofing

9

8.1

Protecting Excel files

8.2

Worksheet protection

8.3

Using data validation

8.4

Using text to speech

9

Customising Excel 2003

3

9.1

Customising toolbars

9.2

Customising the environment

10

Collaboration and Consolidation

6

10.1

Sharing workbooks

10.2

Sharing workbooks

10.3

Consolidating data