Introduction to Excel

Mobile

Course: Introduction to Excel

Excel is one of the most important programs used in business today. The ability to set up a spreadsheet, enter numerical data and labels, and perform calculations and analyses on that data is a set of skills that has moved many careers upward.

This two-day, 12 hour course provides a comprehensive introduction to the features and efficiencies of Excel. The power and ease of using Excel will impress you and provide great value at work and at home.

Course Details

icon

Fee: $450.00
Number of Sessions: 2
Course Location: 1 Martine Avenue, White Plains, NY

Please call for Dates

 

icon

Course Description

A solid introduction for those new to spreadsheets, and for self-taught users wanting to enhance their knowledge. These courses focus on workspace familiarisation, creating and managing data, formatting worksheets, charting and using functions. 

icon

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
icon

Who Should Enroll

For those new to spreadsheets, and for self-taught users wanting to enhance their knowledge.

Prerequisite: Comfortable using a PC, or familiarity with the Windows environment.

 

icon

Course Format

Two Days (9am- 4pm); offered weekdays; Instructor-led. Class runs from 9am-4pm.
COST: $450

icon

Questions?

Please contact us at (888) 561-7223 () or continuinged@pace.edu

Course Outline for Introduction to Microsoft Excel

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