Excel Outline
- Introduction to Excel
- The New Interface of Excel 2007 (03:44)
- Excel Workspace
- Excel 2007 Overview (07:10)
- What is Excel ? (1) (01:52)
- What is Excel ? (2) (02:37)
- What is Excel ? (3) (10:36)
- What is Excel ? (4) (12:39)
- Shortcuts: Excel Shortcuts (06:05)
- Basic Data Entry in Excel 2007 (06:15)
- Using Templates in Excel 2007 (03:09)
- Charts: Excel Charts
- How to Create a Chart (02:58)
- Creating & editing charts and graphs (09:59)
- Line Charts (02:00)
- Cluster Column Chart (04:26)
- Combination Chart (04:32)
- Gantt Chart: Making Gantt Chart in Excel (07:00)
- Data Analysis
- Formatting
- Removing unwanted spaces from text (00:59) & (02:37)
- Insert Shapes (Buttons) in Excel 2007 (02:18)
- How to remove duplicates from worksheet data in Excel 2007 (1:45)
- Functions and Formulas
Flowcharts
MS Visio 2007
Process Mapping
- Introduction to Process Mapping (7:00)
- Basic Process Shapes for Process Mapping using Visio 2007 (2:32)