COURSE FINDER

Microsoft Office Specialist (MOS)Excel 2003 Expert Level

£351 per delegate. This may be less for special offers on specific course dates and in-company training courses

Duration: 2 days

Trainer: L082AQ

Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...

Microsoft Office Specialist (MOS)Excel 2003 Expert Level

Overall Aim:
This course will cover all of the listed examination topics for the MOS: Expert Level for Excel 2003.

Target Group:
Any PC user who wishes to attain MOS certification.

Pre-requisites:
Delegates must have previously attended the MOS Excel 2003 Core Level course of be familiar with all of the elements of the Core course objectives.

Course Outline:
Organising and Analysing Data
- Use subtotals
- Define and apply advanced filters
- Group and outline data
- Use data validation
- Create and modify list ranges
- Add, show, close, edit, merge and summarise scenarios
- Perform data analysis using automated tools
- Create PivotTable and PivotChart reports
- Use Lookup and Reference functions
- Use Database functions
- Trace formula precedents, dependents and errors
- Locate invalid data and formulas
- Watch and evaluate formulas
- Define, modify and use named ranges
- Structure workbooks using XML

Formatting Data and Content
- Create and modify custom data formats
- Use conditional formatting
- Format and resize graphics
- Format charts and diagrams

Collaborating
- Protect cells, worksheets, and workbooks
- Apply workbook security settings
- Share workbooks
- Merge workbooks
- Track, accept, and reject changes to workbooks

Managing Data and Workbooks
- Import data to Excel
- Export data from Excel
- Publish and edit Web worksheets and workbooks
- Create and edit templates
- Consolidate data
- Define and modify workbook properties

Customising Excel
- Customise toolbars and menus
- Create, edit, and run macros
- Modify Excel default settings
The course either has new dates in data loading, or is only run as a dedicated or In Company course.
  • 1UPACCESS Logo
  • BAM Construction Training Logo
  • Gold Cross Training Services Logo
  • Citrus Training Logo
  • 3B Training Logo
  • Astutis Logo
  • Construction Industry Training Providers Logo
  • MecSafe Logo
  • Health Life and Safety Logo
  • CSM Services Logo
  • MI Construction Training Logo
  • Innov8 Training Logo
  • BSI Training Logo
  • OM Safety Training Logo
  • TotalComms Training Logo
  • SDA Safety Logo
  • Construction Skills People Logo
  • Phoenix Health and Safety Logo
  • Complete Health and Safety Logo
  • Courtley Health and Safety Logo
  • Harris Safety Training Logo
  • First Response Training Logo
  • CTA logo
  • Alliance Learning Logo
  • Le Breton Training Logo
  • Murphy Logo
  • ALS Safety Logo
  • KeyOstas Logo
  • Libben Health and Safety Logo
  • Compass Management Solutions Logo
  • Global Management Academy Logo
  • Illumine Logo
  • Corporate Risk Systems Logo
  • ATC Risk Management Logo
  • CCAS Health and Safety Logo
  • MGM Training Logo
  • ROSPA Logo
  • PJH Safety Training Logo
  • OMS Logo
  • Tala Training Logo
  • PRS Health and Safety Training
  • Mainport Training Logo
  • SSG Training and Consultancy Logo
  • RB Services Logo
  • Safety Training Services Logo
  • Clarkson Evans Training Logo
  • Lighthouse Training Logo
  • MST Solutions Logo
  • SWL Training Logo
  • The Building Safety Group Logo
  • ProSafety Logo
  • Genesys Training Logo
  • Total Training Solutions Logo
  • Kentec Training Logo
  • Total Electrical Training logo
  • NTSS logo
  • C&C Training Logo
  • Safe Life Logo
  • IQMS Logo
  • Frinton Training logo
  • UCT logo
  • Envesca logo
  • The Safety Maintenance Company logo
  • Arthur Adams logo
  • APT Health and Safety logo
  • Sandwell Training Association logo
  • PC Workshops logo
  • Zero Harm Training logo
  • R2 Training logo
  • Whites forklift training logo
  • The Bradley Group logo
  • Risk Health and Safety logo
  • Wise Global Training logo
  • Smallpeice Enterprises logo
  • Total Training Company Logo
  • Sibbald Training logo
  • Highlander logo
  • Total Construction Training logo
  • e-testing logo
  • UTN Training logo
  • 1st Line Defence logo
  • Ideal IT training logo
  • PQMS Training logo
  • Paradise Training logo
  • Collective Safety Solutions logo

Telephone Hotline

01933 233884

(Monday to Friday - 8:00am to 5:30pm).

© 2017 Book My Course Limited. All rights reserved

Home | About Us | Contact Us | FAQs | Privacy Policy | Terms & Conditions | Site Map | News / Articles | Cookie Policy