Advanced Excel

4th May 2017
9:30 am - 5:30 pm

Location:
James O'Keeffe Institute,

Places remaining: 12

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

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

Download a Full Course Outline by Clicking Here: Advanced Microsoft Excel

 

Duration: 1 Day

Time: 9.30am – 5.30pm

 

*** A Limited Number of Free Places are Available for those in receipt of a Welfare Payment. For further details please contact Louise on 029-60633 / louise.bourke@irdduhallow.com ***

Keep this field blank:
Not all required fields are present in the booking form.
Since this is a multiprice event, make sure you changed the setting 'Registration Form Format' for the event to include #_SEATxx placeholders for each price.
See the documentation about multiprice events.

Registration Form

First Name *
#REQ_FIRSTNAME
Last Name *
#_LASTNAME
E-Mail *
#_EMAIL
Phone number:*
#REQ_PHONE
Company
#_FIELD{1}
Address
#_FIELD{2}
Apply for Subsidised Place * (if any spaces remain).
#_SPACES{1}
Book a Place on the course
Pay now via paypal
#_SPACES{2}
Comments / Special Requirements
#_COMMENT
#_CAPTCHAHTML{Please fill in the code displayed here:#_CAPTCHA}
#_SUBMIT

*For Social Welfare Recipients. See Eligibility Criteria

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