Learn: in:
» back to Search Results

Course rating of 5 Vendor rating of 4

Designed for new Excel users who want to learn how to set up a spreadsheet & use basic business spreadsheet functions. Become familiar with the Excel 2007 program screen, Ribbon, Office Button, Quick Access toolbar, contextual menus & the Mini toolbar.

Course Outline
This course is designed for new users. The course provides beginner concepts required to produce basic spreadsheets. Participants will learn how to create, save, open and close files; enter data; as well as edit using insert, delete, move and copy functions. This course presents simple formula creation concepts including the use of built-in functions. Relative formulas will also be covered. On completion of this course students will be familiar with formatting features such as: row heights, column width, alignment, merge cells and number styles. Participants will also work with margins, headers and footers to enhance page layout in different views to prepare for printing.

Course Content
Excel Layout
  • Ribbon
  • Quick Access Toolbar
  • Backstage
  • Status Bar
  • Keyboard Commands
  • Contextual Menus and the Mini Toolbar
  • Help
Managing Workbooks
  • Types of Data
  • Creating a Blank Workbook
  • Opening an Existing Workbook
  • Saving Workbooks
Excel Data
  • Entering Data
  • Moving around in Excel
  • Changing Column and Row Size
  • Selecting Cells
  • Ranges
  • AutoFill
  • AutoComplete
Editing in Excel
  • Edit Mode
  • Cut, Copy and Paste
  • Undo and Redo
  • Inserting Cells, Rows and Columns
  • Deleting Cells, Rows, and Columns
  • Deleting Contents of a Cell
  • Clear Formatting in a Cell
  • Comments
  • Go to Feature
  • Spell Checking
Formatting in Excel
  • Formatting Cells
  • Numbers
  • Font
  • Alignment – Merge and Center
  • Borders
  • Patterns and Colors
  • Format Painter
Excel Formulas
  • Creating Formulas – Operators and Built-In Functions
  • Relative Formulas
  • Sum, Average, Max, Min
Printing in Excel
  • Margins
  • Orientations

Prerequisites & Certificates

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 ]

Enjoyed the day
Reviewed by 2012
Well presented, hands on course! The instructor was extremely knowledgable and helpful!! I have already reccommended this course to my managers.
Reviewed by 2011
EXCELLENT instructor!!! Very patient ... customized the class to the needs of the students!
Reviewed by 2011

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 3487 times.