Take this
course

Office Productivity / Microsoft

Excel 2007 Introduction

introduction to Excel 2007. Get started creating spreadsheets, formulas, and more.

Description

This class teaches the basic functions and features of Excel 2007. 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. 


Instructor: Pamela Conway

Full details

Curriculum

  • Introduction
    Introduction
    1:10
    Course Exercise Files
  • Getting Started
    Understanding the Three Primary Functions of Excel
    1:45
    Understanding Spreadsheet Terminology
    3:24
    Launching Excel
    1:21
    Exploring the Excel Interface
    3:58
    Opening a Workbook
    1:43
    Examining Formulas
    1:09
    Understanding Worksheets
    1:36
    Using Zoom
    1:28
    Changing Views
    1:41
    Navigating Spreadsheets
    4:20
  • Basic Worksheet Skills
    Creating a New Workbook
    2:18
    Entering Data
    5:27
    Selecting Parts of a Workbook
    1:22
    Using Multiple Worksheets
    2:21
    Using AutoFill
    9:27
    Deleting Ranges
    3:54
    Using Undo and Redo
    1:26
    Deleting a Worksheet
    0:59
    Saving a Workbook
    4:37
  • Creating Formulas
    Understanding the Order of Operations
    2:22
    Entering Simple Formulas
    2:23
    Using SUM, MAX, and MIN
    8:39
    Using AutoSum
    3:11
    Using AVERAGE
    3:08
    Creating a Formula
    3:54
    Working with Date Arithmetic
    2:46
    Using AutoCalculate
    2:12
    Relative vs. Absolute Cell Adressing
    4:46
  • Formatting the Worksheet
    Adjusting Column Width and Row Height
    5:57
    Inserting and Deleting Rows and Columns
    2:16
    Hiding Rows and Columns
    1:59
    Changing Number Formatting
    4:04
    Changing Character Formatting
    3:04
    Aligning Data
    5:59
    Adding Borders and Shading
    6:01
    Using Format Painter
    5:32
    Using Cell Styles
    3:20
    Using Themes
    1:37
  • Working with Large Worksheets
    Using Zoom
    2:17
    Freezing and Unfreezing Panes
    3:42
    Splitting a Window
    3:14
    Tiling Multiple Workbooks
    3:57
    Using Synchronous Scrolling
    3:22
  • Using Protection and Comment Boxes
    Adding and Deleting Comments
    4:54
    Locking and Unlocking Cell Ranges
    8:34
  • Using Page Setup and Printing Options
    Using Spell Check
    3:55
    Inserting Page Breaks
    2:38
    Using Page Break Preview
    1:41
    Using Print Preview
    2:23
    Changing the Orientation and Margin
    2:46
    Working With Print Areas
    2:19
    Setting Print Titles
    1:59
    Adding Headers and Footers
    2:56
    Printing Gridlines and Comments
    0:59
    Using the Print Dialog Box
    1:29
  • Conclusion
    Course Recap
    1:19

Skills

  • Microsoft Excel
  • Spreadsheet

Similar Courses

More Courses by this Instructor