Excel Training - Video Series Long Description:
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
Part 9: Printing Your Workbook
1. Print Ranges2. Margins3. Shrink to Fit4. Header/Footer5. Page Breaks
Part 10: Charts and Labels
Part 11: Pivot Tables
1. Build 2. Options