Quick Source Learning | Quick Source Learning | Excel 2007 Basic Course

Excel 2007 Basic Course

Microsoft Excel

 

"


 

 

E07B

The Quick Source eLearning Series combines three levels of training: Learn It, Try It, and Evaluation. The Learn It section includes high quality video that shows you everything the instructor is teaching. The Try It section allows you to practice what you have learned right in our course. There is no need to switch between the course, and the software that you are learning. The Evaluation section gives you the ability to test your knowledge and receive immediate feedback.


Topics covered in this course:

Getting Started

  • Introduction
  • Starting and Exiting Microsoft Excel
  • Identifying the Parts of the Word 2007 Window
  • Using the Ribbon
  • Customizing the Quick Access Toolbar
  • Opening a Workbook
  • Creating a New Blank Workbook
  • Creating a New Workbook Based on a Template
  • Saving a Workbook
  • Saving a Workbook in Another Format

Workbooks and Worksheets

  • Introduction
  • Inserting a Worksheet
  • Renaming a Worksheet
  • Moving or Copying a Worksheet
  • Deleting a Worksheet
  • Color Coding a Worksheet Tab
  • Creating Headers and Footers
  • Viewing Multiple Workbooks or Worksheets
  • Comparing Workbooks or Worksheets Side by Side

Cells, Rows, and Columns

  • Introduction
  • Selecting Cells, Rows, or Columns
  • Inserting Cells
  • Inserting a Row or Column
  • Adjusting Row Height or Column Width
  • Deleting a Cell, Row, or Column
  • Merging Cells
  • Naming a Cell or Range of Cells
  • Hiding or Displaying Rows or Columns

Data and Views

  • Introduction
  • Entering Data
  • Using the AutoFill Feature
  • Moving or Copying Data
  • Using the Office Clipboard
  • Using the Repeat, Undo, and Redo Commands
  • Finding and Replacing Text
  • Sorting and Filtering Data
  • Freezing a Row or Column
  • Splitting Worksheet Panes
  • Using the Research Task Pane

Formatting Cells

  • Introduction
  • Specifying a Number Format for a Cell
  • Changing the Font, Font Size, and Color
  • Applying Bold, Italics, or Underline to Text
  • Using the Mini Toolbar
  • Aligning Text
  • Display Multiple Lines of Text in a Cell
  • Formatting Cell Borders
  • Applying Shading to Cells
  • Using the Format Painter
  • Clearing Cell Formatting or Contents

Formulas

  • Introduction
  • Creating and Editing a Formula
  • Inserting a Function
  • Using the Function Library
  • Using the Sum Button
  • Moving or Copying a Formula
  • Working with Formulas
  • Using the Watch Window

Output

  • Introduction
  • Setting Up the Print Area
  • Printing Gridlines and Headings
  • Printing Sheet Names
  • Working with Page Breaks
  • Previewing a Worksheet
  • Printing a Worksheet or Selection
  • E-Mailing a Workbook
  • Running the Compatibility Checker

Getting Help

  • Introduction
  • Using Excel Help
  • Using the Help Table of Contents
  • Searching for Help Topics
  • Getting Help in a Dialog Box
  • Getting Help from Office Online
  • Printing a Help Topic
  • Displaying Access Keys