Loading Events

Microsoft Excel – Office 365, 2016 & 2019- Advanced Level

Details

Date:
August 24
Time:
8:30 am - 3:30 pm
Cost:
€225
Event Category:
Website:
www.islandtraining.ie

Venue

Online

Event Description

Course Aim:

This course is designed for people who have an excellent knowledge of Excel up to intermediate level. On completion of this advanced course, candidates will have the necessary skills to produce complex documents using all the tools and functions available to them in Excel.

Client Profile:

Candidates should be proficient in using Excel up to an intermediate standard and be competent in the use of file management.

Course Outline:

Microsoft Excel 365 / 2010 / 2013 / 2019

  • Data Validation & importing into Excel
  • Working with Macros
  • Creating queries
  • Customising Excel
  • Using shared workbooks
  • The Paste Special function
  • Creating and applying a template
  • Using styles and data tables
  • Using scenario manager and solver
  • File protection
  • Using data validation
  • Creating Slicers
  • Creating Spark lines
  • H & V Lookups
  • Pivot Tables
  • Pivot Charts
  • Advanced Functions
  • Advanced Formatting
  • Working with comments
  • Sending a worksheet as an attachment
  • Linking Sheets
  • Hyperlinks in Excel
  • Using Custom Lists
  • Embedded objects within Excel & Word
  • Finding duplicates in Excel

Course Location:

Killarney, Kerry | Macroom | Cork City | Online

Course Available as Daytime Training | Night Classes | One-to-One | Online

Course Certification:

ICDL, MOS, Microsoft Application Specialist

Course Duration:

1 Full Day.  Please contact Island Computers & Training for more details.

Book Now

Details

Date:
August 24
Time:
8:30 am - 3:30 pm
Cost:
€225
Event Category:
Website:
www.islandtraining.ie

Certifying Body:

Microsoft - ICDL - ICDL Advanced

Tickets

The numbers below include tickets for this event already in your cart. Clicking "Get Tickets" will allow you to edit any existing attendee information as well as change ticket quantities.
MS Excel ADV
225.00
Unlimited

August 24 @ 8:30 am - 3:30 pm

Any Questions?

If you have any questions or queries about this course,
please get in touch with us through the contact form.