RMD Training - Hull

 

RMD Business Excel 2007 Foundation Syllabus

 

This course is designed for delegates who have little or no experience of using Microsoft Excel 2007.

 

If the course syllabus does not entirely match your requirements, please contact us as we are able to customise it to your needs.

 

This course has a duration of 1 day.

 

Getting Started

 

Starting Out

  • What is Microsoft Excel 2007?
  • Opening Microsoft Excel
  • Interacting with Excel
  • Closing Excel

     

    About Workbooks

  • Creating a New Workbook
  • Opening a Workbook
  • Saving a Workbook
  • About Excel File Types
  • Closing a Workbook

     

    Exploring your Workbook

  • Using Worksheets
  • The Active Cell
  • Selecting Cells
  • Exploring a Worksheet
  • The Zoom Feature

     

    Getting Help in Excel 2007

  • Using the Help Screen
  • About Online Help
  • About Offline Help

     

    The New Interface

     

    The Quick Access Toolbar

  • The Default Buttons
  • Adding Buttons
  • Removing Buttons
  • Customizing the Toolbar
  • The Home Ribbon
  • Clipboard
  • Font
  • Alignment
  • Number
  • Style
  • Cells
  • Editing

     

    The Insert Ribbon

  • Tables
  • Charts
  • Illustrations
  • Shapes
  • Links
  • Text

     

    The Page Layout Ribbon

  • Themes
  • Page Setup
  • Scale to Fit
  • Sheet Options
  • Arrange

     

    The Formulas Ribbon

  • The Function Library
  • Defined Names
  • Formula Auditing
  • Calculation

     

    The Data Ribbon

  • Get External Data
  • Connections
  • Sort and Filter
  • Data Tools
  • Outline

     

    The Review Ribbon

  • Proofing
  • Comments
  • Changes

     

    Excel Basics

     

    Working With Excel 2007

  • Columns, Rows, Cells and Ranges
  • Creating Worksheet Labels
  • Entering and Deleting Data
  • Printing Your Worksheet

     

    Basic Excel Features

  • What is AutoFill?
  • What is AutoSum?
  • What is AutoComplete?
  • Working with Basic Formulas

     

    Moving your Data

  • Dragging and Dropping Cells
  • How to Cut, Copy and Paste Cells
  • How to Cut, Copy and Paste Multiple Cells and Items
  • How to Use Paste Special
  • How to Insert and Delete Cells Rows and Columns
  • Using Undo, Redo and Repeat

     

    Smart Tags and Options Buttons

  • What Are Smart Tags?
  • The Error Option Button
  • The AutoFill Option Button
  • The Paste Option Button
  • Setting Smart Tag Options

     

    Editing Tools

  • Using AutoCorrect
  • Using Spell Check
  • Using Find and Replace
  • Adding Comments

     

    Editing Your Workbook

     

    Modifying Cells and Data

  • Changing the Size of Rows or Columns
  • Adjusting Cell Alignment
  • Rotating Text
  • Creating Custom Number and Date Formats

     

    Cell Formatting

  • Conditional Formatting
  • The Format Painter
  • Cell Merging and AutoFit
  • Find and Replace Formatting

     

    Enhancing a Worksheets Appearance

  • Adding Patterns and Colours
  • Adding Borders
  • Working with Styles

     

    Working With Charts

  • Creating a Chart
  • Formatting a Chart
  • Modifying Charts with the Layout Ribbon
  • Manipulating a Chart
  • Enhancing a Chart with Shapes and Graphics

     

    Working with Charts, Part 2

  • Changing the Type of Chart
  • Changing the Source Data
  • Working with the Chart Axis and Data Series
  • Saving a Chart as a Template

     

    Printing and Viewing your Workbook

     

    Using the View Ribbon

  • Using Normal View
  • Using Full Screen View
  • Using Page Layout View
  • Page Break Preview

     

    Managing a Single Window

  • Creating a New Window
  • Hiding a Window
  • Unhiding a Window
  • Freezing a Pane

     

    Managing Multiple Windows

  • Switching Between Open Workbooks
  • Arranging Workbooks
  • Comparing Workbooks Side by Side
  • Synchronous Scrolling, Resetting a Window and Saving a Workspace

     

    Printing your Workbook

  • Opening Print Preview
  • Using the Print Preview Ribbon
  • Quick Printing
  • The Print Dialogue
  • Using Page Setup

     

     

    •