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 2003 Advanced



In our advanced Microsoft Excel 2003 training course you will learn how to automate some common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications. This includes how to customize workbooks, collaborate with others using workbooks, audit worksheets, analyze data, work with multiple workbooks, import and export data and how to structure workbooks with XML.

Please note that this course has now been discontinued. Please refer to our current Microsoft Office training courses listed on our homepage.

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


Streamlining Workflow

  • Create a Macro
  • Edit a Macro
  • Customize Access to Excel Commands
  • Apply Conditional Formatting
  • Add Data Validation Criteria
  • Update a Workbook's Properties
  • Modify Excel's Default Settings

Collaborating with Others

  • Protect Files
  • Share a Workbook
  • Set Revision Tracking
  • Review Tracked Revisions
  • Merge Workbooks
  • Adjust Macro Settings
  • Administer Digital Signatures

Auditing Worksheets

  • Trace Cell Precedents
  • Trace Cell Dependents
  • Locate Errors in Formulas
  • Locate Invalid Data and Formulas
  • Watch and Evaluate Formulas
  • Group and Outline Data

Analyzing Data

  • Create a Trendline
  • Create Scenarios
  • Perform What-If Analysis
  • Develop a PivotTable Report
  • Develop a PivotChart Report
  • Perform Statistical Analysis with the Analysis ToolPak

Working with Multiple Workbooks

  • Create a Workspace
  • Consolidate Data
  • Link Cells in Different Workbooks
  • Edit Links

Importing and Exporting Data

  • Export to Microsoft Word
  • Import a Word Table
  • Import Text Files

Structuring XML Workbooks

  • Develop XML Maps
  • Import, Add, and Export XML Data
  • Manage XML Workbooks
  • Apply XML View Options

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 2003 Advanced 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.



Help
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


21st Century New Media Ltd, Elstree Film Studios, Borehamwood, Hertfordshire WD6 1JG.
Tel: 0844 844 2428     Email: enquiries@21biz.co.uk

Network sites: 21NewMedia | The Elstree Film School | 21BIZ | 21stCentury | 21CTV
Elstree Film Talent | Creative Herts | Holistic Herts | Clifford White