Microsoft Excel 2010

Create Spreadsheets and Perform Basic Calculations with Formulas

Course Description: Learn the basics of Microsoft Excel 2010, the popular spreadsheet program. Begin with a tour of the Excel Window and learn how to create a worksheet, add and edit data and images, and save for printing in various formats. Discover the various built-in math, financial, and text related functions that Excel provides. Begin your journey toward becoming proficient in creating professional spreadsheets in Excel 2010.

Author: Valerie Chau

Runtime: 9hrs. 16min.

Lessons: 123

Lessons		Time (Min:Sec)
Introduction PREVIEW, CLICK HERE		01:19
Chapter 1: Exploring the Screen
Overview PREVIEW, CLICK HERE		00:25
Quick Access Toolbar PREVIEW, CLICK HERE		04:15
Worksheets		04:57
File Button		06:41
Ribbon Tabs		15:01
Formula Bar		03:53
Status Bar		05:36
Chapter 2: The Ribbon
Overview		00:56
Home		19:34
Insert		10:21
Page Layout		08:42
Formulas		08:56
Data		03:34
Review		07:05
View		08:35
Collapsing the Ribbon		01:57
Shortcut Keys		02:39
Chapter 3: Backstage View
Overview		00:49
Entering and Exiting		01:21
Saving in Excel Formats		02:22
Saving in HTML and PDF		06:46
Opening and Closing		03:09
AutoRecover		06:38
Worksheet Information		07:03
Recent		04:28
Saving and Sending		05:29
Help		03:17
Options		11:18
Chapter 4: Creating Your Workbook
Overview		01:08
Starting a Workbook		02:23
Adding Column Headings		03:00
Adding Data		06:41
Editing Data		03:07
Navigating: The Mouse		02:21
Navigating: Shortcut Keys		02:06
Navigating: Go To Feature		02:11
Worksheet Protection		04:55
Working with Worksheets		04:46
Printing		08:01
Saving and Closing		04:04
Chapter 5: Formatting Cells
Overview		00:22
Opening Workbooks		01:13
Cell Data Types		03:58
Numbers		04:44
Dates and Times		04:17
Custom Formats		06:11
Data Alignment		03:26
Fonts and Colors		07:13
Borders and Fill		04:09
Merging Cells		02:54
Columns and Rows		02:46
Chapter 6: Cells & Data
Overview		00:27
Copying, Moving, and Deleting		09:07
Adding Columns and Rows		04:04
Multiple Cell Selections		03:17
AutoCorrect		03:21
AutoComplete		02:41
AutoFill		04:58
AutoFit		02:56
Undo, Redo, and Repeat		04:10
Recovering Versions		03:14
Spell Check		03:54
Adding Hyperlinks		03:52
Chapter 7: Formulas & Functions
Overview		00:28
Entering Formulas		04:42
Arithmetic Operators		06:37
Cell References		07:14
Using Functions		04:59
Using Cell Ranges		03:19
Formula Errors		03:11
Logical Operators		04:25
Formula Shortcuts		03:14
Chapter 8: Math Related Functions
Overview		00:32
Mathematically Correct Functions		03:49
Rounding Numbers		12:08
Counting/Adding Numbers		09:47
Maximum and Minimum		07:06
Ranking Numbers		05:34
Finding Averages		05:17
Products, Powers, and Factorials		06:35
Generating Random Numbers		04:59
Combinations and Permutations		03:44
Chapter 9: Finance Related Functions
Overview		00:34
Future Value		05:20
Present Value		02:37
Computing Payments		04:46
Computing Time		03:27
Interest Rates		03:23
Net Present Value		06:48
Depreciation		08:20
Chapter 10: Editing Text & Data
Overview		00:49
Putting Text Together		05:57
Copying Text		05:39
Counting Characters		05:01
Uppercase and Lowercase		02:38
Removing Spaces/Characters		04:11
Converting Text to Numbers		07:22
Date and Time Data		10:59
Chapter 11: Creating Charts
Overview		00:47
Charts		03:32
Chart Tools Ribbon		07:02
Moving and Resizing		03:00
Standalone Charts		04:07
Editing and Adding Data		06:08
Printing Charts		05:12
Using Multiple Series		02:47
Time/Date Scales		01:55
Non-Contiguous Data Ranges		03:36
Chapter 12: Editing the Chart
Overview		00:21
Chart Type		02:54
Data Series Order		01:34
Blank Values		05:37
Chart Styles		03:37
Chart Layouts		04:41
Titles and Legends		04:05
Adding Data Labels		02:09
Adding Data Tables		03:40
Chapter 13: Inserting Pictures & Shapes
Overview		00:33
Working with Pictures		04:53
Using Clip Art		04:39
Drawing Shapes		04:14
Conclusion		01:26