Learn: in:
» back to Search Results

Course rating of 5 Vendor rating of 4


This course is designed for new Excel users who require the skills necessary to set up a spreadsheet and use basic business spreadsheet functions. Students will become familiar with Excels command menus, filing workbooks, and basic editing tools.


 
Course Outline
This course is designed for new Excel users who require the skills necessary to set up a spreadsheet and use basic business spreadsheet functions. Students will become familiar with Excels command menus, filing workbooks, and basic editing tools. The course will also show students how to create simple formulas, use built in functions as well as an introduction to relative and absolute references. Participants will learn to manipulate windows for better viewing as well as work with cut/copy/paste features to move data, format their worksheet and prepare headers and footers for printing.

Course Content
Getting Started

  • Starting Microsoft Excel 2003
  • The Excel 2003 Window
  • Excel Toolbars
  • Excel Menus
  • The Help Menu
  • The Help Task Pane
  • The Office Assistant
Managing Workbooks
  • Creating a Blank Workbook
  • Opening an Existing Workbook
  • Saving Workbooks
Excel Data
  • Types of Data
  • Entering Data
  • Moving around in Excel
  • Changing Column Size
  • Selecting Cells
  • Entering Data in a Range
  • Range
  • AutoFill
  • AutoComplete
  • Replicating Data upon Entry
Editing in Excel
  • Edit Mode
  • Cut and Paste
  • Copy and Paste
  • Moving Cells by Dragging and Dropping
  • Copying Cells by Dragging and Dropping
  • Undo and Redo
  • Inserting Cells
  • Deleting Content of Cells
  • Inserting Rows and Columns
  • Deleting Rows and Columns
  • Go To Feature
  • Spell Checking
Excel Formulas
  • Creating Formulas
  • Relative and Absolute References
  • Circular Reference
  • Sum and Average Formulas
  • AutoSum and Other Automatic Functions
Formatting in Excel
  • Formatting Cells
  • Numbers
  • Fonts
  • Alignment
  • Borders
  • Patterns/Colour
Window Manipulation
  • Zoom
  • Freeze and Unfreeze Panes
  • Split Panes
Printing in Excel
  • Page Setup
  • Page Setup €" Page Tab
  • Page Setup €" Margin Tab
  • Page Setup €" Sheet Tab
  • Page Setup €" Headers and Footers
  • Print Preview
  • Print
Excel Options
  • Customize

Prerequisites & Certificates
Pre-Requisites

Basic computer concepts/skills and knowledge of Windows

Certificates offered

Certificate of completion


Cancellation Policy
10 business days cancellation or full course fee will be charged
Map & Reviews
Technology Training Centre
[ View Provider's Profile ]

Reviews
 
With myself being very green with this program I got very useful information that I can use daily.
Reviewed by 2011
need-to-train-a-group-banner

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 2639 times.