718-762-1900 888-227-0888

REGISTER NOW

 

Course Description

 

Get up to speed with Microsoft Excel, the world's most popular spreadsheet program. Follow along with Excel expert Dennis Taylor as he demonstrates how to efficiently manage and analyze data with this powerful program.

Learn how to enter and organize data, perform calculations with simple functions, and format the appearance of rows, columns, cells, and data. Other lessons cover how to work with multiple worksheets, build charts and PivotTables, sort and filter data, use the printing capabilities of Excel, and more.

You will learn

If you do well in this unit, you should be able to:

  • Indicate the names and functions of the Excel interface components.
  • Enter and edit data.
  • Format data and cells.
  • Construct formulas, including the use of built-in functions, and relative and absolute references.
  • Create and modify charts.
  • Preview and print worksheets.
  • Use the Excel online Help feature.

Course Outline

 

CHAPTER 1: Up and Running with Excel

 
  • Creating a New Excel Workbook
  • Getting Acquainted with Excel
  • Entering Data in a Worksheets
  • Quickly Entering Lists and Serial Data with the AutoFill Command
  • Formatting Numbers, Dates, and Time Values
  • Establishing Data-Validation Rules

CHAPTER 2: Refining Your Worksheet

 
  • Editing Worksheet Data
  • Moving Around in a Worksheet
  • Getting a Better Look at the Worksheet
  • Comments for Documenting Your Worksheet
  • Selecting Cells in a Worksheet
  • Deleting, Copying, and Moving Data
  • Handling the Worksheets in a Workbook
  • Keeping Others from Tampering with Worksheets

Formulas and Functions for Crunching Numbers

 
  • How Formulas Work
  • The Basics of Entering a Formula
  • Speed Techniques for Entering Formulas
  • Copying Formulas from Cell to Cell
  • Detecting and Correcting Errors in Formulas
  • Working with Functions
  • A Look at Some Very Useful Function

MAKING A WORKSHEET EASIER TO READ AND UNDERSTAND

 
  • Laying Out a Worksheet
  • Decorating a Worksheet with Borders and Colors
  • Getting Ready to Print a Worksheet

Advanced Techniques for Analyzing Data

 
  • Seeing What the Sparklines Say
  • Conditional Formats for Calling Attention to Data
  • Managing Information in Lists
  • Forecasting with the Goal Seek Command
  • Performing What-If Analyses with Data Tables
  • Analyzing Data with PivotTables