Business Training Ireland

Follow Us on FacebookFollow Us on Google+Follow Us on TwitterFollow Us on RSSFollow Us on E-mail
  • Home
  • Business Training
    • Sales Skills
    • Customer Care
    • Start your own business
    • Presentation Skills
    • Management Training Courses
      • Certificate in Business Management Course – FETAC Level 6
      • Management Skills for New Managers
      • People Management Course
      • Supervisory Management Development Programme
      • Effective Time Management Course
      • Team Leader Skills Course
      • Sales Management Course
      • Frontline Management Course
    • Project Management Courses
      • CAPM (Certified Associate in Project Management) Certification Course
      • PMP (Project Management Professional) Certification Course
      • Project Management Certificate
      • Prince2 Course – Practitioner
      • Project Management Certification
      • Business & Report Writing Skills Course
    • Sales Training Courses
      • Sales Training Course
      • Advanced Supervisory Management Course
      • Presentation Skills Course
      • Managing Successful Meetings Course
      • Chairing Effective Meetings Course
      • Coaching & Mentoring Skills Course
      • Assertiveness Skills Course
      • Communication Skills Course
      • Executive Secretary Training Course
      • Corporate Training
    • Customer Care Training Course
      • Customer Service & Complaint Handling Course
      • Professional Telephone Skills Course
      • Executive Secretary Training Course
      • Debt Collection Course
      • Effective Time Management Course
      • Receptionist Skills Course
      • Professional Telephone Skills Course
      • Communication Skills Course
    • Finance Training Courses
      • Finance for Non-Financial Managers Course
      • Digital Marketing Courses
      • Interviewee Skills Course
      • Supervisory Management Course
    • Human Resources Training Courses
      • Certificate in Train the Trainer Course – FETAC Level 6
  • Microsoft Office Courses
    • Microsoft Office Onsite Training Service
      • Microsoft Office Onsite Training Service Enquiry Form
    • Microsoft Excel Training
      • Microsoft Excel Training
      • Microsoft Excel Courses
      • Microsoft Excel – Introduction
      • Microsoft Excel – Intermediate
      • Microsoft Excel – Advanced
      • MS Excel Training
      • Advance Microsoft Excel Training
    • Microsoft Word Training
    • Microsoft Powerpoint Training
      • Microsoft PowerPoint – Introduction
      • Microsoft PowerPoint – Advanced
    • Microsoft Access Training
      • Microsoft Access – Introduction
      • Microsoft Access – Advanced
      • Microsoft Access – Intermediate
    • Microsoft Project Training
      • Microsoft Project Introduction
      • Microsoft Project Advanced
    • Microsoft Publisher Training
      • Microsoft Publisher – Introduction
      • Microsoft Publisher – Advanced
    • Microsoft Outlook Training
    • Microsoft Office 2010
    • Office 365
    • Microsoft Suite Courses
    • Microsoft Office
    • Microsoft Certification Training
  • Computer Training
    • Business ICT Courses
      • Onsite training
    • Design and Print
      • Website Design Course
      • Adobe Dreamweaver
    • Web Courses
      • Build your Online Business
      • Internet Marketing & SEO
      • WordPress
  • Our Clients
  • Training Venues
    • Course Timetable
      • IT Training Timetable
  • Enquiry Form
    • Training Instructors
You are here: Home / Microsoft Excel – Advanced

Microsoft Excel – Advanced

Course Description

This course explains how to use Microsoft Excel for advanced spreadsheets use.microsoft excel
This course is intended for those who are experienced in Excel or have completed the Intermediate level Excel course.

Course Content

  • Creating Tables in Excel
  • Advanced formulas and functions
    • Database Functions
    • Text Functions
    • Lookup, Index and Match
    • Array Formulas
  • Advanced List managementComputer-Training
  • Importing & Exporting Data
  • What If Analysis
    • Scenarios,
    • Data Tables,
    • Goal Seek
  • Spreadsheet Security
  • Working with Macros
    • Creating a Macro
    • Inserting a Macro
    • Assigning a macro to a button
  • Forms and Form controls in Excel

Course Duration

One full day 9.30 am – 4.30 pm

Course Fee

Course fee is €195 per person

*Discount for multiple or group bookings

Training Locations

We have training locations in Dublin, Naas, Cork, Limerick, Galway, Sligo & Waterford.
We can also provide onsite training in a group or one to one basis.

Training Dates

For public training dates at our regional training locations see here

Enquiries

If you would like further information please complete our online enquiry form

Please call us on 1800 250350 to chat with one of our staff.
click map

Training Timetables Training Enquiry

 

Back to the Main Excel Menu

our clients

Contacting US

Here is how to Contact Us

1. Call us on 1800 250 350 
2. Feedback Form or Complete our Inquiry form here

Or via any of our Social Media Channels
Listed to the Right of this Page.

Recent Posts from us

  • 10 Tips for Microsoft Outlook
  • New Windows 10 and Office 365 management and user experiences
  • 5 Skills you can Learn in under 5 Hours!
  • Top 20 Microsoft Outlook Tips
  • How to create a Google form

Follow Us!

Follow Us on FacebookFollow Us on TwitterFollow Us on RSSFollow Us on E-mailFollow Us on Google+

Copyright © 2019 · Log in