Microsoft Excel – Level 1
Course Outline

DURATION	1 Day
PREREQUISITES	Basic PC knowledge required
DESCRIPTION	This course encompasses some of Excel’s most fundamental and powerful tools.  Delegates will create spreadsheets that make use of basic formulas and charts while learning to control fundamental Smart Tag options.  Additionally, the course teaches the management of print options, multiple windows and views.
COURSE DATES	Special: Four Days of MS Office training for the price of Three! Click here to request an alternate date Or call us on 020 313 73958 from 8:00 to 22:00 Monday to Sunday. Weekday Mon, 13-Feb-12 09:30 - 16:30 £200.00 +VAT Evening Wed, 15-Feb-12 and Thu, 16-Feb-12 18:30 - 21:30 £200.00 +VAT Weekday Wed, 29-Feb-12 09:30 - 16:30 £200.00 +VAT Weekend Sat, 17-Mar-12 10:00 - 16:30 £200.00 +VAT Weekday Thu, 12-Apr-12 09:30 - 16:30 £200.00 +VAT Evening Mon, 16-Apr-12 and Tue, 17-Apr-12 18:30 - 21:30 £200.00 +VAT Weekday Tue, 1-May-12 09:30 - 16:30 £200.00 +VAT Evening Wed, 16-May-12 and Thu, 17-May-12 18:30 - 21:30 £200.00 +VAT Weekday Wed, 13-Jun-12 09:30 - 16:30 £200.00 +VAT Weekend Sat, 16-Jun-12 10:00 - 16:30 £200.00 +VAT Weekday Mon, 2-Jul-12 09:30 - 16:30 £200.00 +VAT Evening Mon, 16-Jul-12 and Tue, 17-Jul-12 18:30 - 21:30 £200.00 +VAT Weekday Wed, 1-Aug-12 09:30 - 16:30 £200.00 +VAT Evening Wed, 15-Aug-12 and Thu, 16-Aug-12 18:30 - 21:30 £200.00 +VAT Weekday Fri, 7-Sep-12 09:30 - 16:30 £200.00 +VAT Weekend Sat, 15-Sep-12 10:00 - 16:30 £200.00 +VAT Weekday Mon, 1-Oct-12 09:30 - 16:30 £200.00 +VAT Evening Mon, 15-Oct-12 and Tue, 16-Oct-12 18:30 - 21:30 £200.00 +VAT Weekday Thu, 1-Nov-12 09:30 - 16:30 £200.00 +VAT Evening Mon, 5-Nov-12 and Tue, 6-Nov-12 18:30 - 21:30 £200.00 +VAT Weekday Thu, 13-Dec-12 09:30 - 16:30 £200.00 +VAT Weekend Sat, 15-Dec-12 10:00 - 16:30 £200.00 +VAT Any One-to-One Tuition Any Date - Fully Customisable 09:30 - 16:30 £375.00 +VAT Alternatively, use our BOOKINGS FORM for an alternative payment method, or for multiple dates/courses.

GETTING STARTED

• Starting Out
• About Workbooks
• Exploring your Workbook
• Getting Help in Excel
• The Quick Access Toolbar
• The Tab/Toolbars

CREATING A SIMPLE WORSHEET

• Entering Data
• Understanding Calculations in Excel
  • Doing Maths Calculations
  • AutoSum and Manually Entering the Function
  • Calculating a Percentage
  • Copying Formulas
  • Absolute vs Relative cell References

EXCEL BASICS

• Working with Excel
  • Columns, Rows, Cells and Ranges
  • Creating Worksheet Labels
  • Entering and Deleting Data
  • Printing your Worksheet

• Moving your Data
  • Dragging and Dropping Cells
  • How to Cut, Copy, and Paste Cells
  • Insert and Delete Cells,Rows, and Columns
  • Using Undo, Redo, and Repeat

• Editing Tools
  • Using Spell Check

EDITING YOUR WORKBOOK

• Modifying Cells and Data

  • Changing the Size of Rows or Columns

  • Adjusting Cell Alignment

  • Rotating Text

• Cell 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

PRINTING AND VIEWING YOUR WORKBOOK

• The different Views in Excel

• Managing a Single Window

• 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

  • Print Preview

  • Fitting Data onto a Printed A4 Page

  • Margins

  • Headers and Footers

  • Printing Gridelines

  • Marking Only a Certain Area to be Printed
    • Permanently
    • Temporarily
  • Changing between Portrait and Landscape
  • Centring your Printout
  • Stopping Rows or Columns from Disappearing when you Scroll Down
  • Forcing Row Headings to Repeat when Printed

INTRODUCTION TO CHARTS

• Working with Charts, Part 1
  • Creating a Chart
  • Formatting a Chart
  • Modifying Charts with the Layout Tab
  • Enhancing a Chart with Shapes and Graphics