Inspire IT has delivered training in Dublin, Waterford, Kilkenny, Sligo, Galway, Donegal, Tipperary, Athlone, Dundalk, Kerry and Wexford.

Typically our courses are delivered in one day, to groups of upto 8 delegates, at your location. This keeps your costs down, and allows your staff to learn in a familiar environment. If you don't have your own training facility, then we can deliver training at a location to suit you, which you can arrange yourself or we can do that for you.

We will travel onsite anywhere in Ireland

Prior to to course we will discuss your requirements and develop the course content to suit your needs.

• All participants receive handouts and course files of the course content if they want to review the information at a later date.
• 6 months FREE Support after course.
• Inspire IT are flexible with start and finish times for courses. We have delivered training courses that started at 7am and finished at 2pm due to clients preference.

For more information please E-mail Alan Joyce at info@inspiresit.ie or contact him at 085 1055651 or Skype inspireitweb

Navigation & Data input

• Quick Navigation of spreadsheets
• Accurate selection of large amounts of data
• Shortcut Keys
• Named Ranges, modifying & deleting
• Custom Lists, creation & deleting
• Using AutoFill to create numbered sequences

Functions: IF & VLookups

• Absolute Addressing
• Using the IF Function – Using the Paste Function
• Using the Vlookup
• Count IF and Count A
• Nested IF
• Shortcut to view all formulaes
• Auditing Toolbar

Data & Form

• Data & Form
• Using the Form to search for records
• Adding records using the Form

Advanced Filter

• Using the AutoFilter
• Using the Advanced Filter
• Filtering Results to another area of spreadsheet

Auditing Toolbar

• Using the Auditing Toolbar
• Tracing Precedents
• Tracing Errors in Formulaes

Protection

• Protecting Worksheets
• Protecting Workbooks
• Protecting parts of a spreadsheet
• Placing a password on the file