Excel Training – Video Series
Learn excel 2007 by using video training! If you are a visual learner, this set of videos will be a perfect fit for you as you increase your skill level.
- Let’s face it….everyone doesn’t learn by readying books or quick tutorials. Sometimes you just want to view a process and learn it at your own pace.
- Using these videos will enable you to enhance your spreadsheet skills and be prepared for your current or future job!
These videos includes lessons that cover the most common excel topics:
-
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
2. 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 Data
2. Text to Columns
3. Duplicate Data
4. 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 Ranges
2. Margins
3. Shrink to Fit
4. Header/Footer
5. Page Breaks
- Part 10: Charts and Labels
-
Part 11: Pivot Tables
Ready to buy your copy of Excel Training – Video Series for $67.00, use the link below:
