This Training CD on Learning and Mastering Microsoft Excel has been created using an innovative On Screen Training technology.

All the topics are explained with clear voice over and the trainer will guide you through the topics using the actual Excel program, hence allowing you to see the trainer's actions in Excel and thereby providing you with a truly practical learning experience.

Introduction:

Introduction
Excel Tour 1
Excel Tour 2
Excel Tour 3

Working With Worksheets:

Working with Worksheets
Finding and Replacing Information
Protecting Your Worksheet Data
Entering Data into Multiple Cells
Inserting Comments on Worksheets
Working with Cell Ranges
Working with Forms
Working with Multiple Worksheets

Formatting in Excel:

Spell Check Your Worksheet Data
Auto Formatting Data
Formatting Worksheet Data
Using the Format Painter
Using the Freeze Panes Option
Working with Hyperlinks
Working with Values

Working with Rows and Columns:

Creating and Working with Lists
Adding Background Colour and Patterns
Copying and Pasting Information
Deleting Information
Inserting Rows and Columns
Using the Wrap Text Option

Customizing Your Excel Worksheet:

Customizing Your Excel Worksheet
Auto Saving
Using the General Tab

Presenting with Worksheets:

Working with Charts
Adding Headers and Footers to Worksheets
Using the 'Proper" Command for Text Formatting
Working with Autoshapes
Working with Diagrams
Working with Pictures
Working with Symbols
Working with Word Art

Calculations in Excel:

Calculating Percentages
Sum and Average Calculations

View Demo >> http://www.youtube.com/watch?v=o3_ir4WqgVg
 

This Audio Book is brought to you www.audiobookindia.com The No 1 Online Store to Buy Audio Books in India