Advanced Excel

15th November 2017
9:30 am - 5:30 pm

Location:
Le Cheile
Mallow
Places remaining: 10

There are a limited number of Free places on most courses available for those in receipt of a welfare payment. Eligibility Criteria
Terms & Conditions - Click Here

Advanced Excel

Start Date: 15th Nov
Day of the Week: Wed
Time: 9:30am -5.30pm
Time: Duration: 1 Day
Venue: Le Cheile Mallow
Tuition Fee: €100
Accreditation: Certificate of Attendance.

Course Description:
This course is designed for people who have and 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.
This Course will Cover:
• Data importing into Excel
• Build & Work with Macros
• Creating queries using Filters
• Customising Excel
• Using shared workbooks
• Creating and applying a template
• Using styles and data tables
• Using scenario manager and solver
• File protection
• Using data validation
• Using Sub totals
• Auditing Tools
• If & Formula
• Multiple IF Statements
• H & V Lookups
• Pivot Tables
• Pivot Charts
• Advanced Formatting
• Linking Sheets
• Embedded objects within Excel & Word

Bookings no longer allowed on this date.

Advanced Excel

15th November 2017
9:30 am - 5:30 pm

Location:
Le Cheile
Mallow
Places remaining: 10

There are a limited number of Free places on most courses available for those in receipt of a welfare payment. Eligibility Criteria
Terms & Conditions - Click Here

Advanced Excel

Start Date: 15th Nov
Day of the Week: Wed
Time: 9:30am -5.30pm
Time: Duration: 1 Day
Venue: Le Cheile Mallow
Tuition Fee: €100
Accreditation: Certificate of Attendance.

Course Description:
This course is designed for people who have and 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.
This Course will Cover:
• Data importing into Excel
• Build & Work with Macros
• Creating queries using Filters
• Customising Excel
• Using shared workbooks
• Creating and applying a template
• Using styles and data tables
• Using scenario manager and solver
• File protection
• Using data validation
• Using Sub totals
• Auditing Tools
• If & Formula
• Multiple IF Statements
• H & V Lookups
• Pivot Tables
• Pivot Charts
• Advanced Formatting
• Linking Sheets
• Embedded objects within Excel & Word

Bookings no longer allowed on this date.

Share...
Tweet about this on TwitterShare on FacebookShare on Google+Pin on PinterestShare on LinkedInEmail this to someone