EXCEL 2003: CORE

Course Objectives:
 To learn the Excel 2003 program to Microsoft Office Specialist Level

Course Content:

  • Creating a worksheet 

  • Selecting cells & ranges, alignment, merging cells 

  • Inserting & deleting rows, columns, auto fill

  • Auto complete, hide and unhide freezing panes, 

  • Borders, formatting, formulas, absolute referencing 

  • 3D referencing, wrapping text, adding comments 

  • Sum, count, average, max & min functions

  • Now and if functions, PMT & FV functions

  • Auto filter, find & replace

  • Chart wizard, bar & pie charts,

  • Inserting pictures & hyperlinks


EXCEL 2003: EXPERT

Course Objectives:
 To learn Microsoft Office Word 2003 to an Expert level

Course Content:

  • Create a template, workspace file, custom formats & conditional formatting

  • Printed multiple workbooks, naming ranges, finding trends in data

  • Create macros, set security levels for macros, add macros to toolbars

  • Apply data validation rules, add input messages & error alerts

  • Tracing precedents & dependents, tracing errors, advanced filter

  • Summarise data with totals & subtotals DSUM & DAVERAGE

  • Create a pivot table

  • Use goal seek, and create what-if analysis

  • Protect worksheets, apply and remove passwords, track changes

  • Insert an embedded and linked objects, 

  • Save as a web page, mapping data in a workbook, saving as xml documents


Benefits

  • A personal workbook to use as a reference guide on completion of the course

  • The opportunity to gain the widely recognised Pitman Training Certificate

Duration: 20 hours each




( 020 7256 6668

      



  HOME   INVEST IN YOUR TEAM   INVEST IN YOUR CAREER   ABOUT US   COURSES   CONTACT US  

MICROSOFT   SHORTHAND   KEYBOARD SKILLS   DIPLOMAS   BOOKKEEPING   SEMINARS   QUALIFICATIONS   COURSE DATES  

PITMAN TRAINING LONDON
CITY WEST END BANK OXFORD CIRCUS
MICROSOFT OFFICE SKILLS KEYBOARD TYPING IT SHORTHAND ACCOUNTS BOOKKEEPING SECRETARIAL DIPLOMAS
ECDL MOS EXAMS MICROSOFT WORD EXCEL POWERPOINT ACCESS OUTLOOK FRONTPAGE 2003 2007
WARNFORD COURT 29 THROGMORTON STREET LONDON EC2N 2LT
WALMAR HOUSE 288 REGENT STREET LONDON W1B 3AL