Quick Source Learning | Quick Source Learning | Excel 2010 Basic Course

Excel 2010 Basic Course

Microsoft Excel

 

"


 

E10B
 
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 Excel 2010 Window
  • Using the Ribbon
  • Customizing the Ribbon
  • Using the Backstage View
  • Customizing the Quick Access Toolbar
  • Opening a Workbook
  • Creating a Workbook
  • Saving a Workbook

Workbooks and Worksheets

  • Introduction
  • Inserting a Worksheet
  • Renaming and Deleting a Worksheet
  • Moving or Copying 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 Sparklines
  • Sorting and Filtering Data
  • Freezing a Row or Column
  • Splitting Worksheet Panes

Formatting Cells

  • Introduction
  • Specifying a Number Format for a Cell
  • Changing the Font, Font Size, and Color
  • Using the Mini Toolbar
  • Aligning Text
  • Display Multiple Lines of Text in a Cell
  • Formatting Cell Borders
  • Applying Shading to Cells
  • 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
  • Changing the Page Setup
  • Setting Up the Print Area
  • Printing Gridlines and Headings
  • Working with Page Breaks
  • Printing a Worksheet or Selection
  • E-Mailing a Workbook
  • Saving a Workbook as a PDF or XPS File

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
  • Displaying Access Keys
  • Printing a Help Topic