Pace University
914-422-4054
212-346-1222
New York City | Westchester

Introduction to Excel

Course Format

Two Days (9am- 4pm); offered Monday-Friday; Instructor-led. Class runs from 9am-4pm.

COST:  $475

You Will Learn To

  • Enter and edit values, labels and formulas
  • Save and retrieve worksheets and select ranges
  • Move around the worksheet
  • Change column widths and row heights
  • Insert and delete rows and columns
  • Format numbers
  • Copy and move data from one location to another using the menus,
  • Fill-handle and drag & drop
  • Save and retrieve worksheets
  • Enhance worksheets using borders, shading, fonts and autoformat
  • Print worksheets with headers, footers and borders
  • Work with multiple windows and manipulate them within the graphical
  • User interface of Windows
  • Create and print charts
  • Use the data management capabilities for sorting data
  • Enter formulas using the "built-in" functions

Who Should Enroll

New to MS Excel.
Prerequisite: Introduction to the PC or familiarity with the Windows environment. Ability to type is recommended.

Course Description

How to use Excel 2010's newest features as you enter data, labels and formulas to create and print spreadsheets. You will also learn to copy and move data and use ranges, headers and footers.

Detailed Course Outline

Excel Basics
 Understanding Excel
The Excel Screen
Starting Excel
Parts of a Workbook
The Excel 2010 Interface
Moving about a Worksheet
 
Entering Data and Formulas
Entering Data
Saving a file with a New Name
Aligning Labels
Cell Ranges
Auto fill (Optional)
Formulas/Pointing/Editing
      
Ranges
       Changing Columns Widths/Row Heights
       Shortcut Menus
       Inserting/Deleting Columns/Rows
       Totals and Visual Totals
 
Formatting
       Formatting Values, Dates, Times
       Selecting Large Blocks of Data
       Fonts, Borders, Fills, Mini-Toolbar
       Cell Styles, Galleries, Preview, and Themes
 
 
Printing
       Print Area, Page Layout View
       Zooming, Centering, Landscape
       Headers/Footers
       Printing Multi-Width Sheets
       Multi-Width Sheets
       Page Breaks/Preview
       Print Titles
Copying and Moving
       Copying Data
       Collecting and  Pasting Multiple Items
       Moving Cells
       Copying and Moving Formulas
       Absolute Addresses
 
Multiple Panes and Sheets
       Splitting Windows into Panes
       Freezing Panes
       Multi-Sheet Workbooks
       Group Editing
       Multi-Sheet (3-D) Formulas
       Printing a Multi-Page Workbook
 
Additional Topics
       Using Functions
       The Insert Function Button
       Sorting by Single/Multiple Columns
       Sorting with Blank Columns/Rows
       Sorting by Color
       Saving to an Excel 2003 Workbook
 
Creating Charts
Parts of a Chart
Modifying the Chart
Additional Part Charts
Enhancing the Chart
Backgrounds
Data Labels
Formattting a Single Item from the Group
 
      

Copyright © 1984-2012 Pace University.
All Rights Reserved
Created by: pcbt@pace.edu
Pace Center for Business and Technology
914-422-4054
212-346-1222
Pace blog Facebook Twitter