About Us
21BIZ is a business training course center based at Elstree Film Studios, Borehamwood, Hertfordshire, home to many famous TV and Film Productions including Big Brother, Dancing on Ice and Who Wants To Be A Millionaire.

21BIZ run a variety of business, marketing and office related courses including business startup, business marketing techniques and a range of Microsoft Office training courses.

Please browse our courses on the right and we look forward to welcoming you at 21BIZ.

Home - Microsoft Office Training Courses - Microsoft Excel 2007 Intro



In our introduction to Microsoft Excel 2007 training course you will learn how to create and edit basic Microsoft Excel 2007 worksheets and workbooks and therefore gain the skills necessary to create, edit, format, and print basic Microsoft Excel 2007 worksheets. This includes how to explore the Microsoft Excel 2007 environment and create a basic worksheet, perform calculations, modify a worksheet, format a worksheet, print workbook contents and how to manage large workbooks.

Duration: 1 day.

Location: 21st Century New Media Ltd, Elstree Film Studios, Shenley Road, Borehamwood, Hertfordshire, WD6 1JG. [Click here for a map]

Times: 10.00am to 4.30pm. For security reasons, further details are only provided upon booking.

Equipment: Our fully featured training room includes six top-of-the-range iMac computers configured to work in both Macintosh (OSX) and PC (Windows) modes, ensuring you the maximum familiarity with your chosen operating system.

Accommodation: Details of local accomodation can be found here.

Further assistance: Our FAQ help page contains the answers to many popular questions. Alternatively please call 0844 844 2428 to arrange to speak to our training manager.

COURSE CONTENT


Creating a Basic Worksheet

  • Explore the User Interface and the Ribbon
  • Navigate and Select in Excel
  • Obtain Help
  • Enter Data and Save a Workbook
  • Customize the Quick Access Toolbar

Performing Calculations

  • Create Basic Formulas
  • Calculate with Functions
  • Copy Formulas and Functions

Modifying a Worksheet

  • Manipulate Data
  • Insert and Delete Cells, Columns, and Rows
  • Search for Data in a Worksheet
  • Spell Check a Worksheet

Formatting a Worksheet

  • Modify Fonts
  • Add Borders and Color to Cells
  • Change Column Width and Row Height
  • Apply Number Formats
  • Position Cell Contents
  • Apply Cell Styles

Printing Workbook Contents

  • Print Workbook Contents Using Default Print Options
  • Set Print Options
  • Set Page Breaks

Managing Large Workbooks

  • Format Worksheet Tabs
  • Manage Worksheets in a Workbook
  • Manage the View of Large Worksheets

5-15% discount if you book for more than one delegate!
Further discounts are available when booking multiple courses,
Please call our training secretary on 0844 844 2428.

Schedule your own Excel 2007 Intro training course
Please tell us where and when YOU would like to attend this course.
If we are able to schedule the course we will contact you.


Course  Enter a custom course
Month
Time
Location
First Name *
Last Name *
Telephone Number *
Email Address *


If you cannot easily read the two words above,
click on the icon that has two arrows chasing each other
and new words will be displayed for you.



More Courses

In addition to the courses displayed here at 21BIZ, we also run two other websites offering their own specific courses. The courses listed below are our web design training courses which we run at 21st Century New Media Ltd operating out of Elstree Film Studios, Hertfordshire.

New Courses for 2012
Web Site Design Courses / Web Development Courses
Web Site Programming Courses
Web Marketing Courses / Search Engine Optimisation (SEO) Training Courses
Web Site Management Courses
Video Editing Courses
Graphic Design Courses / Print Courses


Our second dedicated training website is the Elstree Film School, where we run a variety of Film, TV and Video training courses, also operating out of Elstree Film Studios, Hertfordshire.

Industry Introduction Courses
Digital Video Camera Courses
Video Editing Courses
Scriptwriting Courses