Etopia Computer Training
IT Computer Training Experts
Discounts of 25% & Tailored from £295!
25% Off Scheduled Courses! Aug & Sep 2010

Upcoming Courses

Call for any late availability offers on these upcoming courses.

Training Room Hire

Our Glasgow training room facilities are available for hire.

Microsoft Excel Intermediate 2002/3

Duration:2 days
Price:£495.00
Locations:Glasgow, Edinburgh
Glasgow Dates:Wed 29th Sep 10,  Mon 25th Oct 10,  Mon 29th Nov 10,  Thu 9th Dec 10
Edinburgh Dates:Mon 25th Oct 10,  Thu 9th Dec 10

Two Day Course

This course is intended to allow people with an existing knowledge of working with basic spreadsheets within Excel to move on to the next level of ability including working with more complex spreadsheets, analysing and presenting data.

Course Aims to enable delegates to:

Produce more professional spreadsheets and charts using Microsoft Excel and build on existing knowledge to manipulate and analyse data. The training is designed for existing Excel users wanting to increase their skills.

Course Content

Working with Large Spreadsheet

  • View options
  • Hiding/displaying data
  • Printing large worksheets

Working with Multiple Worksheets

  • Using multiple worksheets
  • Linking worksheets by using 3-D formulas
  • Managing workbooks

Advanced Formulae

  • Logical Statements
  • Lookups

Documenting and Auditing

  • Comments and Text Boxes
  • Auditing features
  • Protecting cells

List Management

  • Creating lists
  • Sorting and filtering
  • Lists
  • Advanced filtering

Advanced Formatting

  • Borders and shading
  • Special number formats
  • Dates
  • Styles
  • Conditional formatting

Customizing Excel

  • Formatting chart options
  • Adding graphic elements

Follow-on Courses

Microsoft Excel Advanced

Requirements before booking this course:

This course is for people who wish to expand on their current knowledge of Microsoft Excel. Anyone attending the course should either have attended Excel Foundation, or have and equivalent knowledge.

Notes

Training is available on all versions