| |
Introduction and Overview |
1 hour |
| MODULE-1 |
Working with Custom & Conditional Formats in Excel |
1.5 HOURS |
| |
Working with Charts in Excel |
1.5 hour |
| MODULE-2 |
Using Formulas & Functions in Excel |
1 hour |
| |
Creating Pivot Tables in Excel |
2 hour |
| MODULE-3 |
Working with Range Names in MS Excel |
1 hour |
| |
Creating and Using Shared Workbooks using Excel |
1 hour |
| MODULE-4 |
Using Advanced Functions in Excel |
1.5 hour |
| |
Working with Worksheet Protection |
1 hour |
| MODULE-5 |
Managing Tables Using Excel |
1 hour |
| |
Working with Multiple Workbooks in Excel |
1 hour |
| MODULE-6 |
Using Auto Filter in Excel |
1 hour |
| |
Advanced Techniques and Problem Solving |
1 hour |
| MODULE-7 |
Getting Most from your Data using Microsoft Excel |
1.5 hour |
| |
Introduction to Visual Basic for Applications (VBA) |
1 hour |
| MODULE-8 |
Working with Charts in Excel |
1.5 hour |
| MODULE-9 |
Creating Pivot Tables in Excel |
2 hour |
| MODULE-10 |
Creating and Using Shared Workbooks using Excel |
1 hour |
| MODULE-11 |
Working with Worksheet Protection |
1 hour |
| MODULE-12 |
Working with Multiple Workbooks in Excel |
1 hour |
| MODULE-13 |
Advanced Techniques and Problem Solving |
1 hour |
| MODULE-14 |
Introduction to Visual Basic for Applications (VBA) |
1 hour |
