Events Details

Business and careers, Training and learning : Microsoft Excel Advanced
Book this event online
Open.. from 08/07/2008 to 08/07/2008
Starts: 09:30 to 16:30
Description:

Developed for business users and individuals who wish to advance their knowledge of spreadsheets.

  • Splitting a worksheet into panes
  • Freezing Panes
  • Cell Protection
  • Using defined cell names
  • Relative and absolute addressing
  • Linking worksheets and workbooks
  • Consolidate worksheets
  • Custom formatting
  • Conditional formatting
  • Creating an Autofill list
  • Filtering and Validating
  • Filtering Records
  • Vlookup and validating enteries
  • If function
  • SUMIF and COUNTIF functions
  • Statistical and Financial functions
  • Generating frequency distributions
  • PMT functions
  • CUMIPMT function
  • Date and timefunctions
  • Macros
  • What if - Utilities
  • Goal seek
  • Using Goal Seek and charting
  • Charts
  • PIVOTTABLE terminology
  • Creating a pivot table report
  • The onscreen layout

Requirements: Clients are expected to have a good working knowledge of Windows and the basics of Excel.

Outcome: Increased understanding of how to use the advance facilities of MS Excel.

Materials: Full course notes booklet.

Trainer: Martin McLauchlan

This course costs £65.00 plus VAT per person
Contact: Merkinch Technology Centre (event)
Phone: 01463 240 085 (event)
Fax: 01463 717 977 (event)
Email: info@merkinch.com (event)
Web: http://www.merkinch.org.uk (event)
Venue: Merkinch Enterprise
Address: 14 Grant Street
Inverness
Highland
Description: Technology and training centre.
back