Microsoft Excel 2010 (EN)

How to Open and Close Excel	05:24
The Excel Application Window	06:03
How to Zoom In and Out	04:31
How to Expand, Minimize and Move Windows	05:11
The Ribbon in Excel	05:32
The Quick Access Toolbar in Excel	09:21

Navigating the Worksheet	06:01
How to Input Numbers, Dates and Text Into Cells	06:16
How to Create and Open Workbooks	07:13
Changing and Deleting Cell Contents	08:19
Selecting Elements of a Table	11:59
How to Undo	05:12
Printing Worksheets	08:23
Switching Between Open Windows	09:45
How to Add and Delete New Worksheets	09:44
How to Copy, Move and Rename Worksheets	06:10
Switching Between Worksheets	03:50

Create and Enter Formulas	12:11
Use Relative Cell References in Formulas	08:46
Use Absolute Cell References in Formulas	13:16
The Sum Function	17:12
The Average, Minimum and Maximum Function	08:47
The Count Function	08:21
The Round Function	10:07
Improvements to Excel Functions	03:05
AND and OR Conditions	06:27
The Help Function	08:58

How to Save and Close Workbooks	09:05
The General Pane in Excel	12:53
The Save Pane in Excel	13:33
The Font Size and Type	04:02
Bold, Italic and Underline	05:10
Cell Alignment in Excel	03:54
Line Break in Excel	04:48
Merging Cells	05:45
The Cell Borders	13:01
Decimals in Excel	07:40
Percent in Excel	06:56
Format Painter in Excel	05:12

The Column Width and Row Height	10:58
How to Insert and Delete Columns, Rows and Cells	09:30
Showing and Hiding Colums and Rows	05:26
The Function Wizard	10:36
The IF Function in Excel	11:59
The Nested IF Function in Excel	03:55
VLOOKUP and HLOOKUP	18:34
Standard Error Message	08:20
Formula Auditing	12:01
Consolidate Data	08:20

How to Insert and Format Time and Date	11:42
Simple Time Calculation in Excel	09:05
Working With Date and Time Functions	12:25
How to Save in a Different File Type	10:08
Cell References to Other Sheets and Workbooks	06:44
Protecting Workbooks	05:18
Protecting Sheets and Cells	08:39
How to Share Workbooks	07:44

Favorite Links	04:32
Saving Options	12:29
Document Properties in Excel	03:39
How to Import and Export Data	10:46
Merging Workbooks	04:47

The Print Preview in Excel	05:13
Arranging Windows in Excel	05:36
Margins in Excel	06:07
The Scale in Excel	06:26
Page Breaks	08:36
The Header and Footer	10:23
The Page Setup	08:44
The Print Titles	05:06
Editing Cell Styles	11:21
Excel Templates	08:12

How to Create Charts	06:20
How to Move and Resize Charts	12:24
Changing Chart Type	07:05
Formatting Charts in Excel	07:49
Formatting Axis in Excel	11:36
The Labels in Excel	07:11
How to Create a Trendline	07:37

How to Insert and Edit Objects	10:15
The Image Styles in Excel	05:31
How to Insert Drawings	06:26
How to Insert SmartArts	09:58
Layer and Group Graphic Objects	08:50

Quick Access to Cells	08:33
How to Split Sheet Window in Sections	07:57
Freezing Lines and Columns	07:44
How to Find and Replace Cells	09:38

Conditional Formatting	20:48
Custom Cell Formats	08:12
The Data Validation in Excel	07:07
Comments in Excel	07:32
How to Use Hyperlinks	06:37
Watermarks & Background Pictures in Excel	06:58
Managing Themes in Excel	07:21
Data Grouping	04:15
Subtotal in Excel	07:57

Creating a Data Base	04:22
Sorting in Excel	08:56
How to Use Filters in Excel	07:55
How to Use Special Filters in Excel	08:37
Database Functions	10:46

How to Create Pivot Table	03:43
The Pivot Table Field List	14:20
Data Grouping in Pivot Tables	09:07
The Pivot Table Tools	19:25
Inserting Calculated Field	07:22
How to Create a Pivot Chart	07:31

The Goal Seek in Excel	07:55
The Solver in Excel	17:51
Solver Reports in Excel	06:50
How to Create Scenarios	07:40

How to Prepare for Sharing	09:38
How to Mark as Final	03:51
The IFERROR Function	04:58
Deleting Duplicates	06:32
Text in Columns	10:16
Administer Digital Signatures	12:36
How to Create a Workspace	03:50
Developing XML Maps	10:31