Introduction to Excel

Introduction to Excel

Mobile

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 iPhone

 

 

Date: December 8 & 10, 2014

Days: 2

Fee: $450.00

Location: 551 Fifth Ave. (at 45th St) NYC

Course Number: 90555

Time: 9am to 4pm

Date: February 10 & 12, 2015

Days: 2

Fee: $450.00

Location: 1 Martine Ave. White Plains, NY 10606

Course Number:90778

Time: 9am to 4pm


Date:  April 14 & 16, 2015

Days: 2

Fee: $450.00

Location: 551 Fifth Ave. (at 45th St) NYC

Course Number:90624

Time: 9am to 4pm

icon

Course Description

This course will provide a solid introduction for those new to spreadsheets, and for self-taught users wanting to enhance their knowledge. Tou will focus on workspace familiarization, creating and managing data, formatting worksheets, charting and using functions.

Click for Detailed Course Description

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

Outline for Introduction to 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

CREATING CHARTS
Parts of a Chart
Modifying the Chart
Additional Part Charts
Enhancing the Chart
Backgrounds
Data Labels
Formatting a Single Item from the Group

 

 

Other Courses That May Interest You

icon

Access

  icon

Excel

icon

Microsoft Project

  icon

Outlook

 

 

icon

PowerPoint

  icon

Windows 8.1

 

 

Word