Microsoft Excel 2007 Intro

Microsoft Excel 2007 Introduction

Course Description

In a new results-oriented user interface, Microsoft Office Excel 2007 provides powerful tools and features that you can use to analyze, share, and manage your data with ease.

This course gives you the basic skills to take advantage of the new features found in Microsoft Excel 2007 and become for efficient performing everyday tasks.

Training Credits Required

1 Microsoft Office Training Credit is required per person attending the course. For more information about how to earn training credits visit our Training Overview Page.

Prerequisites

  • Keyboarding/Typing skills
  • Previous experience with spreadsheet software
  • Experience with Windows Vista or XP

Course Outline

  • Microsoft Excel 2007 Interface
    • The Microsoft Office Button
    • The Quick Access Toolbar
    • The Ribbon
    • The Scrollbar
    • The View Toolbar
  • Opening and saving documents
    • The new .xlsx format
    • Saving to a PDF right from Excel
  • Formatting Basics
    • Font, size, colour, alignment
    • Number formats
    • Format Painter
  • Formatting Tables of data
    • Format as Table
    • Cell Styles
    • Conditional Formatting
  • Formulas
    • Creating and editing
  • Functions
    • Sum, Min, Max
    • Insert Function tool
  • Charts and Graphs
    • Creating , updating and editing
  • Themes
    • Colours
    • Fonts
    • Effects

Course Registration

To see a list of dates and register for this course visit our course calendar.