Microsoft Excel 2007 - Level 1

Progressive Training & Development

Short course

In Southwark

Price on request

The best Excel courses

See all

See all

Description

  • Type

    Short course

  • Location

    Southwark

  • Duration

    1 Day

If you have some Excel knowledge, or no Excel knowledge, this course takes you quickly from basic knowledge to a greater understanding of Excel's features. It touches on Beginner, Intermediate and Advanced features.

Facilities

Location

Start date

Southwark (London)
See map
202 Blackfriars Road, SE1 8NJ

Start date

On request

About this course

Basic PC knowledge required

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

DESCRIPTION
If you have some Excel knowledge, or no Excel knowledge, this course takes you quickly from basic knowledge to a greater understanding of Excel's features. It touches on Beginner, Intermediate and Advanced features.

PREREQUISITES
Basic PC knowledge required


GETTING STARTED
  • Starting Out
  • About Workbooks
  • Exploring your Workbook
  • Getting Help in Excel 2007
  • The Quick Access Toolbar
  • The Home Tab
  • The Insert Tab
  • The Page Layout Tab
  • The Formulas Tab
  • The Data Tab
  • The Review Tab

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 Worksheet's Appearance
    • Adding Patterns and Colours
    • Adding Borders
    • Working with Styles

  • Working With Charts, Part 1

    • Creating a Chart
    • Formatting a Chart
    • Modifying Charts with the Layout Tab
    • 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 Tab
  • 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 Tab
    • Quick Printing
    • The Print Dialog
    • Using Page Setup

See related categories

Microsoft Excel 2007 - Level 1

Price on request

The best Excel courses

See all

See all