## Excel Training - Video Series

See How Easy it is to Learn Excel!!!
* Are you struggling to Learn Excel?
* Are you busy enough to not spend your time reading Excel books?
* Do you want to learn Excel to better contribute your existing job/work?
* Do you want to show your Excel skills like a pro in the next interview?
* Would you want to Learn Excel in a weekend?
If the answer to all/any of the question above is 'Yes' then this course is for you.

A series of 12 Lessons covering the most used Excel topics to make learning Excel very easy for you. These Video tutorials are a result of a 20 years of collective experience and covers all the topics here which should help you move on with Excel and become an intermediate level user of Excel.

Video Contents Index

Part 1. Basic Introduction

1. What's new in 2007 2. The Ribbon Menu 3. The Office Button 5. Keyboard Shortcuts

Part 2: First Excel File

1. Creating Excel Files 2. Cells, Rows and Columns 3. Entering Data 4. Saving Files

Part 3: Working with Worksheets

1. Add, Delete and Rename 2. Tab Colors 3. Split Windows/Freeze Panes 4. Hide and Unhide 5. Protect and Un-Protect 6. Working with Shapes

Part 4: Cell Formats and Options

1. Height and Width of Rows & Columns 2. Types of data 3. Align and Indent 4. Font Options 5. Hyperlinks 6. Context Menu 7. Insert, Delete and move columns, rows & Cells 8. Cut, Copy and Paste 9. Paste Special 10. Clipboard 11. Cell Borders 12. Merge Cells 13. Wrap Text

Part 5: More on Formatting

1. Conditional Formatting 2. Data Validation 3. Naming Ranges 4. Special Characters 5. Format Painter

Part 6: Formulas and Functions

1. Relative and Absolute Cell References 2. Other Sheets references 3. Functions 4. Function Examples

Part 7: Dealing with Data

1. Importing Data2. Text to Columns3. Duplicate Data4. Sort & Filter Data

Part 8: Finalizing the Workbook

1. Check Spellings 2. Cell Comments 3. Hide Worksheets 4. Find and Replace 5. Lock and Unlock Cells

1. Print Ranges2. Margins3. Shrink to Fit4. Header/Footer5. Page Breaks

Part 10: Charts and Labels

Part 11: Pivot Tables

1. Build 2. Options

Platform Windows 95/98/ME

Operating Systems Windows 95/98/ME,Windows NT/2000,WindowsCE,Windows XP,Windows NT/2000/2003/SBS2003,Windows Vista