Microsoft Excel – Level 1
Course Outline

DURATION 1 Day
PREREQUISITES Basic PC knowledge required
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.

Course can be either 2003 or 2007, and is 2003 by default.
COURSE DATES Click here to request an alternate date
Or call us on 020 313 73958 from 8:00 to 22:00 Monday to Sunday.

Weekend Sat, 4-Sep-10 10:00 - 16:30 £125
Weekday Tue, 7-Sep-10 09:30 - 16:30 £125
Weekday Thu, 7-Oct-10 09:30 - 16:30 £125
Weekend Sat, 16-Oct-10 10:00 - 16:30 £125
Weekday Fri, 5-Nov-10 09:30 - 16:30 £125
Evening Mon, 15-Nov-10 and Tue, 16-Nov-10 18:30 - 21:30 £125
Weekday Tue, 7-Dec-10 09:30 - 16:30 £125
Weekend Sat, 11-Dec-10 10:00 - 16:30 £125
Weekday Tue, 4-Jan-11 09:30 - 16:30 £125
Evening Mon, 17-Jan-11 and Tue, 18-Jan-11 18:30 - 21:30 £125
Any One-to-One Tuition
Any Date - Fully Customisable		 09:30 - 16:30 £375

 

 

 

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

 

 


Home | Contact | Terms and Conditions