About Lesson
Advance Microsoft Excel
| 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 |
