Etopia Computer Training

Training Room Hire

Our Glasgow training room facilities are available for hire.

Microsoft Excel Intermediate IT Training Course

Duration:1 day
Price:£200.00
Locations:Glasgow, Edinburgh
Glasgow Dates:Wed 21st Mar 18,  Wed 4th Apr 18,  Wed 9th May 18,  Wed 6th Jun 18
Edinburgh Dates:

Dates above and cost (excludes VAT) are for joining a scheduled course. 

Or book Private Group from £395 + VAT or book 1-to-1 from £200 + VAT.

One 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