by Pam Conway | Released November 2012 | ISBN: 00016CWORKS

This class teaches the basic functions and features of Excel 2010. After an introduction to spreadsheet terminology and Excel's window components, you will learn how to use the Help system and navigate worksheets and workbooks. Next, you will enter and edit text, values, formulas, and pictures, and you will save workbooks in various formats. Additionally, you will move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course also covers simple functions, basic formatting techniques, managing large worksheets and printing.Companion material is not available for this video. Show and hide more

1. Introduction
   • Introduction 00:03:30
2. Getting Started
   • Three primary functions of Excel 00:02:32
   • Spreadsheet terminology 00:03:20
   • Overview of the Excel screen 00:08:00
   • Navigating a worksheet 00:06:08
   • Using zoom 00:00:41
3. Basic Worksheet Skills
   • Creating a new workbook 00:03:33
   • Entering data 00:05:20
   • Selecting a range 00:02:10
   • Selecting columns, rows and non-contiguous cells 00:04:45
   • Using worksheets 00:02:58
   • Using AutoFill 00:11:44
   • Deleting a worksheet 00:00:52
   • Saving a workbook 00:02:56
4. Creating Formulas
   • Entering a simple formula 00:04:56
   • Using cell addresses in a formula 00:01:21
   • Using simple functions: SUM 00:04:40
   • Using Autofill with formulas 00:02:14
   • Using AutoSum 00:03:19
   • Inserting Functions: AVERAGE, MAX, MIN, COUNT 00:16:34
   • Working with date arithmetic 00:03:14
   • Date and currency formatting 00:03:13
   • Using Clear All 00:01:01
   • Relative v. absolute cell addressing 00:05:51
   • AutoCalculate 00:01:56
5. Editing a Workbook
   • Deleting a range 00:01:54
   • Using undo and redo 00:01:14
   • Using cut, copy and paste 00:02:41
   • Using paste options 00:05:20
   • Using the Clipboard Task Pane 00:02:00
   • Using find and replace 00:05:19
6. Formatting the Worksheet
   • Inserting and deleting columns and rows 00:05:20
   • Adjusting column widths and row heights 00:04:17
   • Hiding rows and columns 00:03:17
   • Changing numeric formats 00:01:49
   • Using the format cells dialog box 00:03:17
   • Changing text formats 00:02:00
   • Aligning data 00:06:06
   • Using borders and shading 00:06:18
   • Using the format painter 00:01:30
   • Using cell styles 00:04:38
   • Creating new cell styles 00:01:17
   • Modifying cell styles 00:00:37
   • Using themes 00:02:53
7. Working with Large Worksheets or Multiple Workbooks
   • Using the zoom feature 00:02:44
   • Splitting the window 00:04:03
   • Freeze and unfreeze panes 00:03:53
   • Tiling multiple workbooks 00:03:41
   • Synchronous scrolling 00:00:56
   • Hiding, maximizing, and closing windows 00:01:55
8. Using Protection and Comment Boxes
   • Adding, hiding, and deleting comments 00:06:15
   • Locking and unlocking cell ranges 00:06:17
9. Printing and Page Setup
   • Using Page Break Preview 00:07:11
   • Using Print Preview 00:04:35
   • Changing the orientation 00:01:23
   • Changing the margins 00:01:07
   • Adding headers and footers 00:04:50
   • Setting sheet options 00:01:53
   • Setting print titles 00:03:59
   • Working with print areas 00:01:27
   • Using the Page Layout tab 00:02:29
10. Conclusion
    • Conclusion 00:02:23
Show and hide more